help with importing

[freddy250]

hi,

i am trying to import some data and can only manage to save the file to read like this:
2010/12/01;093000;54;54;53.92;53.98;17550

i realise i need a space between the date and opening time but how can i change it via excel, at the moment i am saving as a csv file, is this correct

Thanks for the help

Freddy

[NinjaTrader_RyanM1]

Hi Freddy,

To import data, it should be txt files and in the format indicated in the following link:

http://www.ninjatrader.com/support/helpGuides/nt7/importing.htm

[freddy250]

i understand the format it needs to be in, but when i format from excel i get an extra ( between my date and time, how can i get rid of this to suit the ninja format?

Thanks

Freddy

[NinjaTrader_RyanM1]

Sorry, we will not be able to provide a technique or custom coding solution that can be used to automatically convert data into acceptable NT format. For Microsoft Excel support, you'll have to direct your questions to a board dedicated for this.

If you would like assistance creating a script that will work with the data and convert it into something accepted by NinjaTrader, consider hiring a NinjaScript consultant for this:

http://www.ninjatrader.com/partners#NinjaScript-Consultants