• 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

Importing historical data - daylight saving time issue?

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

    Importing historical data - daylight saving time issue?

    There is data available here that I would like to import into the HDM but I'd like to make sure the daylight saving time is properly managed before I try - I assume it will take about 4 hours or so to do the import so I'd appreciate knowing that it's going to be OK before spending the time on it.

    The data is in time zone
    GMT (no Daylight Saving Time)
    In the HDM I can choose GMT, and there's no mention of any geographical time zone for it, so I assume there's no Daylight Saving associated with it. Is that correct?

    If I use GMT, will it correctly show the data in my charts in the London time zone when Daylight Saving is in force here? (That's my computer setting).

    Thanks

    #2
    Hi adamus,

    Would it be possible for you to provide me with a bit of the data which contains dates which would occur during daylight savings time?
    KyleNinjaTrader Customer Service

    Comment


      #3
      Hi Kyle,

      I guess any of the forex files from the website will do: forextester.com

      Comment


        #4
        adamus,


        Unfortunatley, I'm not able to open the text file when downloading on my end. If you're able to do this on your end, please provide me with a bit of the text file that includes data from times during daylight savings.
        KyleNinjaTrader Customer Service

        Comment


          #5
          Hi Kyle, you should get your browser software looked at. They are standard zip files containing ascii text files.

          Anyway, is this the kind of thing you want?

          AUDJPY,20100927,032900,80.63,80.63,80.62,80.62,4
          AUDJPY,20100927,033000,80.61,80.61,80.61,80.61,4
          AUDJPY,20100927,033100,80.60,80.61,80.60,80.60,4
          AUDJPY,20100927,033200,80.61,80.62,80.61,80.62,4
          AUDJPY,20100927,033300,80.63,80.63,80.63,80.63,4
          AUDJPY,20100927,033400,80.63,80.63,80.62,80.62,4
          AUDJPY,20100927,033500,80.63,80.64,80.63,80.64,4
          AUDJPY,20100927,033600,80.64,80.65,80.64,80.65,4
          AUDJPY,20100927,033700,80.66,80.66,80.64,80.65,4
          AUDJPY,20100927,033800,80.64,80.65,80.64,80.65,4
          AUDJPY,20100927,033900,80.65,80.65,80.65,80.65,4
          AUDJPY,20100927,034000,80.64,80.64,80.63,80.64,4
          AUDJPY,20100927,034100,80.65,80.65,80.64,80.64,4
          AUDJPY,20100927,034200,80.64,80.64,80.64,80.64,4
          AUDJPY,20100927,034300,80.65,80.66,80.65,80.66,4
          AUDJPY,20100927,034400,80.65,80.65,80.65,80.65,4
          AUDJPY,20100927,034500,80.65,80.66,80.65,80.65,4
          AUDJPY,20100927,034600,80.65,80.65,80.65,80.65,4
          AUDJPY,20100927,034700,80.64,80.64,80.64,80.64,4
          AUDJPY,20100927,034800,80.64,80.65,80.64,80.65,4
          AUDJPY,20100927,034900,80.65,80.65,80.65,80.65,4
          AUDJPY,20100927,035000,80.64,80.65,80.64,80.65,4
          AUDJPY,20100927,035100,80.66,80.66,80.64,80.64,4
          AUDJPY,20100927,035200,80.64,80.64,80.63,80.63,4
          AUDJPY,20100927,035300,80.63,80.63,80.63,80.63,4
          AUDJPY,20100927,035400,80.63,80.63,80.63,80.63,4
          AUDJPY,20100927,035500,80.63,80.63,80.63,80.63,4

          Comment


            #6
            Hi adamus,

            Thanks for providing the requested data. (I was unable to load the text file on my end as it was huge)

            Which of the GMT timezone options are you selecting when importing?
            KyleNinjaTrader Customer Service

            Comment


              #7
              Kyle,

              you need a text editor that doesn't try to buffer the whole thing. I use cygwin and less because I'm actually a linux user more than a windows user.

              What do you mean about time zone options? There's only one time zone dropdown that I can see and that's what my whole question is about - will it all be good re daylight saving if I choose GMT - co-ordinated universal time?

              Comment


                #8
                adamus,

                That you're using the coordinated time is what I needed to know. On my end, this is being displayed correctly durring daylight savings time dates.
                KyleNinjaTrader Customer Service

                Comment


                  #9
                  OK cool. What time zone is your computer on though?

                  Comment


                    #10
                    Hi adamus,

                    I tested in US Mountain time.

                    That said, you could replicate my test using your timezone by importing that data snippet on your end.
                    KyleNinjaTrader Customer Service

                    Comment


                      #11
                      OK thanks. Took me a while to find out if MST has Daylight Saving or not but I found it in the end.

                      Looks like I'm good to go. Thanks v much.

                      Comment


                        #12
                        Hello,

                        probably my issue is quite similar, therefore I post it in this thread:

                        I have data in ASCII at EST time but without daylight savings (i.e. UTC-5). The import wizard -if I am right- does provide only the GMT/UTC timezone without daylight savings. The other regional time zones - especially EST- seem to have daylight savings. Therefore I do not know how to import these data correctly.

                        Could you please help with that questions?

                        Many thanks,
                        Joerg
                        Last edited by Joerg; 01-26-2019, 04:49 PM.

                        Comment


                          #13
                          If you import the data, do you notice that the data is off by an hour between March and November? Or does it appear correctly? Could you attach a sample data file for review?
                          Patrick G.NinjaTrader Customer Service

                          Comment

                          Latest Posts

                          Collapse

                          Topics Statistics Last Post
                          Started by TazoTodua, Today, 12:29 PM
                          0 responses
                          5 views
                          0 likes
                          Last Post TazoTodua  
                          Started by TazoTodua, Today, 12:00 PM
                          0 responses
                          3 views
                          0 likes
                          Last Post TazoTodua  
                          Started by martyn73, Today, 08:56 AM
                          0 responses
                          6 views
                          0 likes
                          Last Post martyn73  
                          Started by TazoTodua, Today, 06:16 AM
                          0 responses
                          7 views
                          0 likes
                          Last Post TazoTodua  
                          Started by bubblegum, Today, 01:02 AM
                          0 responses
                          13 views
                          0 likes
                          Last Post bubblegum  
                          Working...
                          X