Registered User
Joined: 10/7/2004
Posts: 1,178
|
I am setting the TimeFrame to Quarterly in each of these PCF Indicators:
% Return in Recent Quarter
100 * (C1 / C2 - 1)
% Return in Previous Quarter
100 * (C2 / C3 - 1)
If I want to compare the return of the current quarter to the return of the previous quarter, I've tried this fomula. For the most part it works. But not entirely.
(100 * (C1 / C2 - 1))>(100 * (C2 / C3 - 1))
I am confident you can improve this.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You could shorten it.
C1 / C2 > C2 / C3
Or
C1 * C3 > C2 * C2
But I don't see any reason why the formula wouldn't work exactly as you have written it.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
The two formulas you offered above do work in all instances tested against stocks, ADRs, and ETFs. Thanks, Bruce.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|