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

[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

[[Deleted]]

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]

hope this expert will help

[Emmanouil Chaniotakis]

ATA sabetnejad:

hope this expert will help

This is very helpful. Thanks.

[Noctambull AM]

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:

Ticket

Open Time

Type

Size

Item

Price

S / L

T / P

Close Time

Price

Commission

Taxes

Swap

Profit

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

...

29770714	2017.05.16 15:44:10	buy	0.01	vixx	12.18	0.00	13.18	2017.05.17 14:53:30	13.18	0.00	0.00	-0.01	10.00
										[tp]
29535005	2017.04.07 16:19:55	buy	0.01	xauusd	1265.56	0.00	0.00	2017.04.11 15:33:15	1272.26	0.00	0.00	-0.28	6.70
29770704	2017.05.16 15:41:43	buy	0.10	xauusd	1237.80	0.00	1255.05	2017.05.17 13:26:21	1255.05	0.00	0.00	-1.36	172.50

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

[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]

ATA sabetnejad:

hope this expert will help

This one I mean ...

[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]

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...

[Geoff Taylor]

Ignore all these complicated geek generated solutions, just go to https://www.youtube.com/watch?v=5ebVe95qvR4