Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF For Williams Vix Fix - Finds Market Bottoms Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
usmansajid
Posted : Monday, July 25, 2016 8:37:37 AM
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

Bruce_L
Posted : Monday, July 25, 2016 1:30:47 PM


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
diceman
Posted : Monday, July 25, 2016 3:22:44 PM
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

 

 

 

 

Bruce_L
Posted : Monday, July 25, 2016 3:51:23 PM


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
usmansajid
Posted : Thursday, February 2, 2017 1:21:56 PM
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

usmansajid
Posted : Thursday, February 2, 2017 1:35:51 PM
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))
 

Bruce_L
Posted : Thursday, February 2, 2017 1:51:14 PM


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
usmansajid
Posted : Thursday, February 2, 2017 3:14:16 PM
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

donv98
Posted : Monday, February 6, 2017 11:57:15 AM
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

Bruce_L
Posted : Monday, February 6, 2017 1:07:05 PM


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
donv98
Posted : Monday, February 6, 2017 1:12:51 PM
Registered User
Joined: 7/29/2010
Posts: 417

Bruce,

Thank you very much.

Don

Cfdiu
Posted : Monday, February 20, 2017 5:34:37 PM
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?

Bruce_L
Posted : Tuesday, February 21, 2017 11:26:12 AM


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
Cfdiu
Posted : Tuesday, February 21, 2017 2:22:27 PM
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.

FJA
Posted : Sunday, April 23, 2017 8:45:19 PM
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?   

Bruce_L
Posted : Monday, April 24, 2017 12:15:46 PM


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
BillÇochrane
Posted : Monday, April 24, 2017 9:18:35 PM
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

 

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.