Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

import historical data stock error

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

    import historical data stock error

    I downloaded historical data for AAPL and saved as .txt file
    In Tools > Historical Data Manager >
    I tried both NT formats / last / -5 timezone / generate day bars (and I tried unchecked)

    error log - AAPL: Time stamp line 2 is smaller/equal than timestamp of previous line

    how can I upload historical data?

    thanks

    #2
    Hello cowboyss,

    Thank you for your post.

    Could you please copy and paste the second line of the file you'd tried importing?
    KyleNinjaTrader Customer Service

    Comment


      #3
      Originally posted by NinjaTrader_Kyle View Post
      Hello cowboyss,

      Thank you for your post.

      Could you please copy and paste the second line of the file you'd tried importing?
      2012-12-07,59.71,59.84,58.98,59.61,10256500,59.61

      taken from Yahoo finance historical data

      thanks

      Comment


        #4
        Hi,

        Thanks for getting back to me.

        Which YYYYMMDD is shown in the previous line in the data set?
        KyleNinjaTrader Customer Service

        Comment


          #5
          Originally posted by NinjaTrader_Kyle View Post
          Hi,

          Thanks for getting back to me.

          Which YYYYMMDD is shown in the previous line in the data set?
          Date,Open,High,Low,Close,Volume,Adj Close
          2012-12-07,59.71,59.84,58.98,59.61,10256500,59.61
          2012-12-06,58.72,59.28,58.55,59.17,8538500,59.17

          Comment


            #6
            Hello,

            The data you're using does not appear to be in the correct format. Please see the following for the correct format

            Minute Bars Format
            Each bar must be on its own line and fields must be separated by semicolon (. Only 1 minute bars can be imported.

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

            Sample data:
            20061023 004400;1377.25;1377.25;1377.25;1377.25;86
            20061023 004500;1377.25;1377.25;1377.25;1377.25;27
            20061023 004600;1377.25;1377.25;1377.25;1377.25;24
            20061023 004700;1377.50;1377.50;1377.25;1377.25;82

            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
            Please review our Help Guide article on Understanding import file and data formats:

            MatthewNinjaTrader Product Management

            Comment


              #7
              Since Yahoo only allows import of daily or larger, where can I get 1 minute bars for the full history of companies?

              Comment


                #8
                Hello,

                There are a few 3rd party vendors who offer historical data you can import. We do not have any suggested recommendations, but I've heard good things from users regarding www.tickdata.com
                MatthewNinjaTrader Product Management

                Comment


                  #9
                  Matthew,

                  I want to purchase a year's worth of tick data from tickdata.com. Will I be able to build volume/tick charts with that data? Also, is there still a problem with the data format from tickdata.com and NT7?

                  Comment


                    #10
                    The tick data you purchase can be used to build volume/tick charts with NinjaTrader.

                    Tickdata.com actually has a NinjaTrader formatted output you can select when you export the data.
                    MatthewNinjaTrader Product Management

                    Comment


                      #11
                      Thanks for your response! Does it matter if I use TickWrite Download and TickWrite On-Demand or just have them ship it to me?

                      Comment


                        #12
                        I'm really not sure what the difference is between those products. I'd suggest contacting them as they have very excellent support.
                        MatthewNinjaTrader Product Management

                        Comment

                        Latest Posts

                        Collapse

                        Topics Statistics Last Post
                        Started by TraderG23, 12-08-2023, 07:56 AM
                        9 responses
                        382 views
                        1 like
                        Last Post Gavini
                        by Gavini
                         
                        Started by oviejo, Today, 12:28 AM
                        0 responses
                        1 view
                        0 likes
                        Last Post oviejo
                        by oviejo
                         
                        Started by pechtri, 06-22-2023, 02:31 AM
                        10 responses
                        125 views
                        0 likes
                        Last Post Leeroy_Jenkins  
                        Started by judysamnt7, 03-13-2023, 09:11 AM
                        4 responses
                        59 views
                        0 likes
                        Last Post DynamicTest  
                        Started by ScottWalsh, Yesterday, 06:52 PM
                        4 responses
                        36 views
                        0 likes
                        Last Post ScottWalsh  
                        Working...
                        X