Registered User Joined: 3/10/2012 Posts: 465
|
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
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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 Personal Criteria Formulas TC2000 Support Articles
|