|
PureBytes Links
Trading Reference Links
|
Heidi,
I beleive that you are looking for the reference function.
SYNTAX ref( DATA ARRAY, PERIODS )
FUNCTION References a previous or subsequent element in a DATA ARRAY. A positive PERIOD references "n" periods in the future; a negative PERIOD references "n" periods ago.
EXAMPLE The formula "ref( CLOSE, -12 )" returns the closing price 12 periods ago. Thus, you could write the 12-day price rate-of-change (expressed in points) as "C - ref( C, -12 )." The formula "ref( C, +12 )" returns the closing price 12 periods ahead.
You may want something like the following (This is only an example...it is looking for anything that had the RSI value above 70, 10 bars back and the current RSI is below 70, but above 30)
Ref(RSI(14),-10) > 70 and RSI(14) < 70 and RSI(14) > 30
---
Joe
On Wed, 01 Nov 2000 10:52:57
Heidi Stubner wrote:
>This is my 3rd try over the past 2 days at posting this message. I
>apologize if this is a duplication.
>
>Formula Question:
>
>I'm trying to find securities have a RSI which was overbought 10 days ago
>and now has fallen. I'm searching the manual to determine how to specify
>"DAYS AGO" but I am unable. I think it pertains to DATA ARRAY, but I just
>can't get it to work.
>
>I plan on combining this with a Parabolic SAR (the formula I have solved).
>
>Thanks .
Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com
|