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 WHICKED, 06-27-2023, 12:07 PM
          66 responses
          768 views
          1 like
          Last Post NinjaTrader_ChelseaB  
          Started by tkaboris, 06-11-2024, 08:06 AM
          11 responses
          32 views
          0 likes
          Last Post tkaboris  
          Started by Matt Skinner, Yesterday, 12:23 AM
          3 responses
          29 views
          0 likes
          Last Post Matt Skinner  
          Started by Dan_TUK, Today, 05:14 AM
          0 responses
          7 views
          0 likes
          Last Post Dan_TUK
          by Dan_TUK
           
          Started by wzgy0920, 04-20-2024, 06:09 PM
          7 responses
          59 views
          0 likes
          Last Post Joia_
          by Joia_
           
          Working...
          X