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 ccrone2024, Today, 05:13 AM
          0 responses
          3 views
          0 likes
          Last Post ccrone2024  
          Started by ttodua, Today, 03:40 AM
          0 responses
          6 views
          0 likes
          Last Post ttodua
          by ttodua
           
          Started by ttodua, Today, 03:18 AM
          0 responses
          5 views
          0 likes
          Last Post ttodua
          by ttodua
           
          Started by TraderKnG, Today, 01:30 AM
          0 responses
          11 views
          0 likes
          Last Post TraderKnG  
          Started by morrnel, 05-12-2024, 06:07 PM
          8 responses
          157 views
          1 like
          Last Post nobchi
          by nobchi
           
          Working...
          X