Registered User Joined: 5/11/2017 Posts: 1
|
Hi,
I need to calculate n period simple average of up (or down) closes; these are basically nominator and denominator of RS equation but I need them separately.
Thanks,
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you really mean what might be used in a plain RSI without Wilder's smoothing, you would use something like the following for the ups.
AVG(IIF(C > C1, C - C1, 0), 14)
And something like the following for the downs.
AVG(IIF(C1 > C, C1 - C, 0), 14)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|