This forum is now read-only. You can discuss you questions on Forums of MQL4.community and MQL5.community

Account History Profit problem


Back to topics list
avatar
100
mpfx 2006.03.14 00:16 
Hi MT,

I like to transfer my account history to Excel for further analysis.
The problem is in the profit column.
There is a space that seperates the thousands column which Excel cannot read.
Example:
2006.03.07 01:56 buy 11.1 usdchf 1.3019 1.3112 0.0000 2006.03.13 09:02 1.3126 0 295.75 9 048.45

If this could be changed to either 9048.45 or even 9,048.45 it would be great...

Thanks and as always keep up the great work.....
avatar
5
Knuckle 2008.10.21 19:02 
mpfx :
Hi MT,

I like to transfer my account history to Excel for further analysis.
The problem is in the profit column.
There is a space that seperates the thousands column which Excel cannot read.
Example:
2006.03.07 01:56 buy 11.1 usdchf 1.3019 1.3112 0.0000 2006.03.13 09:02 1.3126 0 295.75 9 048.45

If this could be changed to either 9048.45 or even 9,048.45 it would be great...

Thanks and as always keep up the great work.....

Hi MT,

Please can you let me know if there was a solution to this problem as I also export the account history into Excel and the space in the "thousands" causes errors in calculating etc.

Regards

Knuckle
avatar
Moderator
3289
Rosh 2008.10.21 20:09 
Set up region language settings.
avatar
5
Knuckle 2008.10.28 22:52 
Rosh :
Set up region language settings.

Hi Rosh,

Please can you elaborate on this. Where do I find the "region language" settings? I assume it is not the normal "view --> Languages" setting?

Regards

Knuckle
avatar
Moderator
3289
Rosh 2008.10.29 17:33 

I hope my picture helps you :)
avatar
350
phy 2008.10.29 20:40 

Mine is set to English (United States)... spaces in numbers don't make sense here.
avatar
Moderator
3289
Rosh 2008.10.30 08:23 
Save Statement as HTML Document and then open with Excel. Does this way work?
avatar
5
Knuckle 2008.10.30 12:01 
This does not help. With the space in the thousand value (2 000 rather than 2000), excel does not calculate the cell at all i.e. if you are auto summing up cells for example 2 000.00 and -100.00, the result will be -100 and not 1 900.00 as expected.
avatar
5
Knuckle 2008.11.04 10:46 
Is there any new ideas on this. How can we export the account history to Excel without the spaces in the thousands?
Back to topics list