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 Segwin, 05-07-2018, 02:15 PM
          14 responses
          1,788 views
          0 likes
          Last Post aligator  
          Started by Jimmyk, 01-26-2018, 05:19 AM
          6 responses
          837 views
          0 likes
          Last Post emuns
          by emuns
           
          Started by jxs_xrj, 01-12-2020, 09:49 AM
          6 responses
          3,293 views
          1 like
          Last Post jgualdronc  
          Started by Touch-Ups, Today, 10:36 AM
          0 responses
          12 views
          0 likes
          Last Post Touch-Ups  
          Started by geddyisodin, 04-25-2024, 05:20 AM
          11 responses
          62 views
          0 likes
          Last Post halgo_boulder  
          Working...
          X