 Gold Customer
Joined: 11/25/2004
Posts: 79
Location: Illinois
|
What would be the best way to determine whether XAVGC5 stayed above XAVGC23 for the last 30 days?
I tried; MIN(XAVGC5.1,29) > MAX(XAVGC23.1,29) and finally figured out why it can't work.
Will I have to test each day individually? (such as; XAVGC5.29 > XAVGC23.29 AND XAVGC5.28 > XAVGC23.28 AND ....... etc., etc.)
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, you will have to test each day individually.
XAVGC5 > XAVGC23 AND XAVGC5.1 > XAVGC23.1 AND XAVGC5.2 > XAVGC23.2 AND XAVGC5.3 > XAVGC23.3 AND XAVGC5.4 > XAVGC23.4 AND XAVGC5.5 > XAVGC23.5 AND XAVGC5.6 > XAVGC23.6 AND XAVGC5.7 > XAVGC23.7 AND XAVGC5.8 > XAVGC23.8 AND XAVGC5.9 > XAVGC23.9 AND XAVGC5.10 > XAVGC23.10 AND XAVGC5.11 > XAVGC23.11 AND XAVGC5.12 > XAVGC23.12 AND XAVGC5.13 > XAVGC23.13 AND XAVGC5.14 > XAVGC23.14 AND XAVGC5.15 > XAVGC23.15 AND XAVGC5.16 > XAVGC23.16 AND XAVGC5.17 > XAVGC23.17 AND XAVGC5.18 > XAVGC23.18 AND XAVGC5.19 > XAVGC23.19 AND XAVGC5.20 > XAVGC23.20 AND XAVGC5.21 > XAVGC23.21 AND XAVGC5.22 > XAVGC23.22 AND XAVGC5.23 > XAVGC23.23 AND XAVGC5.24 > XAVGC23.24 AND XAVGC5.25 > XAVGC23.25 AND XAVGC5.26 > XAVGC23.26 AND XAVGC5.27 > XAVGC23.27 AND XAVGC5.28 > XAVGC23.28 AND XAVGC5.29 > XAVGC23.29
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Gold Customer
Joined: 11/25/2004
Posts: 79
Location: Illinois
|
Thankyou Bruce, for the formula - I copied & pasted and it works like a charm (sure saved a lot of typing).
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|