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: ???
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: ???
Comment