Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 1,178
|
I'd like to create a custom PCF. It would show a peak when the Price Percent Change 3-Month is greater than the Price Percent Change 1-Year.
I am hoping this is possible. Thanks in advance.
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I should have stipulated that the Price Percent Change 3-Month be annualized (multiplied by 4) to contrast it with the Price Percent Change 1-Year.
Traderlady
|
|
Registered User Joined: 3/20/2011 Posts: 25
|
QUOTE (traderlady)
I'd like to create a custom PCF. It would show a peak when the Price Percent Change 3-Month is greater than the Price Percent Change 1-Year.
I am hoping this is possible. Thanks in advance.
Condition: (C-C66)>(C-C240)
|
|
Registered User Joined: 3/20/2011 Posts: 25
|
QUOTE (traderlady)
I should have stipulated that the Price Percent Change 3-Month be annualized (multiplied by 4) to contrast it with the Price Percent Change 1-Year.
Traderlady
Sorry. Condition: (C-C66)/C66 > (C-C244)/C244
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Multiplying the three month results by four would not correctly annualize the results:
4 * (C / C63 -1) > C / C252 - 1
You would need to raise the three month results to the power of four instead:
((C / C63) ^ 4 - 1) > C / C252 - 1
As the correct formula for annualizing results would be:
((((100 + % change) / 100) ^ (1 year / time held)) * 100) - 100
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |