Bruce as mentioned earlier i like pattern trading so here i have back tested and worked with you on few formulas and they certainly give good results BASED ON FRACTALS

so what i use from my previous post as fractal dots is as below 

Higher High: GREEN DOT 

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 > IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, H5, IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, H6, IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, H7, IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, H8, IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, H9, IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, H10, IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, H11, IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, H12, IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, H13, IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, H14, IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, H15, IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, H16, IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, H17, IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, H18, IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, H19, IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, H20, IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, H21, IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, H22, IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, H23, IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, H24, IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, H25, IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, H26, IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, H27, IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, H28, IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, H29, IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, H30, IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, H31, IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, H32, IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, H33, IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, H34, IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, H35, IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, H36, IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, H37, IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, H38, IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, H39, IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, H40, IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, H41, IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, H42, IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, H43, IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, H44, IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, H45, IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, H46, IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, H47, IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, H48, IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, H49, IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, H50, IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, H51, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), H2, 0)

Lower High:PURPLE DOT 

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 < IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, H5, IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, H6, IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, H7, IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, H8, IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, H9, IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, H10, IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, H11, IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, H12, IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, H13, IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, H14, IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, H15, IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, H16, IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, H17, IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, H18, IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, H19, IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, H20, IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, H21, IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, H22, IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, H23, IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, H24, IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, H25, IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, H26, IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, H27, IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, H28, IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, H29, IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, H30, IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, H31, IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, H32, IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, H33, IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, H34, IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, H35, IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, H36, IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, H37, IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, H38, IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, H39, IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, H40, IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, H41, IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, H42, IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, H43, IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, H44, IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, H45, IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, H46, IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, H47, IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, H48, IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, H49, IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, H50, IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, H51, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), H2, 0)

Higher Low: ORANGE DOT

IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 > IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 0)

Lower Low: RED DOT 

IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 0)

Now i m aware that ZIGZAG indicator is not in-bulit into TC2000 but can u customize a PCF WHICH IS A LINE FORM INDICATOR WHICH CAN BE OVERLAYED ON SAME PANE AND SCALE AS PRICE  CONNECTING DOTS OF HIGHER HIGH TO LOWER LOW AND LOWER LOW TO HIGHER HIGH AS YOU SEE IN THE LINK HERE http://www.dhirenshah.com/harmonic-test-1/ and its should be ongoing as chart goes in future -- and if we can check on 250-300 bars of past it will be great 

All I did is took consecutive TURNING POINTS and drew lines with these parameters

DEVIATION : 3 %  AND DEPTH : 2(which is minimum number of price bars required where there is no secondary high or low )

Let me know what you think and its no rush , I know if you give time to it you will come up with solution 

Cheers

Dhiren 

Sorry, but no, I can't do that. About the best you can do using the connect higher high and lower lows is nest together the higher high and lower low and return 1 / 0 if neither condition is met. This would allow you to use the line Plot Style to "connect the dots".

Unfortunately, this means you can't use the offset moving average technique to shift things to the actual dots, but if you return zero, the line plot won't look right either.

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 > IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, H5, IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, H6, IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, H7, IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, H8, IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, H9, IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, H10, IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, H11, IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, H12, IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, H13, IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, H14, IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, H15, IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, H16, IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, H17, IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, H18, IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, H19, IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, H20, IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, H21, IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, H22, IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, H23, IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, H24, IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, H25, IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, H26, IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, H27, IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, H28, IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, H29, IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, H30, IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, H31, IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, H32, IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, H33, IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, H34, IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, H35, IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, H36, IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, H37, IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, H38, IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, H39, IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, H40, IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, H41, IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, H42, IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, H43, IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, H44, IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, H45, IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, H46, IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, H47, IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, H48, IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, H49, IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, H50, IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, H51, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, H2 + 1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), H2, IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, L2 - 1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 1 / 0))

No worries Bruce 

But the nesting idea TO CONNECT DOTS that u mentioned can it be used specifically to connect the above formulas in sequence like this link http://www.dhirenshah.com/abcd/

I m trying to get permutation and combination where HH AND LL will remain at end points whether it is HH  to LL OR  LL to HH  but in between I need HL and LH thats where the line plot idea should connect central bar dot points and i should be able to scan or sort once atleast three dot lines forming triangle are confirmed 

Another example going reverse from LL TO HH http://www.dhirenshah.com/abcd-bearish/

So what do u think its possible ?

