Hi Bruce,
I tried the following on TC2000 but got errors, mis-alignment and never got it right. Can you please TC Mail me a chart with the following indicator PCF's please?
Request1:
HH GREEN , LH PURPLE , HL BROWN & LL RED thats what i wish to overlay on RSI
Higher High:
IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 > IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10 )
Lower High:
IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)
Higher Low:
IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 > IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)
Lower Low:
IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)
Request2:
If there is a lower high it adds 1 to the value and if there is a lower low, it adds -1 to the value.
IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)
Request3: template
The template is pretty straightforward.
IIF(Boolean formula here, 1, 0) + IIF(Boolean formula here, -1, 0)
Really a better option is to modify those formulas and then put a + in between them.
Replace the WRSI14.2, -10) at the end with either 1, 0) or -1, 0) depending on if it is the formula you want to use to add 1 or the formula you want to use to add -1.
Request4: stochastic using the settings as period 5 %k 2 and %D 3 averages simple
Higher High:
IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)
Lower High:
IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)
Higher Low:
IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)
Lower Low:
IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)
Request5:
1) If current WRSI14 is crossing up HH or LH from past then show me spike one colour
2) If current WRSI14 is crossing down HL or LL from past then show me spike as second colour
Please try the following for crossing up the most recent high.
XUP(WRSI14, IIF(WRSI14.3 > GREATEST(MAX(WRSI14.1, 2), MAX(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 > GREATEST(MAX(WRSI14.2, 2), MAX(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 > GREATEST(MAX(WRSI14.3, 2), MAX(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 > GREATEST(MAX(WRSI14.4, 2), MAX(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 > GREATEST(MAX(WRSI14.5, 2), MAX(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 > GREATEST(MAX(WRSI14.6, 2), MAX(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 > GREATEST(MAX(WRSI14.7, 2), MAX(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 > GREATEST(MAX(WRSI14.8, 2), MAX(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 > GREATEST(MAX(WRSI14.9, 2), MAX(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 > GREATEST(MAX(WRSI14.10, 2), MAX(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 > GREATEST(MAX(WRSI14.11, 2), MAX(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 > GREATEST(MAX(WRSI14.12, 2), MAX(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 > GREATEST(MAX(WRSI14.13, 2), MAX(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 > GREATEST(MAX(WRSI14.14, 2), MAX(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 > GREATEST(MAX(WRSI14.15, 2), MAX(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 > GREATEST(MAX(WRSI14.16, 2), MAX(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 > GREATEST(MAX(WRSI14.17, 2), MAX(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 > GREATEST(MAX(WRSI14.18, 2), MAX(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 > GREATEST(MAX(WRSI14.19, 2), MAX(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 > GREATEST(MAX(WRSI14.20, 2), MAX(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 > GREATEST(MAX(WRSI14.21, 2), MAX(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 > GREATEST(MAX(WRSI14.22, 2), MAX(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 > GREATEST(MAX(WRSI14.23, 2), MAX(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 > GREATEST(MAX(WRSI14.24, 2), MAX(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 > GREATEST(MAX(WRSI14.25, 2), MAX(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 > GREATEST(MAX(WRSI14.26, 2), MAX(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 > GREATEST(MAX(WRSI14.27, 2), MAX(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 > GREATEST(MAX(WRSI14.28, 2), MAX(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 > GREATEST(MAX(WRSI14.29, 2), MAX(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 > GREATEST(MAX(WRSI14.30, 2), MAX(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 > GREATEST(MAX(WRSI14.31, 2), MAX(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 > GREATEST(MAX(WRSI14.32, 2), MAX(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 > GREATEST(MAX(WRSI14.33, 2), MAX(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 > GREATEST(MAX(WRSI14.34, 2), MAX(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 > GREATEST(MAX(WRSI14.35, 2), MAX(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 > GREATEST(MAX(WRSI14.36, 2), MAX(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 > GREATEST(MAX(WRSI14.37, 2), MAX(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 > GREATEST(MAX(WRSI14.38, 2), MAX(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 > GREATEST(MAX(WRSI14.39, 2), MAX(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 > GREATEST(MAX(WRSI14.40, 2), MAX(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 > GREATEST(MAX(WRSI14.41, 2), MAX(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 > GREATEST(MAX(WRSI14.42, 2), MAX(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 > GREATEST(MAX(WRSI14.43, 2), MAX(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 > GREATEST(MAX(WRSI14.44, 2), MAX(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 > GREATEST(MAX(WRSI14.45, 2), MAX(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 > GREATEST(MAX(WRSI14.46, 2), MAX(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 > GREATEST(MAX(WRSI14.47, 2), MAX(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 > GREATEST(MAX(WRSI14.48, 2), MAX(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 > GREATEST(MAX(WRSI14.49, 2), MAX(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 > GREATEST(MAX(WRSI14.50, 2), MAX(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 > GREATEST(MAX(WRSI14.51, 2), MAX(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 > GREATEST(MAX(WRSI14.52, 2), MAX(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 > GREATEST(MAX(WRSI14.53, 2), MAX(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 > GREATEST(MAX(WRSI14.54, 2), MAX(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 > GREATEST(MAX(WRSI14.55, 2), MAX(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 > GREATEST(MAX(WRSI14.56, 2), MAX(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 > GREATEST(MAX(WRSI14.57, 2), MAX(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 > GREATEST(MAX(WRSI14.58, 2), MAX(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 > GREATEST(MAX(WRSI14.59, 2), MAX(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 > GREATEST(MAX(WRSI14.60, 2), MAX(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 > GREATEST(MAX(WRSI14.61, 2), MAX(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 > GREATEST(MAX(WRSI14.62, 2), MAX(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 > GREATEST(MAX(WRSI14.63, 2), MAX(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 > GREATEST(MAX(WRSI14.64, 2), MAX(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 > GREATEST(MAX(WRSI14.65, 2), MAX(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
And the following for crossing down the most recent low.
XDOWN(WRSI14, IIF(WRSI14.3 < LEAST(MIN(WRSI14.1, 2), MIN(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 < LEAST(MIN(WRSI14.2, 2), MIN(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 < LEAST(MIN(WRSI14.3, 2), MIN(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 < LEAST(MIN(WRSI14.4, 2), MIN(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 < LEAST(MIN(WRSI14.5, 2), MIN(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 < LEAST(MIN(WRSI14.6, 2), MIN(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 < LEAST(MIN(WRSI14.7, 2), MIN(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 < LEAST(MIN(WRSI14.8, 2), MIN(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 < LEAST(MIN(WRSI14.9, 2), MIN(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 < LEAST(MIN(WRSI14.10, 2), MIN(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 < LEAST(MIN(WRSI14.11, 2), MIN(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 < LEAST(MIN(WRSI14.12, 2), MIN(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 < LEAST(MIN(WRSI14.13, 2), MIN(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 < LEAST(MIN(WRSI14.14, 2), MIN(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 < LEAST(MIN(WRSI14.15, 2), MIN(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 < LEAST(MIN(WRSI14.16, 2), MIN(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 < LEAST(MIN(WRSI14.17, 2), MIN(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 < LEAST(MIN(WRSI14.18, 2), MIN(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 < LEAST(MIN(WRSI14.19, 2), MIN(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 < LEAST(MIN(WRSI14.20, 2), MIN(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 < LEAST(MIN(WRSI14.21, 2), MIN(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 < LEAST(MIN(WRSI14.22, 2), MIN(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 < LEAST(MIN(WRSI14.23, 2), MIN(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 < LEAST(MIN(WRSI14.24, 2), MIN(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 < LEAST(MIN(WRSI14.25, 2), MIN(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 < LEAST(MIN(WRSI14.26, 2), MIN(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 < LEAST(MIN(WRSI14.27, 2), MIN(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 < LEAST(MIN(WRSI14.28, 2), MIN(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 < LEAST(MIN(WRSI14.29, 2), MIN(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 < LEAST(MIN(WRSI14.30, 2), MIN(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 < LEAST(MIN(WRSI14.31, 2), MIN(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 < LEAST(MIN(WRSI14.32, 2), MIN(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 < LEAST(MIN(WRSI14.33, 2), MIN(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 < LEAST(MIN(WRSI14.34, 2), MIN(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 < LEAST(MIN(WRSI14.35, 2), MIN(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 < LEAST(MIN(WRSI14.36, 2), MIN(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 < LEAST(MIN(WRSI14.37, 2), MIN(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 < LEAST(MIN(WRSI14.38, 2), MIN(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 < LEAST(MIN(WRSI14.39, 2), MIN(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 < LEAST(MIN(WRSI14.40, 2), MIN(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 < LEAST(MIN(WRSI14.41, 2), MIN(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 < LEAST(MIN(WRSI14.42, 2), MIN(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 < LEAST(MIN(WRSI14.43, 2), MIN(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 < LEAST(MIN(WRSI14.44, 2), MIN(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 < LEAST(MIN(WRSI14.45, 2), MIN(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 < LEAST(MIN(WRSI14.46, 2), MIN(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 < LEAST(MIN(WRSI14.47, 2), MIN(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 < LEAST(MIN(WRSI14.48, 2), MIN(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 < LEAST(MIN(WRSI14.49, 2), MIN(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 < LEAST(MIN(WRSI14.50, 2), MIN(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 < LEAST(MIN(WRSI14.51, 2), MIN(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 < LEAST(MIN(WRSI14.52, 2), MIN(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 < LEAST(MIN(WRSI14.53, 2), MIN(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 < LEAST(MIN(WRSI14.54, 2), MIN(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 < LEAST(MIN(WRSI14.55, 2), MIN(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 < LEAST(MIN(WRSI14.56, 2), MIN(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 < LEAST(MIN(WRSI14.57, 2), MIN(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 < LEAST(MIN(WRSI14.58, 2), MIN(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 < LEAST(MIN(WRSI14.59, 2), MIN(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 < LEAST(MIN(WRSI14.60, 2), MIN(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 < LEAST(MIN(WRSI14.61, 2), MIN(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 < LEAST(MIN(WRSI14.62, 2), MIN(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 < LEAST(MIN(WRSI14.63, 2), MIN(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 < LEAST(MIN(WRSI14.64, 2), MIN(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 < LEAST(MIN(WRSI14.65, 2), MIN(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Request6:
1) If current WRSI14 is crossing UP HL or LL from past then show me spike one colour
2) If current WRSI14 is crossing DOWN HH or LH from past then show me spike as second colour
I'm not in a rush and I will let you do whenever your time permits.
Note: I'm new and only started learning since last two months. I appreciate all the requests people post on the forums and I'm learning a lot from them.
|