[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Time Stamp of compressed Intraday bars



PureBytes Links

Trading Reference Links

I'm not sure my problem is exactly what you describe-but its close- and I don't see how your solution would solve mine.  It is related to the last bar of the day on RT intraday db's.  If mkt closes at 4pm and the last trades of regular hours take sometime to be reported (ie NYSE stocks can be reported up to several minutes later I think) how do you capture those trades on the last bar.  For a 1 minute db- the last bar starts at 3:59...ends at 4:00.  If you choose to end it at 4:01 you have an extra bar in the 1min and every compressed bar you display.  If you start the first bar at 9:31 you don't have the daily open price.  The only solution I see to my problem is for AB to have some function which allows the 'last bar of the day' to be extended beyond normal bars.  Am I missing some other approach?
Dan

--- In amibroker@xxxxxxxxxxxxxxx, Keith McCombs <kmccombs@xxx> wrote:
>
> 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
> >
> >
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    amibroker-digest@xxxxxxxxxxxxxxx 
    amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/