Import Historical Data (ASCII)

[JohnPS]

Hello,
I am having some trouble getting a txt file to import - it seems like everything is right but I get the message "import field separator could not be identified"
Here is a sample of the data which is weekly data:
20120103;100
20120110;101
20120117;102
20120124;103
20120131;104
20120207;105
20120214;106
20120221;107
20120228;108
20120306;109
20120313;110

And this is my file name
COT.Last.txt

I also tried this data with daily date progression
20120403;113
20120404;114
20120405;115
20120406;116
20120407;117
20120408;118
20120409;119
20120410;120
20120411;121
20120412;122
20120413;123
20120414;124
20120415;125

I don't see anything wrong here.
Thanks for the help

[NinjaTrader_Jason]

Hello JohnPS,

Unfortunately the format is not the same as reflected in the help guide under 'Understanding import file and data formats'.
http://www.ninjatrader.com/support/h.../importing.htm

You can only import data that is in the format you see listed.

[SmartTraderFx]

Hello

I have been with Ninja trader 7 for 1 year now i am finally understanding the power of the NT 7 Platform the other day i was looking for some Forex data and i found it on
http://www.histdata.com/download-free-forex-data/
and u can get from May 2000 To current i downloaded every year in the file and tried to upload it from the Historical data manager and tried every setting to import it but it keeps on failing, can some one help me or tell me what I'm doing wrong

thanks

Smarttraderfx

[NinjaTrader_Matthew]

Hello,

Thank you for your post and welcome to our fourms!

The files you import into NinjaTrader need to be in a specific format.

Please see our Help Guide on Understanding File and Data formats for more information:

http://www.ninjatrader.com/support/h.../importing.htm

[SmartTraderFx]

Hello

thanks for pointing the fingure at the webpage on what i need to do, after following the info i went and looked at the zip file i have downloaded and i have unziped it and found out it matches the data file or the formate that ninja trader needs but it still gives me an error here is the unziped file for 20000530

20000530 175900;1.497300;1.497300;1.497300;1.497300;0
20000530 182800;1.497500;1.497500;1.497500;1.497500;0
20000530 193400;1.497000;1.497000;1.497000;1.497000;0
20000530 220400;1.497000;1.497000;1.497000;1.497000;0
20000530 221200;1.497200;1.497300;1.497200;1.497300;0
20000530 222000;1.497200;1.497200;1.497100;1.497100;0
20000530 222600;1.497300;1.497400;1.497300;1.497400;0
20000530 223200;1.497600;1.497800;1.497600;1.497800;0
20000530 223300;1.498300;1.498700;1.498300;1.498700;0
20000530 223500;1.498800;1.498800;1.498700;1.498800;0
20000530 224100;1.498700;1.498700;1.498700;1.498700;0
20000531 005000;1.498700;1.498700;1.498700;1.498700;0
20000531 005800;1.498600;1.498600;1.498600;1.498600;0

if i'm making a mistake please guide me so i may check my mistake

thanks for the quick reply

smarttraderfx

[NinjaTrader_Joydeep]

Hello SmartTraderFx,
To assist you further may I know what error message you are getting while importing the data.

Also can you please upload a sample txt file so that I can test it at my end.

I look forward to assisting you further.

[SmartTraderFx]

Hello

Yes here is the jpg file so u can review my errors and i am loading the file for ! M 201201 and 02 so u may sample both on the GBP/USD

Thanks

Smarttraderfx

[SmartTraderFx]

Hello

her is the link so u can download free data from the same site as i did

http://www.histdata.com/download-free-forex-data/

Thanks

Smarttraderfx

[NinjaTrader_Joydeep]

Hello SmartTraderFx,
Thanks for the clarification.

You may have to further format the data as per our help guide before importing it to NinjaTrader.

• Please make sure the instrument name is supported by the respiratory.
• The data lags a new line between 2 price. Please make sure to add a new line.

Please refer to our help file to know more about it
http://www.ninjatrader.com/support/h.../importing.htm

[SmartTraderFx]

Hello

Thanks you for the information can u give me a one line typo so i may understand perfectly what u are saying

Thanks

Nikhil

[NinjaTrader_Joydeep]

Hello Nikhil,
NinjaTrader imports data from txt files. Thus you need to save the csv file as a a txt file.

• Open the csv file in Excel, and then save the file as a Txt file from File>Save As

Please make sure to save the file as, for example $EURUSD.Last.txt (txt being the file extension) if you are importing data for EURUSD pair.

[SmartTraderFx]

Hello Joy

Can you please upload a sample txt file so that I can test it with the CVS file like u shared i tried but i'm getting $GNPUSD Volume in line 1 Is invalidsince its is <=0. This line and subsequent invalid volume lines have been modified and replaced by value of 1.

Thanks

Smarttraderfx
Nikhil

[NinjaTrader_Joydeep]

Hello Nikhil,
I could not locate the symbol $GNPUSD.Are you trying to import data for $GBPUSD?

Can you please upload the file you are trying to import as there are several files in the site as listed by you.

[SmartTraderFx]

I meant $GBPUSD

Sorry

Thanks

Smarttraderfx
Nikhil

[SmartTraderFx]

Please go to the site i had shared and u can download the file from there since its bigger then 1 MB can than can u share the 1 month file by sharing the exect info from it and i can do it to the rest of it from your example

download the zip file and u share it with me on the txt file from the $GBPUSD and zip it and share it back

thanks

Smarttraderfx
Nikhil