Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Well the Boolean Formula you would use in the Custom PCF % True Indicator should be fairly simple for MS.
MS > MAX(MS1.1,40)
As well as for something like a simple 18-period TSV.
TSV18 > MAX(TSV18.1,40)
But the formula would be quite long for something like an exponential 21-period TSV because you would need to make each comparison individually.
XAVG(TSV,21) > XAVG(TSV1.1,21) AND XAVG(TSV,21) > XAVG(TSV1.2,21) AND XAVG(TSV,21) > XAVG(TSV1.3,21) AND XAVG(TSV,21) > XAVG(TSV1.4,21) AND XAVG(TSV,21) > XAVG(TSV1.5,21) AND XAVG(TSV,21) > XAVG(TSV1.6,21) AND XAVG(TSV,21) > XAVG(TSV1.7,21) AND XAVG(TSV,21) > XAVG(TSV1.8,21) AND XAVG(TSV,21) > XAVG(TSV1.9,21) AND XAVG(TSV,21) > XAVG(TSV1.10,21) AND XAVG(TSV,21) > XAVG(TSV1.11,21) AND XAVG(TSV,21) > XAVG(TSV1.12,21) AND XAVG(TSV,21) > XAVG(TSV1.13,21) AND XAVG(TSV,21) > XAVG(TSV1.14,21) AND XAVG(TSV,21) > XAVG(TSV1.15,21) AND XAVG(TSV,21) > XAVG(TSV1.16,21) AND XAVG(TSV,21) > XAVG(TSV1.17,21) AND XAVG(TSV,21) > XAVG(TSV1.18,21) AND XAVG(TSV,21) > XAVG(TSV1.19,21) AND XAVG(TSV,21) > XAVG(TSV1.20,21) AND XAVG(TSV,21) > XAVG(TSV1.21,21) AND XAVG(TSV,21) > XAVG(TSV1.22,21) AND XAVG(TSV,21) > XAVG(TSV1.23,21) AND XAVG(TSV,21) > XAVG(TSV1.24,21) AND XAVG(TSV,21) > XAVG(TSV1.25,21) AND XAVG(TSV,21) > XAVG(TSV1.26,21) AND XAVG(TSV,21) > XAVG(TSV1.27,21) AND XAVG(TSV,21) > XAVG(TSV1.28,21) AND XAVG(TSV,21) > XAVG(TSV1.29,21) AND XAVG(TSV,21) > XAVG(TSV1.30,21) AND XAVG(TSV,21) > XAVG(TSV1.31,21) AND XAVG(TSV,21) > XAVG(TSV1.32,21) AND XAVG(TSV,21) > XAVG(TSV1.33,21) AND XAVG(TSV,21) > XAVG(TSV1.34,21) AND XAVG(TSV,21) > XAVG(TSV1.35,21) AND XAVG(TSV,21) > XAVG(TSV1.36,21) AND XAVG(TSV,21) > XAVG(TSV1.37,21) AND XAVG(TSV,21) > XAVG(TSV1.38,21) AND XAVG(TSV,21) > XAVG(TSV1.39,21) AND XAVG(TSV,21) > XAVG(TSV1.40,21)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Min Max PCFs
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following for the 12-period exponential TSV.
XAVG(TSV,12) > XAVG(TSV1.1,12) AND XAVG(TSV,12) > XAVG(TSV1.2,12) AND XAVG(TSV,12) > XAVG(TSV1.3,12) AND XAVG(TSV,12) > XAVG(TSV1.4,12) AND XAVG(TSV,12) > XAVG(TSV1.5,12) AND XAVG(TSV,12) > XAVG(TSV1.6,12) AND XAVG(TSV,12) > XAVG(TSV1.7,12) AND XAVG(TSV,12) > XAVG(TSV1.8,12) AND XAVG(TSV,12) > XAVG(TSV1.9,12) AND XAVG(TSV,12) > XAVG(TSV1.10,12) AND XAVG(TSV,12) > XAVG(TSV1.11,12) AND XAVG(TSV,12) > XAVG(TSV1.12,12) AND XAVG(TSV,12) > XAVG(TSV1.13,12) AND XAVG(TSV,12) > XAVG(TSV1.14,12) AND XAVG(TSV,12) > XAVG(TSV1.15,12) AND XAVG(TSV,12) > XAVG(TSV1.16,12) AND XAVG(TSV,12) > XAVG(TSV1.17,12) AND XAVG(TSV,12) > XAVG(TSV1.18,12) AND XAVG(TSV,12) > XAVG(TSV1.19,12) AND XAVG(TSV,12) > XAVG(TSV1.20,12) AND XAVG(TSV,12) > XAVG(TSV1.21,12) AND XAVG(TSV,12) > XAVG(TSV1.22,12) AND XAVG(TSV,12) > XAVG(TSV1.23,12) AND XAVG(TSV,12) > XAVG(TSV1.24,12) AND XAVG(TSV,12) > XAVG(TSV1.25,12) AND XAVG(TSV,12) > XAVG(TSV1.26,12) AND XAVG(TSV,12) > XAVG(TSV1.27,12) AND XAVG(TSV,12) > XAVG(TSV1.28,12) AND XAVG(TSV,12) > XAVG(TSV1.29,12) AND XAVG(TSV,12) > XAVG(TSV1.30,12) AND XAVG(TSV,12) > XAVG(TSV1.31,12) AND XAVG(TSV,12) > XAVG(TSV1.32,12) AND XAVG(TSV,12) > XAVG(TSV1.33,12) AND XAVG(TSV,12) > XAVG(TSV1.34,12) AND XAVG(TSV,12) > XAVG(TSV1.35,12) AND XAVG(TSV,12) > XAVG(TSV1.36,12) AND XAVG(TSV,12) > XAVG(TSV1.37,12) AND XAVG(TSV,12) > XAVG(TSV1.38,12) AND XAVG(TSV,12) > XAVG(TSV1.39,12) AND XAVG(TSV,12) > XAVG(TSV1.40,12)
And the following for the 18-period exponential TSV.
XAVG(TSV,18) > XAVG(TSV1.1,18) AND XAVG(TSV,18) > XAVG(TSV1.2,18) AND XAVG(TSV,18) > XAVG(TSV1.3,18) AND XAVG(TSV,18) > XAVG(TSV1.4,18) AND XAVG(TSV,18) > XAVG(TSV1.5,18) AND XAVG(TSV,18) > XAVG(TSV1.6,18) AND XAVG(TSV,18) > XAVG(TSV1.7,18) AND XAVG(TSV,18) > XAVG(TSV1.8,18) AND XAVG(TSV,18) > XAVG(TSV1.9,18) AND XAVG(TSV,18) > XAVG(TSV1.10,18) AND XAVG(TSV,18) > XAVG(TSV1.11,18) AND XAVG(TSV,18) > XAVG(TSV1.12,18) AND XAVG(TSV,18) > XAVG(TSV1.13,18) AND XAVG(TSV,18) > XAVG(TSV1.14,18) AND XAVG(TSV,18) > XAVG(TSV1.15,18) AND XAVG(TSV,18) > XAVG(TSV1.16,18) AND XAVG(TSV,18) > XAVG(TSV1.17,18) AND XAVG(TSV,18) > XAVG(TSV1.18,18) AND XAVG(TSV,18) > XAVG(TSV1.19,18) AND XAVG(TSV,18) > XAVG(TSV1.20,18) AND XAVG(TSV,18) > XAVG(TSV1.21,18) AND XAVG(TSV,18) > XAVG(TSV1.22,18) AND XAVG(TSV,18) > XAVG(TSV1.23,18) AND XAVG(TSV,18) > XAVG(TSV1.24,18) AND XAVG(TSV,18) > XAVG(TSV1.25,18) AND XAVG(TSV,18) > XAVG(TSV1.26,18) AND XAVG(TSV,18) > XAVG(TSV1.27,18) AND XAVG(TSV,18) > XAVG(TSV1.28,18) AND XAVG(TSV,18) > XAVG(TSV1.29,18) AND XAVG(TSV,18) > XAVG(TSV1.30,18) AND XAVG(TSV,18) > XAVG(TSV1.31,18) AND XAVG(TSV,18) > XAVG(TSV1.32,18) AND XAVG(TSV,18) > XAVG(TSV1.33,18) AND XAVG(TSV,18) > XAVG(TSV1.34,18) AND XAVG(TSV,18) > XAVG(TSV1.35,18) AND XAVG(TSV,18) > XAVG(TSV1.36,18) AND XAVG(TSV,18) > XAVG(TSV1.37,18) AND XAVG(TSV,18) > XAVG(TSV1.38,18) AND XAVG(TSV,18) > XAVG(TSV1.39,18) AND XAVG(TSV,18) > XAVG(TSV1.40,18)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|