Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Quandl CSV to TxT

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

    Quandl CSV to TxT

    Hello,
    I downloaded quandl data and transfered it to txt files ,and I cant get it to inport Error is
    Default ZW 12-15: Time stamp line 2 is smaller/equal than timestamp of previous line
    I also uploaded txt file ZW 12-15
    Thank you


    Sample data
    20150714;575;582.5;569.25;571;60667
    20150713;574.5;576.75;566.5;575.75;56395
    20150710;577;588.25;568.5;576;81263
    20150709;576.5;586.5;575.25;578;62449
    20150708;584.25;588.25;573;577.5;60131
    20150707;593;593.25;578.25;585.25;86637
    20150706;584.5;599.75;572.25;595.5;95887
    Attached Files

    #2
    Hello,

    Thank you for your post.


    Before it is possible to import this data in to NInjaTrader the lines within the file will need to be reordered in ascending order.

    For example, using the text you posted, the first line would need to be the 20150706 line followed by the 20150707 line and so on.

    More information about the requirements for importing data in NinjaTrader can be found here: http://ninjatrader.com/support/helpG.../importing.htm
    KyleNinjaTrader Customer Service

    Comment


      #3
      That almost worked but now I get ,
      7/17/2015 10:14:36 AM Default ZW 12-15: Format error in line 102: Input string was not in a correct format.: '19591124;198.7;199.94;198.7;199.5;3066.2'

      And line 102 is:
      19591124 198.7 199.94 198.7 199.5 3066.2
      Thank you

      Comment


        #4
        Hello,

        This line appears to start with a 1959/11/24 date which seems to be incorrect to me as ZW 12-15 would not have been trading at that time.
        KyleNinjaTrader Customer Service

        Comment


          #5
          Hello,
          So if I rename ZW file to lets say in our case to ZW 11 59 would that work, or do I need to go to Instrument manager and edit wheat>misc to correct rollover dates

          Comment


            #6
            Hello,

            I suspect that this would allow you to import the 1959 data from your data set. When importing data it is important to import data for the selected contract only. (For example, only 09-15 data should be imported with the ZS 09-15.last file.)
            KyleNinjaTrader Customer Service

            Comment


              #7
              I still have nothing, I renamed file to ZW 07-59.LAST.txt ...error repository....
              Is there a way for you to tell me go there do this,
              Thank you

              Comment


                #8
                Hello,

                Can you please provide the full error message?
                KyleNinjaTrader Customer Service

                Comment


                  #9
                  7/17/2015 2:39:32 PM Default Unable to import file 'D:\Trading\Data\ZW 07-59.LAST..txt'. Instrument is not supported by repository.

                  Comment


                    #10
                    Hello centurius,

                    Please shut NinjaTrader down then open the PC clock and change the system date back to 1959. After making this change please restart NinjaTrader and add ZW 07-59 to NinjaTrader's default instrument list by following the steps which are outlined here: https://www.ninjatrader.com/support/...ment_lists.htm

                    After adding the instrument please shut NinjaTrader down and reset the PC clock back to the current date. Finally, restart NinjaTrader once more and try the import again.
                    KyleNinjaTrader Customer Service

                    Comment

                    Latest Posts

                    Collapse

                    Topics Statistics Last Post
                    Started by Shansen, 08-30-2019, 10:18 PM
                    24 responses
                    939 views
                    0 likes
                    Last Post spwizard  
                    Started by Max238, Today, 01:28 AM
                    0 responses
                    6 views
                    0 likes
                    Last Post Max238
                    by Max238
                     
                    Started by rocketman7, Today, 01:00 AM
                    0 responses
                    4 views
                    0 likes
                    Last Post rocketman7  
                    Started by wzgy0920, 04-20-2024, 06:09 PM
                    2 responses
                    28 views
                    0 likes
                    Last Post wzgy0920  
                    Started by wzgy0920, 02-22-2024, 01:11 AM
                    5 responses
                    33 views
                    0 likes
                    Last Post wzgy0920  
                    Working...
                    X