NinjaTrader Support Forum  
X

Attention!

This website will be down for maintenance from Friday May 24th at 6PM MDT until Sunday May 26th at 12PM MDT. We apologize for the inconvenience. If you need assistance during this time, please email sales@ninjatrader.com


Go Back   NinjaTrader Support Forum > Application Technical Support > Miscellaneous Support

Miscellaneous Support Miscellaneous support issues.

Reply
 
Thread Tools Display Modes
Old 05-11-2008, 09:27 AM   #1
iplaygames
Junior Member
 
Join Date: Aug 2007
Posts: 11
Thanks: 0
Thanked 0 times in 0 posts
Default Historical data import question

Hello! I've been trying to import some GBPJPY historical data. however everytime I tried, I got a message saying that "the instrument is not supported by the repository"! could anybody please shed some light on this?
iplaygames is offline  
Reply With Quote
Old 05-11-2008, 11:58 AM   #2
whitmark
Certified NinjaScript Consultant
 
Join Date: Nov 2005
Location: Virginia, USA
Posts: 441
Thanks: 0
Thanked 12 times in 7 posts
Send a message via Skype™ to whitmark
Default

Try naming the import file $GBPJPY.txt.
whitmark is offline  
Reply With Quote
Old 05-11-2008, 12:05 PM   #3
NinjaTrader_Eamon
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by whitmark View Post
Try naming the import file $GBPJPY.txt.
Thanks for lending a hand Whitmark!
 
Reply With Quote
Old 05-11-2008, 07:14 PM   #4
iplaygames
Junior Member
 
Join Date: Aug 2007
Posts: 11
Thanks: 0
Thanked 0 times in 0 posts
Default

Thank you, whitmark! that indeed is the problem. now I got a different error message telling me that there was sth wrong with the format of the data. but I'm sure I can solve that without crying out for further help
iplaygames is offline  
Reply With Quote
Old 05-13-2008, 12:28 AM   #5
iplaygames
Junior Member
 
Join Date: Aug 2007
Posts: 11
Thanks: 0
Thanked 0 times in 0 posts
Default

I've done my best converting the historical data to the appropriate form in accordance with the Import section of the online help guide. therefore I'm quite mystified by the persistent error message - Illegal timestamp in line 1. could somebody please tell me what's wrong the following historcal data?

20051003 050000 ; 199.86 ; 199.86 ; 199.82 ; 199.86 ; 9
20051003 050500 ; 199.93 ; 199.93 ; 199.93 ; 199.93 ; 1
20051003 051000 ; 199.94 ; 199.95 ; 199.93 ; 199.94 ; 5
20051003 051500 ; 199.95 ; 199.95 ; 199.8 ; 199.82 ; 18
20051003 052000 ; 199.82 ; 199.92 ; 199.82 ; 199.86 ; 17
20051003 052500 ; 199.82 ; 199.88 ; 199.82 ; 199.86 ; 9
20051003 053000 ; 199.84 ; 199.95 ; 199.84 ; 199.91 ; 16
20051003 053500 ; 199.92 ; 199.92 ; 199.78 ; 199.82 ; 19
20051003 054000 ; 199.79 ; 199.89 ; 199.79 ; 199.83 ; 17
20051003 054500 ; 199.82 ; 199.86 ; 199.8 ; 199.86 ; 9
20051003 055000 ; 199.89 ; 199.89 ; 199.85 ; 199.87 ; 7

best regards
iplaygames is offline  
Reply With Quote
Old 05-13-2008, 12:58 AM   #6
NinjaTrader_Josh
NinjaTrader Product Manager
 
NinjaTrader_Josh's Avatar
 
Join Date: May 2007
Location: Denver, CO
Posts: 17,458
Thanks: 1
Thanked 107 times in 70 posts
Default

The whitespaces may be a problem. Change

20051003 050000 ; 199.86 ; 199.86 ; 199.82 ; 199.86 ; 9

To this

20051003 050000;199.86;199.86;199.82;199.86;9
NinjaTrader_Josh is offline  
Reply With Quote
Old 05-13-2008, 01:18 AM   #7
NinjaTrader_Dierk
Administrator
 
NinjaTrader_Dierk's Avatar
 
Join Date: Mar 2005
Location: Bamberg, Germany
Posts: 9,994
Thanks: 0
Thanked 6 times in 6 posts
Default

You likely have some garbage data in the first line of your import file. Some header line?
NinjaTrader_Dierk is offline  
Reply With Quote
Old 05-13-2008, 08:01 AM   #8
iplaygames
Junior Member
 
Join Date: Aug 2007
Posts: 11
Thanks: 0
Thanked 0 times in 0 posts
Default

thank you Josh! thank you Ninjatrader Dierk! after more than a dozen times of converting, fixing errors and re-converting, I was finally able to import the historical data. this is a lot more hassles than I had been prepared to deal with. a task that I thought should only take a couple of minutes turned out to be colossal. Ninjatrader is so unforgiving that it only accepts one form of past data, I had great 'fun' figuring out how to use excel and word to shape the data into acceptable form by Ninjatrader. and it stops at every single error, no matter how minuscule it is. all in all, this import feature is a huge disappointment for such a sophisticated software. I hope it won't always be like this.

thank you guys again for helping me.
best regards
iplaygames is offline  
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart not displaying tick data after historical tick data import Big D Miscellaneous Support 17 10-18-2010 03:14 AM
Use standard CSV format for historical data import Iggy22 Suggestions And Feedback 8 10-17-2010 10:43 PM
Issue Import Historical Data cls71 Miscellaneous Support 2 04-23-2008 12:25 PM
import/export historical data ATI user Miscellaneous Support 11 04-17-2008 10:39 AM
Historical Import EOD mydet Miscellaneous Support 3 04-01-2008 05:33 AM


All times are GMT -6. The time now is 06:51 PM.