Dhiren

I think you may misunderstand how the nesting thing works. It doesn't specifically connect HH only to LL or LL only HH. It has no way of telling what the previous dot was. With the current state of the PCF Language, that still results in a formula which is too long and slow to be practical or post in the forums.

All it does it put dots at either HH or LL. So you can have two HH or two LL in a row. It is effectively ORing the two formulas but in a way that the ultimate result is 1 / 0 if neiher is detected so you can "connect the dots" using a line plot.

So the nesting isn't going to create the sort of sitpation where we can LL, LH, HL, and HH only in that exact order. If you do nesting to include all four options, then it will display the dots at any one of those points. And if that is the case, you may as well not try checking to see if a low or high is higher or lower than the previous low or high, since you will be connect any place where a high or low is detected.

IIF(MAXH2 < H2 AND H2 > MAXH2.3, H2, IIF(MINL2 > L2 AND L2 < MINL2.3, L2, 1 / 0))

Bruce i got what u saying due to the limitation of pcf language and tc being a closed source but i think we getting closer to what i want to overlay , here i have attached link for same  chart one from TC and another is from Trading view showing on daily price bars between march 2017 and current date....

So your IIF(MAXH2 < H2 AND H2 > MAXH2.3, H2, IIF(MINL2 > L2 AND L2 < MINL2.3, L2, 1 / 0)) formula when i overlay on scale and same pane it hits the points loosely but not like what trading view chart is doing ....

"may be if u include in the formula that line can deviate above the previously plotted high or low for indicator to re-change its highs and lows by 3% will that plot correctly ? and is there anyway around to get line plotting onto central bar 

also for keeping DEPTH : 2(that is minimum number of price bars required where there is no secondary high or low ) so the line will not plot if the dots are too close to each other

http://www.dhirenshah.com/googl-tc2k-test/

http://www.dhirenshah.com/googl-trading-view-test/

There is no workaround currently to get the dot to plot on the central bar.

IIF(TrueInRow(NOT((MAXH2.1 < H3 AND H3 > MAXH2.4) OR (MINL2.1 > L3 AND L3 < MINL2.4)), 2) = 2, IIF(MAXH2 < H2 AND H2 > MAXH2.3, H2, IIF(MINL2 > L2 AND L2 < MINL2.3, L2, 1 / 0)), 1 / 0)

The , 2) = 2 section can be changed to require at least x bars between dots.

Requiring x% between one dot and the previous dot or between one high dot and the previous high dot or one low dot and the previous low dot is not practical.

You might be able to check for a percentage between the current potential dot and a previous potential dot, but the fomula would have no way of knowing if the previous potential dot was plotted or not.

In addition, the these formulas would be quite long even when just comparing potential dots and need to re-written if you decided to include the section requiring x number of bars between dots and changed , 2) = 2 to something else.

Okay Bruce i think i can work around the things that you did so far thank you very VERY much 

I have one non-related query need a pcf for attached link http://www.dhirenshah.com/bbtop/

I m eyeball and use this technique for Bollinger bands settings as 20 and std dev as 0.382 so i want pcf spike when price crosses above the pivot high of previous 5 bars starting with first bar that closed above the BBTOP i

another example of same idea http://www.dhirenshah.com/bbtop-example-2/

Also can u please do pcf for inverse same idea where price crosses BBBOTTOM 20 STD DEV 0.382 

Thanks a lot 

Dhiren 

So something like this?

H > IIF(MAXH2.1 < H3 AND H3 > MAXH2.4, IIF(MAXH2.1 < H3 AND TrueInRow(C > BBTOP(.382, 20), 4) = 4, H3, H + 1), IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(MAXH3.1 < H4 AND TrueInRow(C > BBTOP(.382, 20), 5) = 5, H4, H + 1), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXH4.1 < H5 AND TrueInRow(C > BBTOP(.382, 20), 6) = 6, H5, H + 1), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXH5.1 < H6 AND TrueInRow(C > BBTOP(.382, 20), 7) = 7, H6, H + 1), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXH6.1 < H7 AND TrueInRow(C > BBTOP(.382, 20), 8) = 8, H7, H + 1), H + 1)))))

Bruce the formula works perfect but can you please tweak the pivot part using 3 bar fractal where i need for this idea as HIGH -HIGHER HIGH AND LOWER HIGH as i see many signals getting missed  

my criteria is 5 consecutive bars must close on or above BBTOP band 

