how to import this file please

[benoit29]

hi

i am french. can you explain me how i can import this file into ninjatrader.

1/ instrument manager setting
2/ convert file into ninjatrader format
3/ import data into ninjatrader

i read a lot of post about in your forum and on the ninjatrader helpguide but anything work easily.

if someone have a video or can help me i love him. THANKS A LOT

( i dont have excel i use openoffice or i can download a freeware if you explain how to use it)

[NinjaTrader_Matthew]

Hello,

It would be very difficult to convert this data to work in NinjaTrader without custom programming as the format is MMDDYYYY, but we required it in YYYYMMDD.

Can you please clarify where you obtained this data? Are there any options for reformatting the date?

[benoit29]

hi

thanks for your answers matthew

i found this file here http://pitrading.com/free_market_data.htm

i know i can use this http://pitrading.com/ascii2nt

or this http://csved.sjfrancke.nl/

i know i have to name the file like this "##-##, which represents a continuous contract."

and perhaps with ".text" but i am really lost . Can you help me please ???

[NinjaTrader_Matthew]

Hello,

##-## continuous contact would only refer to Futures contracts.

For a Forex symbol, you would want to name the file $USDJPY.Last.txt

The format the data should be in should be yyyyMMdd;open price;high price;low price;close price;volume

[benoit29]

ok thank you matthew

I have to go to instrument manager and to make "new" and to add: USDJPY.Last.txt?


The format the data can be change with http://pitrading.com/ascii2nt ?

or with http://csved.sjfrancke.nl/?

or with an another method?

thank for your job

[NinjaTrader_Matthew]

USDJPY already exists in the database. You should not need to add this as an instrument. You will just need to import that data for the instrument from the txt file.

Yes, the ascii2nt should convert it into NinjaTrader format.

Once it is set, you will want to import the file named USDJPY.Last.txt

Please see our Help Guide on Understand Import File and Data options for more information:

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

[benoit29]

hi matthew

i use ascii2nt(drag and drop the download file ) and name the file USDJPY.Last.txt
In"historical data manager" i change anything and start import my file. But it don't work...

the log say : ate;Category;Message;
27/04/2012 20:19:11;Default;$USDJPY: Date/Time format error in line 1: Input string was not in a correct format.: '19710104 357.73000;357.730;357.730;0;0;0';

Can you help me please ?

[NinjaTrader_Matthew]

Hello,

The date format needs to have a semi colon between the Date and the Open price

19710104;357.73000;

However I also noticed that your file is missing a closing value, where it is using a value of 0 which cannot be used. There is also an additional "0" at the end of the line.

[benoit29]

hi

pitrading give me the answer:

"The ASCII2NT utility is used for the 1 minute historical data, not the free end-of-day data.

For the free, end-of-day data, please use the EOD utility provided on our server:

http://pitrading.com/eod2nt "


But when I open a chart I can't have candlestick before 1998. only point on

the chart. do you know if I make a mistake during the import?

how can i verify start date/bars back?

thank you

[NinjaTrader_Matthew]

Hello,

You should be able to verify the start point by going to Tools--> Historical Data Manager--> Edit tab

Do the values listed here for the USDJPY correspond with the values in your text file? Can you get these same values in a chart using a custom range?