Announcement

Collapse
No announcement yet.

Daylight savings issue -- QLink and QCharts periods out of sync

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

  • Daylight savings issue -- QLink and QCharts periods out of sync

    Goal: Get an intraday historic table of 55-minute periods that matches the pattern produced by QCharts at the same settings (i.e. eight periods per day with the first starting at 9:30).

    Attempt: By using "I55 [14:30-21:00]" as the Interval in "=RTD("esrtd",,"*H",StockSymbol,"BarTime",Interval ,,PeriodNumber)", this will generate the intended 8 periods per day.
    12/20/10 15:55
    12/20/10 15:00
    12/20/10 14:05
    12/20/10 13:10
    12/20/10 12:15
    12/20/10 11:20
    12/20/10 10:25
    12/20/10 9:30
    12/17/10 15:55

    Problem: Days prior to November 7th (i.e. daylight savings) will return seven periods per day, and the first now starts at 10:30 rather than 9:30 -- the time and values are out of sync with QCharts.
    11/5/10 16:00
    11/5/10 15:05
    11/5/10 14:10
    11/5/10 13:15
    11/5/10 12:20
    11/5/10 11:25
    11/5/10 10:30
    11/4/10 16:00

    Solution that consistently spans daylight savings dates: ???

  • #2
    This issue still exists in the new QLink 3.0 (build 56).

    Comment


    • #3
      This issue still exists in the new QLink 3.0 (build 62).

      Comment

      Working...
      X