example http://www.dhirenshah.com/3-bar-fractal-bbtop/

And can u please do formula for inverse where 5 consecutive bars must close below BBbottomband and has 3 bar fractal     LOW - LOWERLOW AND HIGHER LOW 

thanks

Oh and i m only interested in set-ups of 5 consecutive bars that happen crossing #1 bar above or below  BB bands so if in the custom indicator we can pls restrict that somehow  to show spike only if that happens  that will be great as i don;t want to see spikes when price set-up is not coming out of BB bands or is happening far away from the bands

thanks

So the signal is always going to be exactly six bars after closing prices crossed up through the top Bollinger Band?

And you only need 1 high on each side lower than the central high instead of 2?

H > MAXH5.1 AND CountTrue(H1 < H2 AND H2 > H1, 4) > 0 AND TrueInRow(C > BBTOP(.382, 20), 7) = 6

The inverse of this would be the following.

L < MINL5.1 AND CountTrue(L1 > L2 AND L2 < L1, 4) > 0 AND TrueInRow(C < BBBOT(.382, 20), 7) = 6

Bruce we almost there u got 90% of it... but from the new formula u did it didn't pick up "LB " ticker that i sent u example of on 78 min chart so why it did not ? And yes I only need 1 high on each side lower than the central high instead of 2

Here i m attaching another example of TSLA 130 min chart http://www.dhirenshah.com/tsla-on-130-min-bbtop-idea/

Those blue dots are Fractal 3 bars using this formula H1 * ABS(H < H1 AND H1 > H2) 

and pink dots are 3 bar low fractal using this formula L1 * ABS(L > L1 AND L1 < L2) 

and offsetting with -1 so i get central high and low 

Thanks 

Because not exactly six bars.

Is there a limit as to how many bars after price crosses up through the top Bollinger Band the fractal happens?

Is there a limit as to how many bars after the fractal the high above the fractal happens (other than being canceled by closing below the top band)?

Is there a limit as to how far above the the Top Bollinger Band the fractal and/or spike can be, in for example multiples or SD?

Bruce my replies are in BLUE

Because not exactly six bars.

Is there a limit as to how many bars after price crosses up through the top Bollinger Band the fractal happens? no bruce there is no limit of bars for the 3 bar fractal to happen after it crosses BBtop 

Is there a limit as to how many bars after the fractal the high above the fractal happens (other than being canceled by closing below the top band)? No there is no limit main criteria is that ""there should be 5 consecutive closes above the BBtop " in order for the pattern to be valid if the low of the bar goes into the band but close remains above the band it is still valid "

Is there a limit as to how far above the the Top Bollinger Band the fractal and/or spike can be, in for example multiples or SD? No there is no limit it can take 10-15 bars also after it crossed the BBTOP to make a 3 bar fractal its still valid

Here is another example for your queries http://www.dhirenshah.com/bbtop-illustration/

How do you reconcile these answers with your previous comment. To me, these posts are mutually exclusive

You may be able to imagine some scenario where both answers are simultaneously true. I certainly cannot without some additional clarification as to how this can be the case.

At this point I really don't know what you actually want.

Oh and i m only interested in set-ups of 5 consecutive bars that happen crossing #1 bar what i meant is crossing  BBTOP

Bruce why don;t we do this Lets make its simple like this criterias

1) Price crosses BBTOP that is bar #1  now if consecutively the following bars remain closed above BBTOP then that will become #2,3,4 and 5   

2) If those 5 bars had a 3 bar fractal or it took more bars like bar #6,7,8, 9,10,11,12  to make a 3 bar fractal then so be it but as long as that 3 bar fractal forms and close is above BBTOP count is valid , 

3) Once fractal is formed the signal bar crossing high of the fractal bar of past has to happen without the count entering into the bands

the first formula that u did  Monday, December 11, 2017 4:00:22 PM does all of it but pls change that to 3 bar my formula fractal and don;t worry about restriction part i will eyeball the set-ups 

thanks a lot 

Please try the following condition formula for above the Bollinger Bands.

