|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxxxxxxxx, "Terry" <MagicTH@xxx> 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@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
On
> Behalf Of tipequity
> Sent: Saturday, August 19, 2006 23:27
> To: amibroker@xxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx, 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@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx] On
> > > Behalf Of tipequity
> > > Sent: Saturday, August 19, 2006 17:50
> > > To: amibroker@xxxxxxxxxxxxxxx
> > > 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@xxxxxxxxxxxxxxx, "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@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx]
> > >
> > > On
> > >
> > > > Behalf Of tipequity
> > >
> > > > Sent: Saturday, August 19, 2006 16:11
> > >
> > > > To: amibroker@xxxxxxxxxxxxxxx
> > >
> > > > 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/
> > >
> > >
> > >
> > > amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > >
> > >
> > > 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
>
|