Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Import Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Import Error

    ´Hello everybody:

    I´m trying to import historical ^sp500 data from 1950, so i downloaded from yahoo, give the correct format and when tried to import i get this error:

    ^SP500: Format error in line 1: value too big or too small to Int32.: '20081111;917.15;917.15;884.90;898.95;4998340000'

    Any idea?

    I´ve attached a reduced copy of the file (original exceeds the max allowed here).
    Excuse my poor english, i´m spanish
    Attached Files

    #2
    Hello,


    It appears that your data has the incorrect format, please visit the link provided for information regarding the importation of data for the correct formats.


    MichaelNinjaTrader Customer Service

    Comment


      #3
      Daily Bars Format
      Each bar must be on its own line and fields must be separated by semicolon (. Only 1 day bars can be imported.


      The format is:
      yyyyMMdd;open price;high price;low price;close price;volume


      Sample data:
      20061023;1377.25;1377.25;1377.25;1377.25;86
      20061024;1377.25;1377.25;1377.25;1377.25;27
      20061025;1377.25;1377.25;1377.25;1377.25;24
      20061026;1377.50;1377.50;1377.25;1377.25;82



      I´m sorry but i don´t see the difference between the sample data above and my txt file.
      Can you explain me better?
      Attached Files

      Comment


        #4
        20081111;917.15;917.15;884.90;898.95;4998340000

        Volume values can't be greater than Int32 max value which is ~ 2.000.000.000. This is a known limitation which will be overcome with NT7.

        Sorry for the inconvenience

        Comment


          #5
          Ok thanks.waiting for the new version

          Comment

          Latest Posts

          Collapse

          Topics Statistics Last Post
          Started by geddyisodin, Yesterday, 05:20 AM
          7 responses
          45 views
          0 likes
          Last Post NinjaTrader_Gaby  
          Started by gbourque, Today, 06:39 AM
          2 responses
          5 views
          0 likes
          Last Post gbourque  
          Started by cre8able, Yesterday, 07:24 PM
          1 response
          13 views
          0 likes
          Last Post NinjaTrader_ChelseaB  
          Started by cocoescala, 10-12-2018, 11:02 PM
          6 responses
          939 views
          0 likes
          Last Post Jquiroz1975  
          Started by cmtjoancolmenero, Yesterday, 03:58 PM
          1 response
          17 views
          0 likes
          Last Post NinjaTrader_Gaby  
          Working...
          X