Export Terminal Account History to (Excel) Spread Sheet for Analysis - page 2

To add comments, please log in or register
rv
461
rv  
FourX:

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.


sent you pm
Oldie
6
Oldie  
FourX:

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.

Would you also pm me with directions on how to achieve a single line for each trade in excel.

Thanks in advance: Oldie

ATA sabetnejad
96
ATA sabetnejad  

hope this expert will help

Emmanouil Chaniotakis
210
Emmanouil Chaniotakis  
ATA sabetnejad:

hope this expert will help


This is very helpful. Thanks.

Noctambull
10
Noctambull  

Practical SOLUTION

Export Statement to an HTML file, open it with FireFox browser

Select with your mouse ONLY the content from transactions, starting with the (table) fields of the columns:

TicketOpen TimeTypeSizeItem PriceS / LT / PClose Time PriceCommissionTaxesSwapProfit


and down ending with the last transaction, without including the rest, like follows to my example with last 3 transactions:

...

297707142017.05.16 15:44:10buy0.01vixx12.180.0013.182017.05.17 14:53:3013.180.000.00-0.0110.00
  [tp]
295350052017.04.07 16:19:55buy0.01xauusd1265.560.000.002017.04.11 15:33:151272.260.000.00-0.286.70
297707042017.05.16 15:41:43buy0.10xauusd1237.800.001255.052017.05.17 13:26:211255.050.000.00-1.36172.50

Next step: open a Calc sheet with OpenOffice (version 4.1.3) and PASTE it.

Michaela Zinke
352
Michaela Zinke  

Hi,


this thread is very, very old, but I am looking for a possibility to export the history of mt4 to excel.

I found this expert here, but I don't know, how to use it - coul/would anybody explain this to me, please?

kind regards

Ela

Michaela Zinke
352
Michaela Zinke  
ATA sabetnejad:

hope this expert will help

This one I mean ...
richard96816
474
richard96816  

It's pretty surprising there's not a full solution to this problem easily available.

Or even an option in MT4 to keep an up to date copy of this data in a file.

Mike Tanton
464
Mike Tanton  
It can be a bit tricky at first (getting the correct data to the correct Excel "Cells" etc.)... but once you get to know how it works then it is actually quite simple... Start off with the Excel_DDE_Test.mq4 (Google it)... get to know how it works and then modify it to what you need... Unfortunately, you are going to have to put in a few hard yards here... but, it is a useful 'thing' to know how to do...
12
To add comments, please log in or register