Registered User Joined: 1/8/2005 Posts: 118
|
I need a PCF to find a stocks H-L 5 day average expressed as a %. Thank you for your help.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you want the Percent calculated based on the Average Low:
100 * (AVGH5 / AVGL5 - 1)
If you want the Average of the Percent differences based on each Low instead:
100 * (H / L + H1 / L1 + H2 / L2 + H3 / L3 + H4 / L4 - 5) / 5
There are lots of other possible interpretations of your request.
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|