Guys, I did not think that I was walking so confusing! for the life of me I can not figure out how many bars exists between to given dates, as it follows:
x = DateNum(); y = x - 10000; //one year ago date Any thoughts? Thanks Cam --- In amibroker@yahoogroups.com, "Terry" <[EMAIL PROTECTED]> wrote: > > That part of the question I answered. It's these 3 lines: > > SetBarsRequired(100000,0); > x = DateNum(); > firstDate = x[0]; > > Graham's method may work too, but I think SetBarsRequired is still > required since quickAFL has a different bar zero. > > Steve's idea for the date might work. Did you try that? > > z = ValueWhen( x <= LastValue( y ), Close ); > -- > Terry > -----Original Message----- > From: amibroker@yahoogroups.com [mailto:[EMAIL PROTECTED] On > Behalf Of tipequity > Sent: Saturday, August 19, 2006 23:27 > To: amibroker@yahoogroups.com > Subject: [amibroker] Re: Newbie questins > > Graham > > Do you know how can I get the first date for which we have data (end > of the day)? > > Thanks > > Cam > > > > --- In amibroker@yahoogroups.com, Graham <kavemanperth@> wrote: > > > > this will get you the value on a chart > > > > x = SelectedValue(DateNum()); > > > > > > -- > > Cheers > > Graham > > AB-Write >< Professional AFL Writing Service > > Yes, I write AFL code to your requirements > > http://e-wire.net.au/~eb_kavan/ab_write.htm > > > > > > On 20/08/06, Terry <MagicTH@> wrote: > > > > > > Here's some code. > > > > > > > > > > > > In the Title statement, the date of the first bar of data is x [0] > > > > > > Note that this requires the SetBarsRequired due to quickAFL. > (This gets > > > you the actual first date of the symbol data up to ~400 years > ago for daily > > > bars.) > > > > > > > > > > > > y is, in fact, the date for one year ago. You can see it in the > chart > > > title. > > > > > > z "should be" the one year ago price, actually it is now looking > for how > > > many bars since the date one year ago, but it does not work. > Whenever I try > > > to do a compare or a ValueWhen using DateNum(), BarIndex() or > BarsSince() I > > > get empty values for the result. If you find a way, note to use > <= rather > > > than == in case the date one year ago is a weekend or other non- > trading > > > date. > > > > > > > > > > > > *Any wizards out there that can solve this problem?* > > > > > > > > > > > > SetBarsRequired(100000,0); > > > > > > x = DateNum(); > > > > > > y = x - 10000; //one year ago date > > > > > > z = BarsSince(DateNum() <= y); > > > > > > zC = Ref(*C*,-z); > > > > > > > > > > > > *Title* = "\nfirst date: " + NumToStr(x[0],1.0) > > > > > > + "\none year ago date: " + NumToStr(y,1.0) > > > > > > + "\none year ago price: " + NumToStr(zC,1.2) > > > > > > + "\ncurrent price: " + *C*; > > > > > > -- > > > > > > Terry > > > > > > > > > > > > -----Original Message----- > > > From: amibroker@yahoogroups.com > [mailto:[EMAIL PROTECTED] On > > > Behalf Of tipequity > > > Sent: Saturday, August 19, 2006 17:50 > > > To: amibroker@yahoogroups.com > > > Subject: [amibroker] Re: Newbie questins > > > > > > > > > > > > Thanks, Terry for quick response. I am looking for exact year > ago. > > > > > > Any idea on the second question? > > > > > > > > > > > > > > > > > > --- In amibroker@yahoogroups.com, "Terry" <MagicTH@> wrote: > > > > > > > > > > > > > > For approximate year ago date you can just use Ref(C,-252) > > > > > > > > > > > > > > For exact year ago date...sorry, I tried several things and > can't > > > > > > make > > > > > > > it work either! > > > > > > > -- > > > > > > > Terry > > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: amibroker@yahoogroups.com > [mailto:[EMAIL PROTECTED] > > > > > > On > > > > > > > Behalf Of tipequity > > > > > > > Sent: Saturday, August 19, 2006 16:11 > > > > > > > To: amibroker@yahoogroups.com > > > > > > > Subject: [amibroker] Newbie questins > > > > > > > > > > > > > > 1. how can refer to a calendar year ago prices (end of the > day), I > > > > > > > tried the following and it did not work: > > > > > > > > > > > > > > CloseAYearAgo = Ref(C,Year()-1); > > > > > > > > > > > > > > 2. how can I get the first date for which we have data (end of > the > > > > > > day) > > > > > > > > > > > > > > thanks > > > > > > > > > > > > > > Cam > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users > only. > > > > > > > > > > > > > > To get support from AmiBroker please send an e-mail directly to > > > > > > > SUPPORT {at} amibroker.com > > > > > > > > > > > > > > For other support material please check also: > > > > > > > http://www.amibroker.com/support.html > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users only. > > > > > > > > > > > > To get support from AmiBroker please send an e-mail directly to > > > > > > SUPPORT {at} amibroker.com > > > > > > > > > > > > For other support material please check also: > > > > > > http://www.amibroker.com/support.html > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > http://groups.yahoo.com/group/amibroker/ > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > http://docs.yahoo.com/info/terms/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For other support material please check also: > http://www.amibroker.com/support.html > > > Yahoo! Groups Links > Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/