Registered User Joined: 4/27/2006 Posts: 10
|
How would I create a weekly moving average pcf.
Would this be the proper format:
AVGC20 > AVGC20.5
if I wanted the 20 week moving average to be above the previous week's 20 week moving average?
Don Duhon
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
That would compare the current 20-Day Simple Moving Average to the 20-Day Simple Moving Average 5-Days (1-Week) ago. One way to write the desired formula would be:
(C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) / 20 > (C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) / 20
But this can be simplified quite a bit to:
C > C100
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|