Better CSV export

[Radek]

Hi,
I like many others use excel for analyzing of outputs from Forex tester and I would like to sugest some improvements to export functions from Forex tester. Now if I want to import files to excel I have to do quite a few steps manually, which could be done with little better format automatically.

From Account history export I get now this:

Code: Select all

; ticket, open time, type, lot, symbol, open, stop loss, take profit, close time, close, swap, profit, pips
#0 2001.01.02 23:02 deposit 0.0 empty 0.00 0.00 0.00 2001.01.02 23:02 0.00 0.00 100000.00 0 0.00 0.00 0.00 "initial deposit" 0
#2 2001.01.08 09:36 sell 1.2 EURUSD 0.9516 0.9464 0.0000 2001.01.09 06:48 0.9464 -13.80 610.20 52 0.00 1141.56 570.78 "" 0

Main problem is that first line have commas and all others doesn't.
Last five columns doesn't have name.
Also excel doesn't seem to like date and time together, so I would propose to separate it into 'open date' and 'open time'.
Delete ';', '#' and '""' when is not needed

If it look like this, it will be much easier to import it to excel:

Code: Select all

ticket, open date, open time, type, lot, symbol, open, stop loss, take profit, close date, close time, close, swap, profit, pips, any 1, any 2, any 3, any 4, any 5
0, 2001.01.02, 23:02, deposit, 0.0, empty, 0.00, 0.00, 0.00, 2001.01.02, 23:02, 0.00, 0.00, 100000.00, 0, 0.00, 0.00, 0.00, initial deposit, 0
2, 2001.01.08, 09:36, sell, 1.2, EURUSD, 0.9516, 0.9464, 0.0000, 2001.01.09, 06:48, 0.9464, -13.80, 610.20, 52, 0.00, 1141.56, 570.78, , 0


Strategy Optimizer has much better output, only thing I can think of is to put names of testing options into first line to be column names and not on every line as its now.


Thanks
Radek

[Terranin]

Hi,
I like many others use excel for analyzing of outputs from Forex tester and I would like to sugest some improvements to export functions from Forex tester. Now if I want to import files to excel I have to do quite a few steps manually, which could be done with little better format automatically.

From Account history export I get now this:

Code: Select all

; ticket, open time, type, lot, symbol, open, stop loss, take profit, close time, close, swap, profit, pips
#0 2001.01.02 23:02 deposit 0.0 empty 0.00 0.00 0.00 2001.01.02 23:02 0.00 0.00 100000.00 0 0.00 0.00 0.00 "initial deposit" 0
#2 2001.01.08 09:36 sell 1.2 EURUSD 0.9516 0.9464 0.0000 2001.01.09 06:48 0.9464 -13.80 610.20 52 0.00 1141.56 570.78 "" 0

Main problem is that first line have commas and all others doesn't.
Last five columns doesn't have name.
Also excel doesn't seem to like date and time together, so I would propose to separate it into 'open date' and 'open time'.
Delete ';', '#' and '""' when is not needed

If it look like this, it will be much easier to import it to excel:

Code: Select all

ticket, open date, open time, type, lot, symbol, open, stop loss, take profit, close date, close time, close, swap, profit, pips, any 1, any 2, any 3, any 4, any 5
0, 2001.01.02, 23:02, deposit, 0.0, empty, 0.00, 0.00, 0.00, 2001.01.02, 23:02, 0.00, 0.00, 100000.00, 0, 0.00, 0.00, 0.00, initial deposit, 0
2, 2001.01.08, 09:36, sell, 1.2, EURUSD, 0.9516, 0.9464, 0.0000, 2001.01.09, 06:48, 0.9464, -13.80, 610.20, 52, 0.00, 1141.56, 570.78, , 0


Strategy Optimizer has much better output, only thing I can think of is to put names of testing options into first line to be column names and not on every line as its now.


Thanks
Radek

In next update will be direct export to Excel. It is already done.

[Radek]

Thanks

[JJLL]

Yes, I agree. I'm currently trying to export to MS Excel 2007 and with the numerous different file extensions now in excel, it's a bit of a hassle.

All in all, great software, keep up the good work!