Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

6 months high Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tdbroker
Posted : Wednesday, March 19, 2008 3:13:00 PM
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

Bruce_L
Posted : Wednesday, March 19, 2008 3:22:02 PM


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
tdbroker
Posted : Wednesday, March 19, 2008 3:49:28 PM
Registered User
Joined: 1/28/2008
Posts: 19
thank you bruce
Bruce_L
Posted : Wednesday, March 19, 2008 3:51:47 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.