• 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

Time shift in exported data

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

    Time shift in exported data

    Hello,

    I read a lot of threads about exporting data and different time and timeshift, but no-one answered to my question.

    I am in CET timezone (GMT+1 - Czech Republic) and I downloaded historical data from Zen-fire datafeed (E-mini S&P 500 (ES) market).

    Here is "main trading hours" (compare by volume):

    2009-04-02 14:30:00 - 21:15
    2009-04-04 = First Sunday in April
    2009-04-06 13:30:00 - 20:15
    ...
    2009-10-23 13:30:00 - 20:15
    2009-10-25 = Last Sunday in October
    2009-10-26 14:30:00 - 21:15
    ...
    2010-04-01 14:30:00 - 21:15
    2010-04-04 = First Sunday in April
    2010-04-05 13:30:00 - 20:15
    ...
    2010-10-29 13:30:00 - 20:15
    2010-10-31 = Last Sunday in October
    2010-11-01 14:30:00 - 21:15
    ...
    2011-04-01 14:30:00 - 21:15
    2011-04-03 = First Sunday in April
    2011-04-04 13:30:00 - 20:15
    etc...

    I suppose that time shift is because Daylight Saving Time, but WHY is changes in first Sunday in April and last Sunday in October?

    In USA, DST starts on the second Sunday of March, and it ends on the first Sunday of November.
    IN Central Europe DST starting on the last Sunday in March and ending on the last Sunday in October.

    Interesting information is, that from 1986 to 2006 DST was from the first Sunday in April to the last Sunday in October (this is the same as i my case):
    http://www.infoplease.com/spot/dayli...#ixzz1eguZTT8M

    My question is why is this time shift? Can I remove it somehow? (for example change timezone in computer and download data again, etc...). I do not mind the data will be in UTC or different timezone.

    Thank you very much and sorry for my English.

    pinokio88

    #2
    Welcome to our forums pinokio88 : when you export the data with NT it's exported in UTC per default (that's why the default import zone set is UTC as well here).

    As you download the data NT would store it locally and stamp / sort it according to your local PC set timezone - we have seen a few issues with incorrect DST offsets which to a large degree be caused by missing updates for your OS / .NET - have you checked via Windows Updates if there are any outstanding patches to be applied to your system?

    Which OS would you be using here?

    Once patches are applied please download a fresh set of data and recheck it.
    BertrandNinjaTrader Customer Service

    Comment


      #3
      This is it ;-)

      I updated my .NET and now it is OK (by the way my OS is WIN XP).

      Great, thank you very much

      Comment


        #4
        Thanks for reporting back, glad to hear it.
        BertrandNinjaTrader Customer Service

        Comment

        Latest Posts

        Collapse

        Topics Statistics Last Post
        Started by timcjpfx, Today, 03:52 AM
        0 responses
        1 view
        0 likes
        Last Post timcjpfx  
        Started by tonynt, Today, 01:42 AM
        0 responses
        7 views
        0 likes
        Last Post tonynt
        by tonynt
         
        Started by NT-Roland, Yesterday, 04:36 PM
        0 responses
        3 views
        0 likes
        Last Post NT-Roland  
        Started by Newtrader101, Yesterday, 03:40 PM
        2 responses
        13 views
        0 likes
        Last Post Newtrader101  
        Started by Branpo, Yesterday, 02:58 PM
        2 responses
        15 views
        0 likes
        Last Post Branpo
        by Branpo
         
        Working...
        X