date formating

[Baruch]

You need to chose the MDY format in the Import stage! It works!!!!

[Lucinek]

You need to chose the MDY format in the Import stage! It works!!!!

Unfortunely not. Trust me. If I change "Local settings" in Windows, it works. When I use my native setting, it doesn't. Excel doesn'r recognize, that "30/6/2009 1:16 AM" is a date.
What is Your default settings in OS Windows?

[Baruch]

My local settings are stranger than yours. This is not a problem. I see that the date is formated correctly DD/MM/YY. The problem I see is the time part AM/PM. I don't get it when I export. Can you send me the text file.

[Lucinek]

Small sample. Just copy and paste it into txt or csv file.

Trade-#;Instrument;Account;Strategy;Market pos.;Quantity;Entry price;Exit price;Entry time;Exit time;Entry name;Exit name;Profit;Cum. profit;Commission;MAE;MFE;ETD;Bars;
1;FDAX 06-09;Back101;PORev;Long;1;4020.0;4027.0;3/20/2009 9:00:01 AM;3/20/2009 9:08:18 AM;RREntry;RRStop;7.00;7.00;0.00;2.50;15.00;8.00;10;
2;FDAX 06-09;Back101;PORev;Short;1;4027.0;4030.5;3/20/2009 9:08:49 AM;3/20/2009 9:10:13 AM;RREntry;RRStop;-3.50;3.50;0.00;3.50;4.00;7.50;5;
3;FDAX 06-09;Back101;PORev;Long;1;4037.5;4030.5;4/1/2009 10:59:40 AM;4/1/2009 11:00:04 AM;RREntry;RRStop;-7.00;-601.00;0.00;7.00;0.00;0.00;2;
4;FDAX 06-09;Back101;PORev;Short;1;4030.5;4034.0;4/1/2009 11:00:58 AM;4/1/2009 11:06:09 AM;RREntry;RRStop;-3.50;-604.50;0.00;3.50;4.50;8.00;5;

[NinjaTrader_Bertrand]

Lucinek, when I export my trades to Excel and then right click in the 'time' column I can format the cells to show the time as expected, you can also change the location format in these formatting options then.

[Baruch]

This data is not from strategy analyzer it has semi colons not comas.

[Lucinek]

This data is not from strategy analyzer it has semi colons not comas.

I'm sorry, wrong file.

Trade-#,Instrument,Account,Strategy,Market pos.,Quantity,Entry price,Exit price,Entry time,Exit time,Entry name,Exit name,Profit,Cum. profit,Commission,MAE,MFE,ETD,Bars,
1,FDAX 09-09,Back101,SampleMACrossOver,Short,1,4852.0,4788.0,6/22/2009 8:43:52 AM,6/22/2009 9:48:17 AM,Sell short,Close position,1600.00,1600.00,0.00,0.00,1850.00,250.00,84,
2,FDAX 09-09,Back101,SampleMACrossOver,Long,1,4788.0,4788.0,6/22/2009 9:48:17 AM,6/22/2009 10:25:26 AM,Buy,Close position,0.00,1600.00,0.00,100.00,400.00,400.00,40,
3,FDAX 09-09,Back101,SampleMACrossOver,Short,1,4788.0,4778.0,6/22/2009 10:25:26 AM,6/22/2009 10:59:59 AM,Sell short,Close position,250.00,1850.00,0.00,0.00,450.00,200.00,31,
4,FDAX 09-09,Back101,SampleMACrossOver,Long,1,4886.0,4880.0,7/1/2009 10:46:53 AM,7/1/2009 11:45:31 AM,Buy,Close position,-150.00,3950.00,0.00,200.00,50.00,200.00,13,
5,FDAX 09-09,Back101,SampleMACrossOver,Short,1,4880.0,4888.0,7/1/2009 11:45:31 AM,7/1/2009 12:22:53 PM,Sell short,Close position,-200.00,3750.00,0.00,200.00,100.00,300.00,12,

[Baruch]

You are wright. Excel can't convert when the field consist of date&time. If the field is only date in format mm/dd/yy and you declare it as date mdy in import, then it converts.
Now my question is why do you have a US format?
Do you see in NT all dates in US format? I don't. I see every thing in European format and the export is also European. The same for time I see it in 24H format. If thats the problem then just change in NT to European format.

[Lucinek]

Yes, I have every date in NT in US format. I don't know why and I don't know how to change it. But I'd like to change it ... any idea how to change it to European format?

[NinjaTrader_JoshP]

Guys,

You can do whatever formatting you want in Excel itself. Just copy the column with the time and then on the original you can right click -> Format Cell and format it to dates. Then on the duplicate you can format the time. After that you have a date column and a time column formatted to whatever locale you want.

[Lucinek]

Josh: OK, but tell me - why I have all date&time formats in US format and Baruch in European format? Where to change it in NT to EU format too? I prefer EU format, US format seems strange for me ...

[Lucinek]

Josh: Btw, it doesn't work in my European version of Excel. It is able to work with this format just like text, not date&time. Trust me. Only way in Excel is to use string functions to divide this string into date column and time column and then convert it, but its too complicated - i'm looking for some easier way how to do it.

Now I know, that when I don't change my Windows Local Settings to US formats, I'm NOT able to work with US format of date&time in Excel at all.

[NinjaTrader_Bertrand]

Lucinek, you both might be running different .NET framework versions producing different results, please try uninstalling and reinstalling .NET 3.5 fresh and then recheck the issue.

[NinjaTrader_JoshP]

Lucinek,

I am looking at my copy of Excel 2007 and I can format the cell the way I described. Unfortunately I cannot provide any further support on Excel. I suggest you try googling some resources to see if that helps.

[Lucinek]

Lucinek, you both might be running different .NET framework versions producing different results, please try uninstalling and reinstalling .NET 3.5 fresh and then recheck the issue.

OK. I completely reinstal my .NET 3.5 SP1.
Date format is still US - no effect.

Is available simple answer, WHAT AFFECTS DATE AND TIME FORMAT IN NT?
How is it possible, that anybody (e.g. Baruch) has European format and anybody (e.g. me) has US format?
Thanks a lot.