Gold Customer
Joined: 7/26/2007 Posts: 26

I'm having trouble writing a PCF to use in an Easyscan for Wilder's 2 period RSI where:
two days ago RSI2 was below 65
and yesterday RSI2 was below RSI2 two days ago
and today RSI2 is below RSI2 yesterday
I searched the existing RSI2 posts and couldn't find what I needed. Any help would be appreciated.
Thanks,
Joe


Registered User Joined: 1/28/2005 Posts: 125

joemar1961;
> two days ago RSI2 was below 65
(RSI2.1.2 < 65)
> and yesterday RSI2 was below RSI2 two days ago
AND (RSI2.1.1 < RSI2.1.2)
> and today RSI2 is below RSI2 yesterday
AND (RSI2.1 < RSI2.1.1)
PCF Name: RSI2.1 down
((RSI2.1.2 < 65) AND (RSI2.1.1 < RSI2.1.2) AND (RSI2.1 < RSI2.1.1))
EasyScan:
WatchList to Scan:
[Add condition]s
...
. RSI2.2 down  True
ejr39


Gold Customer
Joined: 7/26/2007 Posts: 26

Thanks, but to my knowledge the Worden RSI is not the same as Wilder's RSI. If I am making a scan that utilizes Wilder's 2 period RSI then I would need the formula for Wilder's 2 period RSI.
But then I need to know how to use that formula for one day ago and two days ago.
Thanks,
Joe


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

joemar1961,
If you are talking a Wilder's RSI with the following settings:
 RSI Period: 2
 Use Wilders Smoothing: Checked
 Avg Period: 1
 Average Type: Doesn't matter (because the Avg Period is 1)
Then you might want to try the following formulas:
two days ago RSI2 was below 65:
50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16)))))))))))))))) + 50 < 65
yesterday RSI2 was below RSI2 two days ago:
50 * (C1  XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15)))))))))))))))) + 50 < 50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16)))))))))))))))) + 50
today RSI2 is below RSI2 yesterday:
50 * (C  XAVGC3.1) / 2 / (.500030519440884 * (ABS(C  C1) + .5 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14)))))))))))))))) + 50 < 50 * (C1  XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15)))))))))))))))) + 50
Put together would be:
50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16)))))))))))))))) + 50 < 65 AND 50 * (C1  XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15)))))))))))))))) + 50 < 50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16)))))))))))))))) + 50 AND 50 * (C  XAVGC3.1) / 2 / (.500030519440884 * (ABS(C  C1) + .5 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14)))))))))))))))) + 50 < 50 * (C1  XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1  C2) + .5 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15)))))))))))))))) + 50
That said, I might seriously consider using the following instead:
50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) + .5 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16)))))))))))))))) + 50 < 65 AND C1 < C2 AND C < C1
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 7/26/2007 Posts: 26

Thank you so much Bruce. I will try those and see how they work.
But now I'm wondering why the formula you provided here for today's Wilder's 2 period RSI is different from the one that was posted a couple years ago which started with:
100  ( 100 / ( 1 + ( 500.0305 * (C0C1>0) and then went on for 14 lines. Is one version more accurate than the other?
Thanks for the help.
Joe


Gold Customer
Joined: 7/26/2007 Posts: 26

While we're at it can you also provide me with the formula for this same RSI2 but this time for 3 days ago. I would like to double check myself.
Thank you so much,
Joe


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

joemar1961,
Neither version is more accurate, the version in this topic is more efficient.
2Period Wilder's Smoothed RSI (3Periods Ago):
50 * (C3  XAVGC3.4) / 2 / (.500030519440884 * (ABS(C3  C4) + .5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) + .5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) + .5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) + .5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) + .5 * (ABS(C15  C16) + .5 * (ABS(C16  C17)))))))))))))))) + 50
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 7/26/2007 Posts: 26

Thanks Bruce. I appreciate it.
Joe


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

You're welcome.
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 1/28/2005 Posts: 125

joemar1961;
Evaluate the 2period 2days ago RSI using Wilder's smoothing
with the 2period 2days ago RSI Simple and the 2period 2days
ago RSI Exponential
In a Middle or Bottom Window
(remove all other indicators)
. Custom Indicator (2 days ago, Wilder's RSI  Period:2 Average:1  Wilder's smoothing PCF)
__ Draw Color: white
__ Draw Style: Normal
__ Check: Visible
__ UNCheck: Center Zero Line
__ UNCheck: Plot using price scle
__ Smoothing Average: 1 Simple or Exponential (1 = no moving average)
__ Indicator Formula:
50 * (C2  XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2  C3) +
.5 * (ABS(C3  C4) +.5 * (ABS(C4  C5) + .5 * (ABS(C5  C6) +
.5 * (ABS(C6  C7) + .5 * (ABS(C7  C8) + .5 * (ABS(C8  C9) +
.5 * (ABS(C9  C10) + .5 * (ABS(C10  C11) + .5 * (ABS(C11  C12) +
.5 * (ABS(C12  C13) + .5 * (ABS(C13  C14) + .5 * (ABS(C14  C15) +
.5 * (ABS(C15  C16)))))))))))))))) + 50
. Custom Indicator (2days ago, Wilder's RSI  Period:2 Average:1  Simple)
__ Draw Color:
__ Draw Style: Normal
__ Check: Visible
__ UNCheck: Center Zero Line
__ UNCheck: Plot using price scle
__ Smoothing Average: 1 Simple or Exponential (1 = no moving average)
__ Indicator Formula: (RSI2.1.2)
Which charted is identical (overlays) to the following
. Custom Indicator (2days ago, Wilder's RSI  Period:2 Average:1  Exponential)
__ Draw Color:
__ Draw Style: Normal
__ Check: Visible
__ UNCheck: Center Zero Line
__ UNCheck: Plot using price scle
__ Smoothing Average: 1 Simple or Exponential (1 = no moving average)
__ Indicator Formula: XAVG(RSI2.1.2,1)
In the lower right corner of the screen, click the small scaling box
until the scale color is white  the RSI formula with Wilder's
smoothing is NOT on a 100 to 0 scale.
Note that all the lines travel together, the RSI2.1.2 and the XAVG(RSI2.2.2,) formulas
while less smooth are more definitive and may be a tad faster. AND the simple
formulas don’t have the added problem of guessing what the scale values are.
ejr39


Gold Customer
Joined: 7/26/2007 Posts: 26

Thank you.


Guest1 