I'm trying to figure out how to export the Account History and get it into an (Excel) Spread Sheet for Analysis.
I did a search, but didn't find a solution.
Thanks to any and all for any assistance.
I'm trying to figure out how to export the Account History and get it into an (Excel) Spread Sheet for Analysis. [...]
I have tried and done that G0rdon. The problem is that the HTML file format is not directly compatible with Excel. Specifically their is a CRLF <Enter> before the end of each record that wraps it down to a second line that ends up messing up the record when it is pasted into the SpreadSheet. I was hoping to be able to either directly save it as a CSV file or convert it from the HTML report file to a CSV that is more compatible with SpreadSheets without having to manually edit each and every record to get it into a usable format.
Though I was unable to find one here, I was hoping that perhaps someone had made a script file or some other method for this already. It is very unlikely that I am the first person to want to do this and run into this problem.
You tried to save the file with the extension ("XLS" not with "HTM")
Nope, but will try it thanks.
I know from previous searches that there are a number of MT4 <=~=> Excel interfaces. I'll revisit these and look for something useful there as well. I'll post the results here if I come up with anything useful.
'Publish' the ForEx account free to MyFxBook.Com, a sight set up specifically for this purpose.
, In your web browser from the Portfolio tab, view the account that you want to get into an (Excel) Spread Sheet.
, In the upper right hand corner, select either the csv or the HTML :
,, The HTML version will be shown in your web browser, which you can then save.
,, Selecting the CSV version will prompt you to save the report in this 'Comma Separated Values' format.
,,, The HTML version has more information in the header about the account.
,,, The CSV . version has all of the columns of data in it.
Loop Bars or orders or history ... FileOpen(FILE_CSV|FILE_READ|FILE_WRITE)... FileSeek (SEEK_END) ...FileWrite ...FileClose
FileOpen(FILE_CSV|FILE_READ|FILE_WRITE)... FileSeek (SEEK_END) ...(Loop Bars or orders or history and FileWrite) ...FileClose
Excel usually can open and convert CSV without problems
Thanks for the Info and assistance EA Developer. Having very limited
MQL programming experience in general and none with generating saved
files I'm not even sure what you mean by 'Loop around.
As initially noted, I can load the saved CSV files into Excel. However it puts a 'line feed' before the end of the data from each trade and locates them below the rest of the info which makes them into useless MishMash unless I fix each trade manually one by one. I did try making a macro in Excel 2007 for this, but had no luck with it either
This won't help me with Commercial Bots that I do not have the source code for. However as you may have seen above, I have an easily accommodated and successful 'WorkAround' solution for these instances.