H > IIF(TrueInRow(C > BBTOP(.382, 20), 7) = 6, IIF(CountTrue(H1 < H2 AND H2 > H3, 4) > 0, MAXH5.1, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 8) = 7, IIF(CountTrue(H1 < H2 AND H2 > H3, 5) > 0 AND MAXH5.2 >= H1, MAXH5.2, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 9) = 8, IIF(CountTrue(H2 < H3 AND H3 > H4, 5) > 0 AND MAXH5.3 >= MAXH2.1, MAXH5.3, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 10) = 9, IIF(CountTrue(H3 < H4 AND H4 > H5, 5) > 0 AND MAXH5.4 >= MAXH3.1, MAXH5.4, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 11) = 10, IIF(CountTrue(H4 < H5 AND H5 > H6, 5) > 0 AND MAXH5.5 >= MAXH4.1, MAXH5.5, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 12) = 11, IIF(CountTrue(H5 < H6 AND H6 > H7, 5) > 0 AND MAXH5.6 >= MAXH5.1, MAXH5.6, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 13) = 12, IIF(CountTrue(H6 < H7 AND H7 > H8, 5) > 0 AND MAXH5.7 >= MAXH6.1, MAXH5.7, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 14) = 13, IIF(CountTrue(H7 < H8 AND H8 > H9, 5) > 0 AND MAXH5.8 >= MAXH7.1, MAXH5.8, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 15) = 14, IIF(CountTrue(H8 < H9 AND H9 > H10, 5) > 0 AND MAXH5.9 >= MAXH8.1, MAXH5.9, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 16) = 15, IIF(CountTrue(H9 < H10 AND H10 > H11, 5) > 0 AND MAXH5.10 >= MAXH9.1, MAXH5.10, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 17) = 16, IIF(CountTrue(H10 < H11 AND H11 > H12, 5) > 0 AND MAXH5.11 >= MAXH10.1, MAXH5.11, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 18) = 17, IIF(CountTrue(H11 < H12 AND H12 > H13, 5) > 0 AND MAXH5.12 >= MAXH11.1, MAXH5.12, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 19) = 18, IIF(CountTrue(H12 < H13 AND H13 > H14, 5) > 0 AND MAXH5.13 >= MAXH12.1, MAXH5.13, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 20) = 19, IIF(CountTrue(H13 < H14 AND H14 > H15, 5) > 0 AND MAXH5.14 >= MAXH13.1, MAXH5.14, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 21) = 20, IIF(CountTrue(H14 < H15 AND H15 > H16, 5) > 0 AND MAXH5.15 >= MAXH14.1, MAXH5.15, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 22) = 21, IIF(CountTrue(H15 < H16 AND H16 > H17, 5) > 0 AND MAXH5.16 >= MAXH15.1, MAXH5.16, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 23) = 22, IIF(CountTrue(H16 < H17 AND H17 > H18, 5) > 0 AND MAXH5.17 >= MAXH16.1, MAXH5.17, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 24) = 23, IIF(CountTrue(H17 < H18 AND H18 > H19, 5) > 0 AND MAXH5.18 >= MAXH17.1, MAXH5.18, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 25) = 24, IIF(CountTrue(H18 < H19 AND H19 > H20, 5) > 0 AND MAXH5.19 >= MAXH18.1, MAXH5.19, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 26) = 25, IIF(CountTrue(H19 < H20 AND H20 > H21, 5) > 0 AND MAXH5.20 >= MAXH19.1, MAXH5.20, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 27) = 26, IIF(CountTrue(H20 < H21 AND H21 > H22, 5) > 0 AND MAXH5.21 >= MAXH20.1, MAXH5.21, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 28) = 27, IIF(CountTrue(H21 < H22 AND H22 > H23, 5) > 0 AND MAXH5.22 >= MAXH21.1, MAXH5.22, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 29) = 28, IIF(CountTrue(H22 < H23 AND H23 > H24, 5) > 0 AND MAXH5.23 >= MAXH22.1, MAXH5.23, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 30) = 29, IIF(CountTrue(H23 < H24 AND H24 > H25, 5) > 0 AND MAXH5.24 >= MAXH23.1, MAXH5.24, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 31) = 30, IIF(CountTrue(H24 < H25 AND H25 > H26, 5) > 0 AND MAXH5.25 >= MAXH24.1, MAXH5.25, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 32) = 31, IIF(CountTrue(H25 < H26 AND H26 > H27, 5) > 0 AND MAXH5.26 >= MAXH25.1, MAXH5.26, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 33) = 32, IIF(CountTrue(H26 < H27 AND H27 > H28, 5) > 0 AND MAXH5.27 >= MAXH26.1, MAXH5.27, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 34) = 33, IIF(CountTrue(H27 < H28 AND H28 > H29, 5) > 0 AND MAXH5.28 >= MAXH27.1, MAXH5.28, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 35) = 34, IIF(CountTrue(H28 < H29 AND H29 > H30, 5) > 0 AND MAXH5.29 >= MAXH28.1, MAXH5.29, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 36) = 35, IIF(CountTrue(H29 < H30 AND H30 > H31, 5) > 0 AND MAXH5.30 >= MAXH29.1, MAXH5.30, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 37) = 36, IIF(CountTrue(H30 < H31 AND H31 > H32, 5) > 0 AND MAXH5.31 >= MAXH30.1, MAXH5.31, H + 1), IIF(TrueInRow(C > BBTOP(.382, 20), 38) = 37, IIF(CountTrue(H31 < H32 AND H32 > H33, 5) > 0 AND MAXH5.32 >= MAXH31.1, MAXH5.32, H + 1), H + 1))))))))))))))))))))))))))))))))

