e-Invester Posted February 16, 2012 Report 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
e-Invester Posted February 17, 2012 Author Report Posted February 17, 2012 Someone please help, would love to start using NT7's. Quote
s90phd Posted February 17, 2012 Report 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
e-Invester Posted February 17, 2012 Author Report 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
e-Invester Posted February 17, 2012 Author Report 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
s90phd Posted February 18, 2012 Report 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
e-Invester Posted February 24, 2012 Author Report 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
themask Posted March 15, 2012 Report Posted March 15, 2012 search'n'replace in notepad or Excel or something similar. remove '/' , remove ':' and replace ',' with ' '. Quote
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.