Re: Referencing X bars back

["Glynn Chamberlain" <glynsay@xxxxxxxxxxx>]

Hi David and Roy, and listmembers

Thanks very much for the pointers, the info is perfect and just what I
wanted. Your help is much appreciated.

Thanks and keep well

Glynn

----- Original Message -----
From: Roy Larsen <rlarsen@xxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, January 03, 2002 2:43 AM
Subject: Re: Referencing X bars back


> Glynn
>
> > BarsSince(Cross(Mov(CLOSE,50,S),Mov(CLOSE,200,S)))
> >
> > What I would now like to do is find out what the numerical difference
> between
> > the 200 and 50 day moving ave for both days "before" the occurrence was.
> >
> > So theoretically if the alert showed that the crossover happened 12 days
> ago,
> > Col B and Col C would show the Moving average difference for 13 and 14
> days previously.
>
>   {Exploration}
>
> ColumnA: B/Since
>
> BarsSince(Cross(Mov(CLOSE,50,S),Mov(CLOSE,200,S)));
>
> ColumnB: -2 Bars
>
> Bars:=LastValue(BarsSince(Cross(Mov(CLOSE,50,S),Mov(CLOSE,200,S))));
>
> Abs(LastValue(Ref(Mov(C,50,S),-Bars-2)- Ref(Mov(C,200,S),-Bars-2)));
>
> ColumnC: -1 Bar
>
> Bars:=LastValue(BarsSince(Cross(Mov(CLOSE,50,S),Mov(CLOSE,200,S))));
>
> Abs(LastValue(Ref(Mov(C,50,S),-Bars-1)- Ref(Mov(C,200,S),-Bars-1)));
>
>
>
> {Recommend you use minimum 500 bars, preferably more}
>
>
> > A last question. How would I write a formula referencing x bars back.
I.E.
> If I wanted
> > to know the close of 6 bars ago, how would I write this. I have searched
> like mad
> > through the MS help, but just cant seem to find it. I am sure it is a
> mental block.
>
> I think it was Tom Sprunger who included some suggestions from Equis on a
> slightly different matter, but the suggested method of using LastValue()
to
> create a constant appears to be the way to go for your problem. I have
used
> LastValue() in the exploration, and the one issue that I checked had
> returned the correct values for columns B and C.
>
> Because of the long MA's you are using it is probable that using less than
> 500 bars in the exploration will give an unacceptable number of N/A
results.
> Note also that the LastValue() function cannot be used in the same way for
> system testing as it is being used in the sample exploration.
>
> It may be that the key to your second question lies with being able to
> identify a codeable event that corresponds to the number of bars back that
> you want to check. Your question leaves me a little uncertain as to what
you
> are trying to achieve.
>
> Roy
>
>
>