And the following for below the Bollinger Bands.

L < IIF(TrueInRow(C < BBBOT(.382, 20), 7) = 6, IIF(CountTrue(L1 > L2 AND L2 < L3, 4) > 0, MINL5.1, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 8) = 7, IIF(CountTrue(L1 > L2 AND L2 < L3, 5) > 0 AND MINL5.2 <= L1, MINL5.2, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 9) = 8, IIF(CountTrue(L2 > L3 AND L3 < L4, 5) > 0 AND MINL5.3 <= MINL2.1, MINL5.3, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 10) = 9, IIF(CountTrue(L3 > L4 AND L4 < L5, 5) > 0 AND MINL5.4 <= MINL3.1, MINL5.4, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 11) = 10, IIF(CountTrue(L4 > L5 AND L5 < L6, 5) > 0 AND MINL5.5 <= MINL4.1, MINL5.5, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 12) = 11, IIF(CountTrue(L5 > L6 AND L6 < L7, 5) > 0 AND MINL5.6 <= MINL5.1, MINL5.6, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 13) = 12, IIF(CountTrue(L6 > L7 AND L7 < L8, 5) > 0 AND MINL5.7 <= MINL6.1, MINL5.7, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 14) = 13, IIF(CountTrue(L7 > L8 AND L8 < L9, 5) > 0 AND MINL5.8 <= MINL7.1, MINL5.8, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 15) = 14, IIF(CountTrue(L8 > L9 AND L9 < L10, 5) > 0 AND MINL5.9 <= MINL8.1, MINL5.9, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 16) = 15, IIF(CountTrue(L9 > L10 AND L10 < L11, 5) > 0 AND MINL5.10 <= MINL9.1, MINL5.10, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 17) = 16, IIF(CountTrue(L10 > L11 AND L11 < L12, 5) > 0 AND MINL5.11 <= MINL10.1, MINL5.11, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 18) = 17, IIF(CountTrue(L11 > L12 AND L12 < L13, 5) > 0 AND MINL5.12 <= MINL11.1, MINL5.12, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 19) = 18, IIF(CountTrue(L12 > L13 AND L13 < L14, 5) > 0 AND MINL5.13 <= MINL12.1, MINL5.13, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 20) = 19, IIF(CountTrue(L13 > L14 AND L14 < L15, 5) > 0 AND MINL5.14 <= MINL13.1, MINL5.14, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 21) = 20, IIF(CountTrue(L14 > L15 AND L15 < L16, 5) > 0 AND MINL5.15 <= MINL14.1, MINL5.15, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 22) = 21, IIF(CountTrue(L15 > L16 AND L16 < L17, 5) > 0 AND MINL5.16 <= MINL15.1, MINL5.16, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 23) = 22, IIF(CountTrue(L16 > L17 AND L17 < L18, 5) > 0 AND MINL5.17 <= MINL16.1, MINL5.17, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 24) = 23, IIF(CountTrue(L17 > L18 AND L18 < L19, 5) > 0 AND MINL5.18 <= MINL17.1, MINL5.18, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 25) = 24, IIF(CountTrue(L18 > L19 AND L19 < L20, 5) > 0 AND MINL5.19 <= MINL18.1, MINL5.19, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 26) = 25, IIF(CountTrue(L19 > L20 AND L20 < L21, 5) > 0 AND MINL5.20 <= MINL19.1, MINL5.20, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 27) = 26, IIF(CountTrue(L20 > L21 AND L21 < L22, 5) > 0 AND MINL5.21 <= MINL20.1, MINL5.21, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 28) = 27, IIF(CountTrue(L21 > L22 AND L22 < L23, 5) > 0 AND MINL5.22 <= MINL21.1, MINL5.22, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 29) = 28, IIF(CountTrue(L22 > L23 AND L23 < L24, 5) > 0 AND MINL5.23 <= MINL22.1, MINL5.23, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 30) = 29, IIF(CountTrue(L23 > L24 AND L24 < L25, 5) > 0 AND MINL5.24 <= MINL23.1, MINL5.24, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 31) = 30, IIF(CountTrue(L24 > L25 AND L25 < L26, 5) > 0 AND MINL5.25 <= MINL24.1, MINL5.25, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 32) = 31, IIF(CountTrue(L25 > L26 AND L26 < L27, 5) > 0 AND MINL5.26 <= MINL25.1, MINL5.26, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 33) = 32, IIF(CountTrue(L26 > L27 AND L27 < L28, 5) > 0 AND MINL5.27 <= MINL26.1, MINL5.27, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 34) = 33, IIF(CountTrue(L27 > L28 AND L28 < L29, 5) > 0 AND MINL5.28 <= MINL27.1, MINL5.28, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 35) = 34, IIF(CountTrue(L28 > L29 AND L29 < L30, 5) > 0 AND MINL5.29 <= MINL28.1, MINL5.29, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 36) = 35, IIF(CountTrue(L29 > L30 AND L30 < L31, 5) > 0 AND MINL5.30 <= MINL29.1, MINL5.30, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 37) = 36, IIF(CountTrue(L30 > L31 AND L31 < L32, 5) > 0 AND MINL5.31 <= MINL30.1, MINL5.31, L - 1), IIF(TrueInRow(C < BBBOT(.382, 20), 38) = 37, IIF(CountTrue(L31 > L32 AND L32 < L33, 5) > 0 AND MINL5.32 <= MINL31.1, MINL5.32, L - 1), L - 1))))))))))))))))))))))))))))))))

