Registered User Joined: 6/24/2005 Posts: 9
|
Would someone please help me write a pcf that shows a price increase over the last six months, the last month, and the last week? Many thanks, Roy Stanford
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Condition Formulas to check if price has increased over six months, one month and one week could be written using a daily time frame as:
6 months:
C > C126
1 month:
C > C21
1 week:
C > C5
A Condition Formula to check for all three would be:
C > C126 AND C > C21 AND C > C5
If you actually wanted to quantify the percent changes for each period, you would get the following Indicator Formulas:
6 months:
100 * (C / C126 - 1)
1 month:
100 * (C / C21 - 1)
1 week:
100 * (C / C5 - 1)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|