Registered User Joined: 3/17/2016 Posts: 48
|
Hi,
I'm currently using the Indicator "Williams Vix Fix" written by Chris Moody on TradingView and found it very useful in observing and finding market bottoms.
The indicator is found here:
https://www.tradingview.com/script/og7JPrRA-CM-Williams-Vix-Fix-Finds-Market-Bottoms/
Here are the screenshots of the Indicator when I used to find bottoms for stocks in my portfolio.
Please can you help me to construct:
1) the chart and
2) easy scan for the green/lime bars indicated on the "CM_Williams_Vix_Fix"
Many thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Start by adding a Custom PCF Indicator with the Plot Style set to Histogram, the color set to grey and the following Formula.
100 * (1 - L / MAXC22)
How to add an indicator to a chart template
How to edit an Indicator
Then add another Custom PCF Indicator to the same pane and scale as the first one, but with the Plot Style set to Histogram, the color set to green and the following Formula.
100 * (1 - L / MAXC22) / ABS((100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20))
A Condition Formula to use as an EasyScan Condition to check for green bars can be written as follows.
How to create and save a Condition (PCF) Formula
How to Create an EasyScan and save it to the Library
(100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
QUOTE (Bruce_L)
A Condition Formula to use as an EasyScan Condition to check for green bars can be written as follows.
Can you do one for the inverse green bars to no geen bars.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula.
((100 * (1 - L / MAXC22) < 85 * (1 - L1 / MAXC22.1) OR 100 * (1 - L / MAXC22) < 85 * (1 - L2 / MAXC22.2) OR 100 * (1 - L / MAXC22) < 85 * (1 - L3 / MAXC22.3) OR 100 * (1 - L / MAXC22) < 85 * (1 - L4 / MAXC22.4) OR 100 * (1 - L / MAXC22) < 85 * (1 - L5 / MAXC22.5) OR 100 * (1 - L / MAXC22) < 85 * (1 - L6 / MAXC22.6) OR 100 * (1 - L / MAXC22) < 85 * (1 - L7 / MAXC22.7) OR 100 * (1 - L / MAXC22) < 85 * (1 - L8 / MAXC22.8) OR 100 * (1 - L / MAXC22) < 85 * (1 - L9 / MAXC22.9) OR 100 * (1 - L / MAXC22) < 85 * (1 - L10 / MAXC22.10) OR 100 * (1 - L / MAXC22) < 85 * (1 - L11 / MAXC22.11) OR 100 * (1 - L / MAXC22) < 85 * (1 - L12 / MAXC22.12) OR 100 * (1 - L / MAXC22) < 85 * (1 - L13 / MAXC22.13) OR 100 * (1 - L / MAXC22) < 85 * (1 - L14 / MAXC22.14) OR 100 * (1 - L / MAXC22) < 85 * (1 - L15 / MAXC22.15) OR 100 * (1 - L / MAXC22) < 85 * (1 - L16 / MAXC22.16) OR 100 * (1 - L / MAXC22) < 85 * (1 - L17 / MAXC22.17) OR 100 * (1 - L / MAXC22) < 85 * (1 - L18 / MAXC22.18) OR 100 * (1 - L / MAXC22) < 85 * (1 - L19 / MAXC22.19) OR 100 * (1 - L / MAXC22) < 85 * (1 - L20 / MAXC22.20) OR 100 * (1 - L / MAXC22) < 85 * (1 - L21 / MAXC22.21) OR 100 * (1 - L / MAXC22) < 85 * (1 - L22 / MAXC22.22) OR 100 * (1 - L / MAXC22) < 85 * (1 - L23 / MAXC22.23) OR 100 * (1 - L / MAXC22) < 85 * (1 - L24 / MAXC22.24) OR 100 * (1 - L / MAXC22) < 85 * (1 - L25 / MAXC22.25) OR 100 * (1 - L / MAXC22) < 85 * (1 - L26 / MAXC22.26) OR 100 * (1 - L / MAXC22) < 85 * (1 - L27 / MAXC22.27) OR 100 * (1 - L / MAXC22) < 85 * (1 - L28 / MAXC22.28) OR 100 * (1 - L / MAXC22) < 85 * (1 - L29 / MAXC22.29) OR 100 * (1 - L / MAXC22) < 85 * (1 - L30 / MAXC22.30) OR 100 * (1 - L / MAXC22) < 85 * (1 - L31 / MAXC22.31) OR 100 * (1 - L / MAXC22) < 85 * (1 - L32 / MAXC22.32) OR 100 * (1 - L / MAXC22) < 85 * (1 - L33 / MAXC22.33) OR 100 * (1 - L / MAXC22) < 85 * (1 - L34 / MAXC22.34) OR 100 * (1 - L / MAXC22) < 85 * (1 - L35 / MAXC22.35) OR 100 * (1 - L / MAXC22) < 85 * (1 - L36 / MAXC22.36) OR 100 * (1 - L / MAXC22) < 85 * (1 - L37 / MAXC22.37) OR 100 * (1 - L / MAXC22) < 85 * (1 - L38 / MAXC22.38) OR 100 * (1 - L / MAXC22) < 85 * (1 - L39 / MAXC22.39) OR 100 * (1 - L / MAXC22) < 85 * (1 - L40 / MAXC22.40) OR 100 * (1 - L / MAXC22) < 85 * (1 - L41 / MAXC22.41) OR 100 * (1 - L / MAXC22) < 85 * (1 - L42 / MAXC22.42) OR 100 * (1 - L / MAXC22) < 85 * (1 - L43 / MAXC22.43) OR 100 * (1 - L / MAXC22) < 85 * (1 - L44 / MAXC22.44) OR 100 * (1 - L / MAXC22) < 85 * (1 - L45 / MAXC22.45) OR 100 * (1 - L / MAXC22) < 85 * (1 - L46 / MAXC22.46) OR 100 * (1 - L / MAXC22) < 85 * (1 - L47 / MAXC22.47) OR 100 * (1 - L / MAXC22) < 85 * (1 - L48 / MAXC22.48) OR 100 * (1 - L / MAXC22) < 85 * (1 - L49 / MAXC22.49)) AND (1 - L / MAXC22) < (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)) AND ((100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L49 / MAXC22.49) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L50 / MAXC22.50)) OR (1 - L1 / MAXC22.1) >= (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) + 2 * SQR(ABS((1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 + (1 - L20 / MAXC22.20) ^ 2 - 20 * (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) ^ 2) / 20))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/17/2016 Posts: 48
|
QUOTE (Bruce_L)
Then add another Custom PCF Indicator to the same pane and scale as the first one, but with the Plot Style set to Histogram, the color set to green and the following Formula.
100 * (1 - L / MAXC22) / ABS((100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20))
A Condition Formula to use as an EasyScan Condition to check for green bars can be written as follows.
How to create and save a Condition (PCF) Formula
How to Create an EasyScan and save it to the Library
(100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)
Bruce,
Can the two formulas above be shortened in TC2000 V17
|
|
Registered User Joined: 3/17/2016 Posts: 48
|
And this
QUOTE
((100 * (1 - L / MAXC22) < 85 * (1 - L1 / MAXC22.1) OR 100 * (1 - L / MAXC22) < 85 * (1 - L2 / MAXC22.2) OR 100 * (1 - L / MAXC22) < 85 * (1 - L3 / MAXC22.3) OR 100 * (1 - L / MAXC22) < 85 * (1 - L4 / MAXC22.4) OR 100 * (1 - L / MAXC22) < 85 * (1 - L5 / MAXC22.5) OR 100 * (1 - L / MAXC22) < 85 * (1 - L6 / MAXC22.6) OR 100 * (1 - L / MAXC22) < 85 * (1 - L7 / MAXC22.7) OR 100 * (1 - L / MAXC22) < 85 * (1 - L8 / MAXC22.8) OR 100 * (1 - L / MAXC22) < 85 * (1 - L9 / MAXC22.9) OR 100 * (1 - L / MAXC22) < 85 * (1 - L10 / MAXC22.10) OR 100 * (1 - L / MAXC22) < 85 * (1 - L11 / MAXC22.11) OR 100 * (1 - L / MAXC22) < 85 * (1 - L12 / MAXC22.12) OR 100 * (1 - L / MAXC22) < 85 * (1 - L13 / MAXC22.13) OR 100 * (1 - L / MAXC22) < 85 * (1 - L14 / MAXC22.14) OR 100 * (1 - L / MAXC22) < 85 * (1 - L15 / MAXC22.15) OR 100 * (1 - L / MAXC22) < 85 * (1 - L16 / MAXC22.16) OR 100 * (1 - L / MAXC22) < 85 * (1 - L17 / MAXC22.17) OR 100 * (1 - L / MAXC22) < 85 * (1 - L18 / MAXC22.18) OR 100 * (1 - L / MAXC22) < 85 * (1 - L19 / MAXC22.19) OR 100 * (1 - L / MAXC22) < 85 * (1 - L20 / MAXC22.20) OR 100 * (1 - L / MAXC22) < 85 * (1 - L21 / MAXC22.21) OR 100 * (1 - L / MAXC22) < 85 * (1 - L22 / MAXC22.22) OR 100 * (1 - L / MAXC22) < 85 * (1 - L23 / MAXC22.23) OR 100 * (1 - L / MAXC22) < 85 * (1 - L24 / MAXC22.24) OR 100 * (1 - L / MAXC22) < 85 * (1 - L25 / MAXC22.25) OR 100 * (1 - L / MAXC22) < 85 * (1 - L26 / MAXC22.26) OR 100 * (1 - L / MAXC22) < 85 * (1 - L27 / MAXC22.27) OR 100 * (1 - L / MAXC22) < 85 * (1 - L28 / MAXC22.28) OR 100 * (1 - L / MAXC22) < 85 * (1 - L29 / MAXC22.29) OR 100 * (1 - L / MAXC22) < 85 * (1 - L30 / MAXC22.30) OR 100 * (1 - L / MAXC22) < 85 * (1 - L31 / MAXC22.31) OR 100 * (1 - L / MAXC22) < 85 * (1 - L32 / MAXC22.32) OR 100 * (1 - L / MAXC22) < 85 * (1 - L33 / MAXC22.33) OR 100 * (1 - L / MAXC22) < 85 * (1 - L34 / MAXC22.34) OR 100 * (1 - L / MAXC22) < 85 * (1 - L35 / MAXC22.35) OR 100 * (1 - L / MAXC22) < 85 * (1 - L36 / MAXC22.36) OR 100 * (1 - L / MAXC22) < 85 * (1 - L37 / MAXC22.37) OR 100 * (1 - L / MAXC22) < 85 * (1 - L38 / MAXC22.38) OR 100 * (1 - L / MAXC22) < 85 * (1 - L39 / MAXC22.39) OR 100 * (1 - L / MAXC22) < 85 * (1 - L40 / MAXC22.40) OR 100 * (1 - L / MAXC22) < 85 * (1 - L41 / MAXC22.41) OR 100 * (1 - L / MAXC22) < 85 * (1 - L42 / MAXC22.42) OR 100 * (1 - L / MAXC22) < 85 * (1 - L43 / MAXC22.43) OR 100 * (1 - L / MAXC22) < 85 * (1 - L44 / MAXC22.44) OR 100 * (1 - L / MAXC22) < 85 * (1 - L45 / MAXC22.45) OR 100 * (1 - L / MAXC22) < 85 * (1 - L46 / MAXC22.46) OR 100 * (1 - L / MAXC22) < 85 * (1 - L47 / MAXC22.47) OR 100 * (1 - L / MAXC22) < 85 * (1 - L48 / MAXC22.48) OR 100 * (1 - L / MAXC22) < 85 * (1 - L49 / MAXC22.49)) AND (1 - L / MAXC22) < (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)) AND ((100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L49 / MAXC22.49) AND 100 * (1 - L1/ MAXC22.1) >= 85 * (1 - L50 / MAXC22.50)) OR (1 - L1 / MAXC22.1) >= (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) + 2 * SQR(ABS((1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 + (1 - L20 / MAXC22.20) ^ 2 - 20 * (((1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19) + (1 - L20 / MAXC22.20)) / 20) ^ 2) / 20))
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The first formula (this should be plotted as histogram in the same pane and scale as 100 * (1 - L / MAXC22) but in a different color.):
100 * (1 - L / MAXC22) / ABS(100 * (1 - L / MAXC22) >= 85 * MAX(1 - L1 / MAXC22.1, 49) OR 1 - L / MAXC22 >= AVG(1 - L / MAXC22, 20) + 2 * ABS((SUM((1 - L / MAXC22) ^ 2, 20) - SUM(1 - L / MAXC22, 20) ^ 2 / 20) / 20) ^ .5)
The second formula:
100 * (1 - L / MAXC22) >= 85 * MAX(1 - L1 / MAXC22.1, 49) OR 1 - L / MAXC22 >= AVG(1 - L / MAXC22, 20) + 2 * ABS((SUM((1 - L / MAXC22) ^ 2, 20) - SUM(1 - L / MAXC22, 20) ^ 2 / 20) / 20) ^ .5
The third formula:
XUP(ABS(100 * (1 - L / MAXC22) < 85 * MAX(1 - L1 / MAXC22.1, 49) AND 1 - L / MAXC22 < AVG(1 - L / MAXC22, 20) + 2 * ABS((SUM((1 - L / MAXC22) ^ 2, 20) - SUM(1 - L / MAXC22, 20) ^ 2 / 20) / 20) ^ .5), 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/17/2016 Posts: 48
|
Wow this is amazing, the reduction in length of formulas in V17 is mind boggling.
Thanks Bruce
|
|
Registered User Joined: 7/29/2010 Posts: 417
|
QUOTE (Bruce_L)
Start by adding a Custom PCF Indicator with the Plot Style set to Histogram, the color set to grey and the following Formula.
100 * (1 - L / MAXC22)
How to add an indicator to a chart template
How to edit an Indicator
Then add another Custom PCF Indicator to the same pane and scale as the first one, but with the Plot Style set to Histogram, the color set to green and the following Formula.
100 * (1 - L / MAXC22) / ABS((100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20))
A Condition Formula to use as an EasyScan Condition to check for green bars can be written as follows.
How to create and save a Condition (PCF) Formula
How to Create an EasyScan and save it to the Library
(100 * (1 - L / MAXC22) >= 85 * (1 - L1 / MAXC22.1) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L2 / MAXC22.2) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L3 / MAXC22.3) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L4 / MAXC22.4) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L5 / MAXC22.5) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L6 / MAXC22.6) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L7 / MAXC22.7) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L8 / MAXC22.8) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L9 / MAXC22.9) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L10 / MAXC22.10) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L11 / MAXC22.11) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L12 / MAXC22.12) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L13 / MAXC22.13) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L14 / MAXC22.14) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L15 / MAXC22.15) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L16 / MAXC22.16) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L17 / MAXC22.17) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L18 / MAXC22.18) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L19 / MAXC22.19) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L20 / MAXC22.20) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L21 / MAXC22.21) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L22 / MAXC22.22) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L23 / MAXC22.23) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L24 / MAXC22.24) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L25 / MAXC22.25) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L26 / MAXC22.26) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L27 / MAXC22.27) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L28 / MAXC22.28) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L29 / MAXC22.29) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L30 / MAXC22.30) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L31 / MAXC22.31) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L32 / MAXC22.32) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L33 / MAXC22.33) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L34 / MAXC22.34) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L35 / MAXC22.35) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L36 / MAXC22.36) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L37 / MAXC22.37) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L38 / MAXC22.38) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L39 / MAXC22.39) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L40 / MAXC22.40) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L41 / MAXC22.41) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L42 / MAXC22.42) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L43 / MAXC22.43) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L44 / MAXC22.44) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L45 / MAXC22.45) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L46 / MAXC22.46) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L47 / MAXC22.47) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L48 / MAXC22.48) AND 100 * (1 - L / MAXC22) >= 85 * (1 - L49 / MAXC22.49)) OR (1 - L / MAXC22) >= (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) + 2 * SQR(ABS((1 - L / MAXC22) ^ 2 + (1 - L1 / MAXC22.1) ^ 2 + (1 - L2 / MAXC22.2) ^ 2 + (1 - L3 / MAXC22.3) ^ 2 + (1 - L4 / MAXC22.4) ^ 2 + (1 - L5 / MAXC22.5) ^ 2 + (1 - L6 / MAXC22.6) ^ 2 + (1 - L7 / MAXC22.7) ^ 2 + (1 - L8 / MAXC22.8) ^ 2 + (1 - L9 / MAXC22.9) ^ 2 + (1 - L10 / MAXC22.10) ^ 2 + (1 - L11 / MAXC22.11) ^ 2 + (1 - L12 / MAXC22.12) ^ 2 + (1 - L13 / MAXC22.13) ^ 2 + (1 - L14 / MAXC22.14) ^ 2 + (1 - L15 / MAXC22.15) ^ 2 + (1 - L16 / MAXC22.16) ^ 2 + (1 - L17 / MAXC22.17) ^ 2 + (1 - L18 / MAXC22.18) ^ 2 + (1 - L19 / MAXC22.19) ^ 2 - 20 * (((1 - L / MAXC22) + (1 - L1 / MAXC22.1) + (1 - L2 / MAXC22.2) + (1 - L3 / MAXC22.3) + (1 - L4 / MAXC22.4) + (1 - L5 / MAXC22.5) + (1 - L6 / MAXC22.6) + (1 - L7 / MAXC22.7) + (1 - L8 / MAXC22.8) + (1 - L9 / MAXC22.9) + (1 - L10 / MAXC22.10) + (1 - L11 / MAXC22.11) + (1 - L12 / MAXC22.12) + (1 - L13 / MAXC22.13) + (1 - L14 / MAXC22.14) + (1 - L15 / MAXC22.15) + (1 - L16 / MAXC22.16) + (1 - L17 / MAXC22.17) + (1 - L18 / MAXC22.18) + (1 - L19 / MAXC22.19)) / 20) ^ 2) / 20)
Bruce,
Please help me understand what is going on AFTER the OR in the middle formula.
Thank you,
Don
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It checks for the basic calculations of the indicator (100 * (1 - L / MAXC22)) to be above the top Bollinger Band 20, 2.00 as applied toi itself.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 7/29/2010 Posts: 417
|
Bruce,
Thank you very much.
Don
|
|
Registered User Joined: 10/7/2004 Posts: 2
|
Hi Bruce,
I find this to be a very interesting indicator. I see the second V17 formula finds the last bar green, and the third V17 formula finds the next to last bar green. How would I write an easy scan to find the last x number bars green, where I can change how many last green bars I am looking for, eg. 4, 5 or 6 in a row?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The first v17 formula is designed to put a dot on the chart when used as a Custom PCF Indicator with the Plot Style set to dot if there is a green bar.
The second v17 formula just returns true for green bars.
The third v17 formula just returns true when changing from green bars to gray bars.
A formula to count how many green bars there are in a row could be written as follows.
TrueInRow(100 * (1 - L / MAXC22) >= 85 * MAX(1 - L1 / MAXC22.1, 49) OR 1 - L / MAXC22 >= AVG(1 - L / MAXC22, 20) + 2 * ABS((SUM((1 - L / MAXC22) ^ 2, 20) - SUM(1 - L / MAXC22, 20) ^ 2 / 20) / 20) ^ .5, 50)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 2
|
Thanks Bruce,
I don't know what we would do without you. This works perfectly for a scan.
|
|
Registered User Joined: 1/16/2005 Posts: 2
|
I am seeing different displays (incorrect values) for these PCF"s based on whether I'm using the Mobile App, the installed TC2000 version (latest) or leveraging the 12.5 Browser version. What is the advise specifically concerning the mobile clienbetween the 3 methods to access my account to get these to display correctly and consistently across all 3?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Certainly the new formula for TC2000 v17 is only going to work in TC2000 v17. It will not work in TC2000 v12.5 or the mobile version.
You will want to use the older versions of these types of formulas if you need the fomulas to work in older versions of TC2000.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/18/2012 Posts: 40
|
FWIW, an alternate approach to the the TrueInRowformula Bruce put together in his Feb 21 post is
CountTrue(100 * (1 - L / MAXC22) >= 85 * MAX(1 - L1 / MAXC22.1, 49) OR 1 - L / MAXC22 >= AVG(1 - L / MAXC22, 20) + 2 * ABS((SUM((1 - L / MAXC22) ^ 2, 20) - SUM(1 - L / MAXC22, 20) ^ 2 / 20) / 20) ^ .5, 10)
Which returns the number of Green Lines in the last 10 days. This formula would return a count of 9 if the second last was not green,whereas the original formula would return a count of one
|
|
Guest-1 |