|
PureBytes Links
Trading Reference Links
|
Heidi Stubner wrote:
> That is the formula that I have too, but when you actually plug in the
> numbers, it doesn't come up to the same value.
>
> Example:
>
> Ann Taylor Ticker ANN (Using 14 day)
>
> All of the up days = 9.502 / by 14 = .6787142857
> All of the down days = 4.252 / by 14 = .3037142857
>
> formula= 100 - ((100/(1+(.6787142857+.3037142857))))
>
> answer = 69.085
>
> Metastock = 64.833
> Reuters = 73.087
>
> This is using Friday's close. Why the difference? Any ideas? I'm not
> trying to plug in the formula to chart it, I'm using the default (14-day).
>
Hello Heidi,
The following is copied from Formula Field of my
*RSI canonical_12_day_for_P_I indicator. Change
m if you choose other # of periods n for rsi (instead
of n=12 that gives m=23 in the formula below).
Cheers,
Vitaly
{I wrote my own "canonical" RSI(12) which coincides with MS's RSI(12) if
m=2*n-1 where m is used below in Mov( ,m,E); n - a number of periods in
rsi(n). Mind that since I didn't use those particular tricks from the
standard rsi(n) to shorten the initial transitional period, this
function and the standard Metastock's rsi(n) differ for about month or so
from the day 1. It was not that important for me, so I used this shortcut.}
100 - 100/
(1.+ If(Mov(If(P-Ref(P,-1)<0,-(P-Ref(P,-1)),0),23,E)=0,1000000,
Mov(If(P-Ref(P,-1)>0, P-Ref(P,-1), 0),23,E)
/Mov(If(P-Ref(P,-1)<0,-(P-Ref(P,-1)),0),23,E)
))
|