excel spread sheet

[400396]

hello all.

can i import data from excel to ninja trader i'm using the free ver?
if yes please direct me where i can read about it and learned how to do so.

thanks.

avi.

[NinjaTrader_Jason]

Hello Avi,

Unfortunately this is not supported. You can manually import historical data as per the instructions at the link below.

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

[400396]

thanks , i read it all and try to import tick data but i got this eror "there is been error on importing historical data, please check the log."

where can i find the log?

the name of the fileis : $EURUSD.LAST

the file look like this:
20140501 000047;1.386930;0
20140501 000049;1.386920;0
20140501 000050;1.386930;0
20140501 000107;1.386920;0
20140501 000234;1.386910;0
20140501 000339;1.386920;0
20140501 000352;1.386900;0
20140501 000353;1.386890;0
20140501 000439;1.386870;0
20140501 000440;1.386860;0
20140501 000454;1.386870;0

[Tasker-182]

thanks , i read it all and try to import tick data but i got this eror "there is been error on importing historical data, please check the log."

where can i find the log?

the name of the fileis : $EURUSD.LAST

the file look like this:
20140501 000047;1.386930;0
20140501 000049;1.386920;0
20140501 000050;1.386930;0
20140501 000107;1.386920;0
20140501 000234;1.386910;0
20140501 000339;1.386920;0
20140501 000352;1.386900;0
20140501 000353;1.386890;0
20140501 000439;1.386870;0
20140501 000440;1.386860;0
20140501 000454;1.386870;0

The log tab can be found in the ninja trader control center, it is the right most tab.

[400396]

thanks i find the log and it said:
"Unable to import file 'C:\Users\owner\Desktop\$EURUSD.LAST.txt'. Instrument is not supported by repository."

i follow the instruction and i don't understand why i get this erorr, the file namr should be ok , and file should be ok too please see the example i send ,can some one can help me with this? what i'm doing wrong?

thansk.

avi.

[Tasker-182]

thanks i find the log and it said:
"Unable to import file 'C:\Users\owner\Desktop\$EURUSD.LAST.txt'. Instrument is not supported by repository."

i follow the instruction and i don't understand why i get this erorr, the file namr should be ok , and file should be ok too please see the example i send ,can some one can help me with this? what i'm doing wrong?

thansk.

avi.

Importing Tips
Please review the following before importing:

• If you are importing historical data for a futures or forex instrument, the instrument MUST exist in the Instrument Manager. If it does not, you must add it first
• Any data imported where the instrument does not exist in the Instrument Manager will automatically be imported as a "Stock" instrument type
• Data points will be rounded to the instruments tick size as it is imported if the price is not evenly divisible by the instrument's tick size
• Imported data, regardless of time zone, will be converted to the local time zone.

Did you already have $EURUSD in your instrument manager list?

[400396]

yes i have this symbol , i try to download to other symbol too with out any luck.

[Tasker-182]

yes i have this symbol , i try to download to other symbol too with out any luck.

While it shows up as an available instrument in the master list, I think you need to add it to the list column on the left. Below the instrument are two arrow icons, one pointing to the list column and the other pointing away, you need to click the one that points to the left and that will add EURUSD to your list. Once that is done, close the instrument manager and try the import again.

[NinjaTrader_CalH]

Hello 400396,

You will need to rename the text file to just EURUSD to import it into NinjaTrader. You would not need the $ symbol in front of it.

[400396]

i try that still not working

[400396]

i just used EURUSD in the file name and it work perfectly , thanks guys.