In case anyone cares, problem solved:

by merely changing the session start time to 9:31 (instead of 9:30) and leaving the session end time as 16:00, and selecting "time of LAST tick inside bar" and "Align minute bars to regular market hours" in Preferences>Intraday. This was necessitated by the fact that the original data is date-stamped with the time of the last tick inside a bar, rather than the first tick. So the first complete one minute bar of trading is time stamped 9:31.

Thank you.
-- Keith

Keith McCombs wrote:
I have a data base of 1min bars, for market hours 9:30 to 16:00, 390 bars/day. First bar is at end of first minute, 9:31, last at end of last minute, 16:00. With chart set for 1min intraday bars, everything is fine, bars are 9:31:00 ..... 16:00:00.

However, when I select a different time interval, just for example, 5min, I cannot get expected 78 bars total. I tried changing Preferences>Intraday Time stamp shown below.

5min bars, results from different Preference Intraday Time settings:
_Setting_     _times
_expected    9:35:00 9:40:00........15:55:00 16:00:00
Open         36.67   36.56           36.50    36.55
Close        36.56   36.58           36.56    36.66
// see raw data at end.
t of first  9:31:00 9:35:00........15:55:00 16:00:00
Open         36.67   36:60           36:53    36.65
Close        36:59   36:55           36.66    36.66
// 9:31:00? 79 bars total

t of last   9:34:00 9:39:00........15:59:00 16:00:00
Open and Close values are same as "t of first" above
// first bar is 4min long, last bar 1min. 79 bars

Start of I  9:30:00 9:35:00........15:55:00 16:00:00
Open and Close values are same as "t of first" above
// 79 bars

End of I    9:34:59 9:39:59........15:59:59 16:04:59
Open and Close values are same as "t of first" above
// 79 bars

First and Last 10 minutes of raw data for above, QQQQ, 6/12/2009:
Expected Prices are _UNDERLINED_.
Displayed Prices are *BOLD*.
"QQQQ-PI",06/12/2009,0931,*_36.67_*,36.72,36.66,36.69,655312,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0932,36.69,36.70,36.65,36.66,459001,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0933,36.65,36.66,36.55,36.56,744249,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0934,36.56,36.60,36.55,*36.59*,502442,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0935,*36.60*,36.60,36.56,_36.56_,1085270,"NASDAQ 100"

"QQQQ-PI",06/12/2009,0936,_36.56_,36.57,36.54,36.56,912070,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0937,36.56,36.57,36.52,36.52,280976,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0938,36.52,36.53,36.50,36.52,253630,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0939,36.52,36.57,36.51,*36.55*,593532,"NASDAQ 100"
"QQQQ-PI",06/12/2009,0940,36.56,36.60,36.55,_36.58_,185041,"NASDAQ 100"

=======================
"QQQQ-PI",06/12/2009,1551,_36.50_,36.57,36.50,36.56,250056,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1552,36.56,36.63,36.56,36.63,385357,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1553,36.62,36.63,36.56,36.57,995355,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1554,36.56,36.57,36.53,36.53,189733,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1555,*36.53*,36.56,36.53,_36.56_,483969,"NASDAQ 100"

"QQQQ-PI",06/12/2009,1556,_36.55_,36.59,36.54,36.59,575005,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1557,36.58,36.58,36.57,36.58,126583,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1558,36.58,36.60,36.57,36.59,488942,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1559,36.60,36.66,36.60,*36.66*,1142218,"NASDAQ 100"
"QQQQ-PI",06/12/2009,1600,*36.65*,36.67,36.64,*_36.66_*,1779487,"NASDAQ 100"

Thanks for any and all help.
-- Keith


Reply via email to