Registered User Joined: 2/10/2010 Posts: 26
|
Is there a way to average a function?
For example, a 14 day simple average of ((C-XAvgC6)*SGN(C>XavgC16))
The PCF Avg((C-XavgC6)*SGN(C>Xavg6),14) does not work.
The actual complete formula would be something like this:
100 - ( 100 / ( 1 + (Avg((C-XavgC6)*SGN(C>Xavg6),14) / Avg((XavgC6-C)*SGN(XavgC6>C),14)))
Appreciate your help in showing me whether this is possible to do. Thanks.
The forumula is called Slow RSI and is in Technical Analysis of Stocks and Commodities magazine April 2015 issue.
David Chu
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You are going to have to manually expand the moving averages.
100 - ( 100 / ( 1 + ((C > XAVGC6) * (C - XAVGC6) + (C1 > XAVGC6.1) * (C1 - XAVGC6.1) + (C2 > XAVGC6.2) * (C2 - XAVGC6.2) + (C3 > XAVGC6.3) * (C3 - XAVGC6.3) + (C4 > XAVGC6.4) * (C4 - XAVGC6.4) + (C5 > XAVGC6.5) * (C5 - XAVGC6.5) + (C6 > XAVGC6.6) * (C6 - XAVGC6.6) + (C7 > XAVGC6.7) * (C7 - XAVGC6.7) + (C8 > XAVGC6.8) * (C8 - XAVGC6.8) + (C9 > XAVGC6.9) * (C9 - XAVGC6.9) + (C10 > XAVGC6.10) * (C10 - XAVGC6.10) + (C11 > XAVGC6.11) * (C11 - XAVGC6.11) + (C12 > XAVGC6.12) * (C12 - XAVGC6.12) + (C13 > XAVGC6.13) * (C13 - XAVGC6.13)) / ((C < XAVGC6) * (XAVGC6 - C) + (C1 < XAVGC6.1) * (XAVGC6.1 - C1) + (C2 < XAVGC6.2) * (XAVGC6.2 - C2) + (C3 < XAVGC6.3) * (XAVGC6.3 - C3) + (C4 < XAVGC6.4) * (XAVGC6.4 - C4) + (C5 < XAVGC6.5) * (XAVGC6.5 - C5) + (C6 < XAVGC6.6) * (XAVGC6.6 - C6) + (C7 < XAVGC6.7) * (XAVGC6.7 - C7) + (C8 < XAVGC6.8) * (XAVGC6.8 - C8) + (C9 < XAVGC6.9) * (XAVGC6.9 - C9) + (C10 < XAVGC6.10) * (XAVGC6.10 - C10) + (C11 < XAVGC6.11) * (XAVGC6.11 - C11) + (C12 < XAVGC6.12) * (XAVGC6.12 - C12) + (C13 < XAVGC6.13) * (XAVGC6.13 - C13))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|