|
PureBytes Links
Trading Reference Links
|
Hi Terry, maybe this? Haven't tried it...
z = ValueWhen( x <= LastValue( y ), Close );
Steve
----- Original Message -----
From: Terry
To: amibroker@xxxxxxxxxxxxxxx
Sent: Saturday, August 19, 2006 8:34 PM
Subject: RE: [amibroker] Re: Newbie questins
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@xxx> 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/
|