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

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)

Can you do one for the inverse  green bars to no geen bars.

Thanks

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, 

Can the two formulas above be shortened in TC2000 V17

And this

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)

Wow this is amazing, the reduction in length of formulas in V17 is mind boggling.

Thanks Bruce

Bruce,

  Please help me understand what is going on AFTER the OR in the middle formula.

Thank you,

Don

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,

Thank you very much.

Don

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?

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)

Thanks Bruce,

I don't know what we would do without you. This works perfectly for a scan.

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?   

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.

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