Historical data help

[Radical]

I just came into possession of roughly 4 months of tick data as one file in CSV format. I would like to import this to Ninja, but I've come across the following problem:

As of now, the data looks like this in excel, and I have no idea how to get it into the correct format:

05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 1
05/15/09 09:45:01 AM 16600 16600 16600 16600 2
05/15/09 09:45:01 AM 16600 16600 16600 16600 1

Does anyone have any ideas on how I'd be able to change the format to the correct one?

[NinjaTrader_Bertrand]

Radical, you would need to use Excel's data manipulation options and then save the result to a semicolon delimited file.

[Radical]

Do you know by any chance how I would go about doing that? I don't have much experience with Excel.

[NinjaTrader_Bertrand]

Unfortunately I can't give you a step by step walkthrough, but for a start I suggest to check into this blog and the solutions / ideas offered there - http://blogs.msdn.com/excel/archive/...-in-excel.aspx

[Radical]

Thanks, I'll give that a look through.