I have a big problem with formating date and time in list of trades.
When I save list of trades from Strategy analyzer or from live account, I get this format of CSV file:
233,FDAX 09-09,Back101,SampleMACrossOver,Long,1,4814.0,4824.0, 6/30/2009 9:33:05 PM,6/30/2009 9:59:57 PM,Buy,Exit on close,250.00,3450.00,0.00,0.00,250.00,0.00,11,
234,FDAX 09-09,Back101,SampleMACrossOver,Short,1,4812.0,4824.0 ,7/1/2009 8:09:04 AM,7/1/2009 8:40:08 AM,Sell short,Close position,-300.00,3150.00,0.00,350.00,100.00,400.00,15,
235,FDAX
There are two problems:
1. My excel doesn't understand format "6/30/2009 9:33:05 PM", it needs format "30/6/2009 9:33:05 PM". So I need to get file with dd/mm/yyyy hh:mm:ss format and i prefer 13:30 rather then 1:30 PM.
Currently this text is just "text" and it is impossible to convert it to date.
Acording this problem, string "7/1/2009 8:09:04 AM" is considered as date, but not as July 1st, but as January 7th. It is reason, why I can't convert this "bad" format to some valuable one.
2. My excel requires ';' as separator between values instead of ',' , so I need to get this format:
234;FDAX 09-09;Back101;SampleMACrossOver;Short;1;4812.0;4824.0 ;7/1/2009 8:09:04 AM;7/1/2009 8:40:08 AM;Sell short;Close position;-300.00;3150.00;0.00;350.00;100.00;400.00;15;
How to control output format on this list? Thanks for your advice ...
Comment