e-Invester Posted February 16, 2012 Report Share Posted February 16, 2012 I got a .txt file with 30min data of our index futures in my country separated by a comma, but cant seem for a dam to get it opened in NT. Can anyone help please? I have even tried converting it to metastock format and then importing it, then it says its been imported successfully, but if I want to open a new chart to analyze or back test there is nothing. Help will be greatly appreciated.[-O<[-O<[-O<[-O<[-O< Quote Link to comment Share on other sites More sharing options...
gktk Posted February 16, 2012 Report Share Posted February 16, 2012 is your timeframe correct Quote Link to comment Share on other sites More sharing options...
e-Invester Posted February 17, 2012 Author Report Share Posted February 17, 2012 Someone please help, would love to start using NT7's. Quote Link to comment Share on other sites More sharing options...
s90phd Posted February 17, 2012 Report Share Posted February 17, 2012 Have you looked at the help file in NT7. Goto the Historical Data Manager heading and see if it is helpful. Make sure the data is arranged correctly (along with date format). I can also tell you also that you need to name your text file EXACTLY as the name of the instrument e.g. 6E ##-## or 6E 03-12 otherwise it will not import it. Hope this is helpful. Quote Link to comment Share on other sites More sharing options...
e-Invester Posted February 17, 2012 Author Report Share Posted February 17, 2012 Thanx for replying, yes I did go and read the help file, thing is a line of data looks like this: 2008/01/02,09:29:00,26785,26785,26620,26715 and there is about 3mil lines of data going way back and i just thought maybe someone knew how I can modify the text file so it will work. Quote Link to comment Share on other sites More sharing options...
e-Invester Posted February 17, 2012 Author Report Share Posted February 17, 2012 (edited) I have now corrected the data so it looks like this: eg its 30m data bars 20120213;135859;30560.00;30569.00;30532.00;30540.00;56 20120213;142927;30536.00;30552.00;30525.00;30547.00;76 20120213;145958;30546.00;30579.00;30515.00;30566.00;88 20120213;152941;30566.00;30566.00;30517.00;30536.00;89 and still get this error: 20120218 002542|3|4|ALSI: Format error in line 1: Input string was not in a correct format.: '20120213;135859;30560.00;30569.00;30532.00;30540.00;56' this thing kicking my a** can only think my .txt file is in wrong encoding its currently ANSI??? Edited February 17, 2012 by e-Invester Quote Link to comment Share on other sites More sharing options...
s90phd Posted February 18, 2012 Report Share Posted February 18, 2012 I think the format should be: yyyyMMdd HHmmss;open;high;low;close;volume. So your format is incorrect beciuse you need a space after the date and there is some extra space you have in the close prices. The data should look like this:- 20120213 135859;30560.00;30569.00;30532.00;30540.00;56 e-Invester 1 Quote Link to comment Share on other sites More sharing options...
e-Invester Posted February 24, 2012 Author Report Share Posted February 24, 2012 Only problem now is how do I get the current data being 16000+ lines long converted into ninja format?? is there an app for this because by hand its basically impossible! Quote Link to comment Share on other sites More sharing options...
themask Posted March 15, 2012 Report Share Posted March 15, 2012 search'n'replace in notepad or Excel or something similar. remove '/' , remove ':' and replace ',' with ' '. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.