Bruce Yes that is beyond perfect, thank you so much ..... you don't realize but you are  best at what u do...I coin you today again as " Bruce Almighty "  i never seen you give up on anything and its commendable  Hats off :) Sir

And one last question if i may then i m gone  ... i was searching the forum but could not get good answer for BOLLINGER BANDS using my setting of 20 and 0.382 deviation what i m interested looking for is the bands to colour change when value of BBTOP or BBBottom increases from previous to the next and colour change when value decreases from previous to the next ,,,, now in my understanding TC is not designed to do that yet,,, so 

1) Can we get pcf in form of dots that can be laid in one row like the squeeze but here the idea is to show colour change of dot if the actual value of current  BBTOPband is > previous BBTOP band   then show GREEN  if current bbtop is < previous BBtop then show red 

2) same for BBBottom if current BBbottom  > then previous BBbottom then show green and if current BBbottom < then previous BBbottom then show red 

so you will give me two seperate rows of dots one for BBTOP and then BBBottom 

Thankyou again for everything 

For the top Bollinger Band, you could use the following two formulas plotted in the same pane and scale as price and the Bollinger Bands.

IIF(BBTOP(.382, 20) > BBTOP(.382, 20, 1), BBTOP(.382, 20), 1 / 0)

IIF(BBTOP(.382, 20) < BBTOP(.382, 20, 1), BBTOP(.382, 20), 1 / 0)

For the bottom Bollinger Band, you could use the following two formulas plotted in the same pane and scale as price and the Bollinger Bands.

IIF(BBBOT(.382, 20) > BBBOT(.382, 20, 1), BBBOT(.382, 20), 1 / 0)

IIF(BBBOT(.382, 20) < BBBOT(.382, 20, 1), BBBOT(.382, 20), 1 / 0)

For the Bollinger Band centerline, you could use the following two formulas plotted in the same pane and scale as price and the Bollinger Bands.

IIF(AVGC20 > AVGC20.1, AVGC20, 1 / 0)

IIF(AVGC20 < AVGC20.1, AVGC20, 1 / 0)

You can replace the second to last argument in the formula (the one before 1 / 0) with a number if you just want to plot a line of dots at a fixed value not in the same scale as price.

Excellent Bruce you dumb it down so easy that it is fantastic ... 

Happy Holidays Brother ! talk to you in the new year and TC mail me your address I will add you to my christmas List ! 

cheers

Dhiren

You're welcome. Happy Holiidays!