• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Imported data with wrong timezone

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

    Imported data with wrong timezone

    Hi,

    Okay, I did a stupid thing.

    I've downloaded ES data from TickWrite, which is listed as "America/Chicago" timezone, for the years 2005 - 2008.

    When importing into NinjaTrader, I left the Time Zone setting on NT at UTC, instead of UTC-06:00 (Central Time).

    So right now, I have historical data from 2005 and half of 2008 plotting on incorrect times, while those from end-2008 to current (which are loaded live from my data provider) plotting at the correct time zone.

    I was thinking of just re-importing the data from TickWrite using the correct timezone, but won't that leave bits of the previously imported incorrect data hanging in the database, and printing out on the chart as well?

    Is there a way to purge the database of old data, so I can start importing from fresh again? If possible, I'd like to still keep the recent data (i.e. post 2009) as I'm not sure if my data provider still allows me to re-download live from that far back.

    By the way, my TickWrite data is by expiration data (H06, M06, U06, etc), and not a single continuous file.

    Thanks!

    Regards,
    Nick

    #2
    Hi Nick, you can edit / delete your data in the Historical Data Manager in NT (access from the Tools menu).

    Easier for such a 'mass' edit would be exiting NT and deleting the not needed datafiles from the Documents\NinjaTrader 7\db subfolders (there are folder for tick, minute and day based data).

    Once this is done you do the reimport in the correct zone.
    BertrandNinjaTrader Customer Service

    Comment


      #3
      Hi Bertrand,

      Thanks for the prompt response.

      Ok, I see the folders "cache', "data", "day", "minute", and "tick". So, for example, if I'd like to clear out ES 09-08 completely from the system, I'd go into each folder and delete the subfolder ("ES 09-08")? Or do I need to leave the sub-folder, and just delete the *.ntd files within?

      What about the "data" and "cache" folder? The "data" folders contains a bunch of dates, without any subfolder by instrument.

      -Nick

      Comment


        #4
        Correct Nick, for complete removal delete the subfolders for the instrument. If you reimport it would recreate the instrument subfolder structure as needed.

        Data would store Market Replay data, so nothing to be concerned about for this task.

        In the Cache folder delete the subfolders seen for the ES used session templates as well, this will give you then a complete fresh start.
        BertrandNinjaTrader Customer Service

        Comment


          #5
          Will do.

          Thanks for the very detailed help!

          Regards,
          Nick

          Comment

          Latest Posts

          Collapse

          Topics Statistics Last Post
          Started by Dennis W, Today, 11:02 AM
          1 response
          5 views
          0 likes
          Last Post NinjaTrader_RyanS  
          Started by Johnny Santiago, Today, 10:05 AM
          1 response
          12 views
          0 likes
          Last Post Johnny Santiago  
          Started by madhouse, Today, 09:44 AM
          1 response
          17 views
          0 likes
          Last Post NinjaTrader_Spencer  
          Started by Matt17, Today, 09:38 AM
          2 responses
          7 views
          0 likes
          Last Post Matt17
          by Matt17
           
          Started by mikrodoctor, Today, 08:04 AM
          1 response
          13 views
          0 likes
          Last Post NinjaTrader_Kate  
          Working...
          X