| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/28/2008
Posts: 19
|
Hi guys
How would I write that the highest closing price of this 6 months is 5% lower that the previous 6 months? Isn’t
(MAXC126 < MAXC126.126) *1.05
and if that is right how would I write the following 6 months. would it be (MAXC126.126 < MAXC250)
what i would like to say is that the highest closing price 1 ½ ago is lower that the highest closing price a year ago. And the highest closing price a year ago is higher that the last 6 months high by at least 5%
thanks
Andrew
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You don't need the parentheses and they actually change the meaning of the formula so it doesn't work in this case. You are checking for current 6-Months to be less than 5% above the previous 6-Months. Please try the following instead:
MAXC126 < MAXC126.126 * .95
If you want to test for the highest closing price in the previous 6-Months to more than 5% lower than the 6-Months before that, please try the following:
MAXC126.126 < MAXC126.252 * .95
The pattern continues as you go back in time. So for the 6-Months before that you would use:
MAXC126.252 < MAXC126.378 * .95
Reversing these formulas results in:
Current 6-Month Highest Close more than 5% above the previous 6-Months:
MAXC126 > MAXC126.126 * 1.05
Shifting this six months results in:
MAXC126.126 > MAXC126.252 * 1.05
Shifting this another six months results in:
MAXC126.252 > MAXC126.378 * 1.05
You may wish to review the following:
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
How to create a Personal Criteria Forumula (PCF)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/28/2008
Posts: 19
|
thank you bruce
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |