Registered User Joined: 3/10/2012 Posts: 465
|
Bruce I had asked stochastic in past and u did this for me at the time as below and it works as charm so just to save you time ,
HIGHER HIGH
IIF(MAX(STOC5.2, 2) < STOC5.2.2 AND STOC5.2.2 > MAX(STOC5.2.3, 2) AND STOC5.2.2 > IIF(MAX(STOC5.2.3, 2) < STOC5.2.5 AND STOC5.2.5 > MAX(STOC5.2.6, 2), STOC5.2.5, IIF(MAX(STOC5.2.4, 2) < STOC5.2.6 AND STOC5.2.6 > MAX(STOC5.2.7, 2), STOC5.2.6, IIF(MAX(STOC5.2.5, 2) < STOC5.2.7 AND STOC5.2.7 > MAX(STOC5.2.8, 2), STOC5.2.7, IIF(MAX(STOC5.2.6, 2) < STOC5.2.8 AND STOC5.2.8 > MAX(STOC5.2.9, 2), STOC5.2.8, IIF(MAX(STOC5.2.7, 2) < STOC5.2.9 AND STOC5.2.9 > MAX(STOC5.2.10, 2), STOC5.2.9, IIF(MAX(STOC5.2.8, 2) < STOC5.2.10 AND STOC5.2.10 > MAX(STOC5.2.11, 2), STOC5.2.10, IIF(MAX(STOC5.2.9, 2) < STOC5.2.11 AND STOC5.2.11 > MAX(STOC5.2.12, 2), STOC5.2.11, IIF(MAX(STOC5.2.10, 2) < STOC5.2.12 AND STOC5.2.12 > MAX(STOC5.2.13, 2), STOC5.2.12, IIF(MAX(STOC5.2.11, 2) < STOC5.2.13 AND STOC5.2.13 > MAX(STOC5.2.14, 2), STOC5.2.13, IIF(MAX(STOC5.2.12, 2) < STOC5.2.14 AND STOC5.2.14 > MAX(STOC5.2.15, 2), STOC5.2.14, IIF(MAX(STOC5.2.13, 2) < STOC5.2.15 AND STOC5.2.15 > MAX(STOC5.2.16, 2), STOC5.2.15, IIF(MAX(STOC5.2.14, 2) < STOC5.2.16 AND STOC5.2.16 > MAX(STOC5.2.17, 2), STOC5.2.16, IIF(MAX(STOC5.2.15, 2) < STOC5.2.17 AND STOC5.2.17 > MAX(STOC5.2.18, 2), STOC5.2.17, IIF(MAX(STOC5.2.16, 2) < STOC5.2.18 AND STOC5.2.18 > MAX(STOC5.2.19, 2), STOC5.2.18, IIF(MAX(STOC5.2.17, 2) < STOC5.2.19 AND STOC5.2.19 > MAX(STOC5.2.20, 2), STOC5.2.19, IIF(MAX(STOC5.2.18, 2) < STOC5.2.20 AND STOC5.2.20 > MAX(STOC5.2.21, 2), STOC5.2.20, IIF(MAX(STOC5.2.19, 2) < STOC5.2.21 AND STOC5.2.21 > MAX(STOC5.2.22, 2), STOC5.2.21, IIF(MAX(STOC5.2.20, 2) < STOC5.2.22 AND STOC5.2.22 > MAX(STOC5.2.23, 2), STOC5.2.22, IIF(MAX(STOC5.2.21, 2) < STOC5.2.23 AND STOC5.2.23 > MAX(STOC5.2.24, 2), STOC5.2.23, IIF(MAX(STOC5.2.22, 2) < STOC5.2.24 AND STOC5.2.24 > MAX(STOC5.2.25, 2), STOC5.2.24, IIF(MAX(STOC5.2.23, 2) < STOC5.2.25 AND STOC5.2.25 > MAX(STOC5.2.26, 2), STOC5.2.25, IIF(MAX(STOC5.2.24, 2) < STOC5.2.26 AND STOC5.2.26 > MAX(STOC5.2.27, 2), STOC5.2.26, IIF(MAX(STOC5.2.25, 2) < STOC5.2.27 AND STOC5.2.27 > MAX(STOC5.2.28, 2), STOC5.2.27, IIF(MAX(STOC5.2.26, 2) < STOC5.2.28 AND STOC5.2.28 > MAX(STOC5.2.29, 2), STOC5.2.28, IIF(MAX(STOC5.2.27, 2) < STOC5.2.29 AND STOC5.2.29 > MAX(STOC5.2.30, 2), STOC5.2.29, IIF(MAX(STOC5.2.28, 2) < STOC5.2.30 AND STOC5.2.30 > MAX(STOC5.2.31, 2), STOC5.2.30, IIF(MAX(STOC5.2.29, 2) < STOC5.2.31 AND STOC5.2.31 > MAX(STOC5.2.32, 2), STOC5.2.31, IIF(MAX(STOC5.2.30, 2) < STOC5.2.32 AND STOC5.2.32 > MAX(STOC5.2.33, 2), STOC5.2.32, IIF(MAX(STOC5.2.31, 2) < STOC5.2.33 AND STOC5.2.33 > MAX(STOC5.2.34, 2), STOC5.2.33, IIF(MAX(STOC5.2.32, 2) < STOC5.2.34 AND STOC5.2.34 > MAX(STOC5.2.35, 2), STOC5.2.34, IIF(MAX(STOC5.2.33, 2) < STOC5.2.35 AND STOC5.2.35 > MAX(STOC5.2.36, 2), STOC5.2.35, 101))))))))))))))))))))))))))))))), STOC5.2.2, -10)
LOWER HIGH
IIF(MAX(STOC5.2, 2) < STOC5.2.2 AND STOC5.2.2 > MAX(STOC5.2.3, 2) AND STOC5.2.2 < IIF(MAX(STOC5.2.3, 2) < STOC5.2.5 AND STOC5.2.5 > MAX(STOC5.2.6, 2), STOC5.2.5, IIF(MAX(STOC5.2.4, 2) < STOC5.2.6 AND STOC5.2.6 > MAX(STOC5.2.7, 2), STOC5.2.6, IIF(MAX(STOC5.2.5, 2) < STOC5.2.7 AND STOC5.2.7 > MAX(STOC5.2.8, 2), STOC5.2.7, IIF(MAX(STOC5.2.6, 2) < STOC5.2.8 AND STOC5.2.8 > MAX(STOC5.2.9, 2), STOC5.2.8, IIF(MAX(STOC5.2.7, 2) < STOC5.2.9 AND STOC5.2.9 > MAX(STOC5.2.10, 2), STOC5.2.9, IIF(MAX(STOC5.2.8, 2) < STOC5.2.10 AND STOC5.2.10 > MAX(STOC5.2.11, 2), STOC5.2.10, IIF(MAX(STOC5.2.9, 2) < STOC5.2.11 AND STOC5.2.11 > MAX(STOC5.2.12, 2), STOC5.2.11, IIF(MAX(STOC5.2.10, 2) < STOC5.2.12 AND STOC5.2.12 > MAX(STOC5.2.13, 2), STOC5.2.12, IIF(MAX(STOC5.2.11, 2) < STOC5.2.13 AND STOC5.2.13 > MAX(STOC5.2.14, 2), STOC5.2.13, IIF(MAX(STOC5.2.12, 2) < STOC5.2.14 AND STOC5.2.14 > MAX(STOC5.2.15, 2), STOC5.2.14, IIF(MAX(STOC5.2.13, 2) < STOC5.2.15 AND STOC5.2.15 > MAX(STOC5.2.16, 2), STOC5.2.15, IIF(MAX(STOC5.2.14, 2) < STOC5.2.16 AND STOC5.2.16 > MAX(STOC5.2.17, 2), STOC5.2.16, IIF(MAX(STOC5.2.15, 2) < STOC5.2.17 AND STOC5.2.17 > MAX(STOC5.2.18, 2), STOC5.2.17, IIF(MAX(STOC5.2.16, 2) < STOC5.2.18 AND STOC5.2.18 > MAX(STOC5.2.19, 2), STOC5.2.18, IIF(MAX(STOC5.2.17, 2) < STOC5.2.19 AND STOC5.2.19 > MAX(STOC5.2.20, 2), STOC5.2.19, IIF(MAX(STOC5.2.18, 2) < STOC5.2.20 AND STOC5.2.20 > MAX(STOC5.2.21, 2), STOC5.2.20, IIF(MAX(STOC5.2.19, 2) < STOC5.2.21 AND STOC5.2.21 > MAX(STOC5.2.22, 2), STOC5.2.21, IIF(MAX(STOC5.2.20, 2) < STOC5.2.22 AND STOC5.2.22 > MAX(STOC5.2.23, 2), STOC5.2.22, IIF(MAX(STOC5.2.21, 2) < STOC5.2.23 AND STOC5.2.23 > MAX(STOC5.2.24, 2), STOC5.2.23, IIF(MAX(STOC5.2.22, 2) < STOC5.2.24 AND STOC5.2.24 > MAX(STOC5.2.25, 2), STOC5.2.24, IIF(MAX(STOC5.2.23, 2) < STOC5.2.25 AND STOC5.2.25 > MAX(STOC5.2.26, 2), STOC5.2.25, IIF(MAX(STOC5.2.24, 2) < STOC5.2.26 AND STOC5.2.26 > MAX(STOC5.2.27, 2), STOC5.2.26, IIF(MAX(STOC5.2.25, 2) < STOC5.2.27 AND STOC5.2.27 > MAX(STOC5.2.28, 2), STOC5.2.27, IIF(MAX(STOC5.2.26, 2) < STOC5.2.28 AND STOC5.2.28 > MAX(STOC5.2.29, 2), STOC5.2.28, IIF(MAX(STOC5.2.27, 2) < STOC5.2.29 AND STOC5.2.29 > MAX(STOC5.2.30, 2), STOC5.2.29, IIF(MAX(STOC5.2.28, 2) < STOC5.2.30 AND STOC5.2.30 > MAX(STOC5.2.31, 2), STOC5.2.30, IIF(MAX(STOC5.2.29, 2) < STOC5.2.31 AND STOC5.2.31 > MAX(STOC5.2.32, 2), STOC5.2.31, IIF(MAX(STOC5.2.30, 2) < STOC5.2.32 AND STOC5.2.32 > MAX(STOC5.2.33, 2), STOC5.2.32, IIF(MAX(STOC5.2.31, 2) < STOC5.2.33 AND STOC5.2.33 > MAX(STOC5.2.34, 2), STOC5.2.33, IIF(MAX(STOC5.2.32, 2) < STOC5.2.34 AND STOC5.2.34 > MAX(STOC5.2.35, 2), STOC5.2.34, IIF(MAX(STOC5.2.33, 2) < STOC5.2.35 AND STOC5.2.35 > MAX(STOC5.2.36, 2), STOC5.2.35, -1))))))))))))))))))))))))))))))), STOC5.2.2, -10)
HIGHER LOW
IIF(MIN(STOC5.2, 2) > STOC5.2.2 AND STOC5.2.2 < MIN(STOC5.2.3, 2) AND STOC5.2.2 > IIF(MIN(STOC5.2.3, 2) > STOC5.2.5 AND STOC5.2.5 < MIN(STOC5.2.6, 2), STOC5.2.5, IIF(MIN(STOC5.2.4, 2) > STOC5.2.6 AND STOC5.2.6 < MIN(STOC5.2.7, 2), STOC5.2.6, IIF(MIN(STOC5.2.5, 2) > STOC5.2.7 AND STOC5.2.7 < MIN(STOC5.2.8, 2), STOC5.2.7, IIF(MIN(STOC5.2.6, 2) > STOC5.2.8 AND STOC5.2.8 < MIN(STOC5.2.9, 2), STOC5.2.8, IIF(MIN(STOC5.2.7, 2) > STOC5.2.9 AND STOC5.2.9 < MIN(STOC5.2.10, 2), STOC5.2.9, IIF(MIN(STOC5.2.8, 2) > STOC5.2.10 AND STOC5.2.10 < MIN(STOC5.2.11, 2), STOC5.2.10, IIF(MIN(STOC5.2.9, 2) > STOC5.2.11 AND STOC5.2.11 < MIN(STOC5.2.12, 2), STOC5.2.11, IIF(MIN(STOC5.2.10, 2) > STOC5.2.12 AND STOC5.2.12 < MIN(STOC5.2.13, 2), STOC5.2.12, IIF(MIN(STOC5.2.11, 2) > STOC5.2.13 AND STOC5.2.13 < MIN(STOC5.2.14, 2), STOC5.2.13, IIF(MIN(STOC5.2.12, 2) > STOC5.2.14 AND STOC5.2.14 < MIN(STOC5.2.15, 2), STOC5.2.14, IIF(MIN(STOC5.2.13, 2) > STOC5.2.15 AND STOC5.2.15 < MIN(STOC5.2.16, 2), STOC5.2.15, IIF(MIN(STOC5.2.14, 2) > STOC5.2.16 AND STOC5.2.16 < MIN(STOC5.2.17, 2), STOC5.2.16, IIF(MIN(STOC5.2.15, 2) > STOC5.2.17 AND STOC5.2.17 < MIN(STOC5.2.18, 2), STOC5.2.17, IIF(MIN(STOC5.2.16, 2) > STOC5.2.18 AND STOC5.2.18 < MIN(STOC5.2.19, 2), STOC5.2.18, IIF(MIN(STOC5.2.17, 2) > STOC5.2.19 AND STOC5.2.19 < MIN(STOC5.2.20, 2), STOC5.2.19, IIF(MIN(STOC5.2.18, 2) > STOC5.2.20 AND STOC5.2.20 < MIN(STOC5.2.21, 2), STOC5.2.20, IIF(MIN(STOC5.2.19, 2) > STOC5.2.21 AND STOC5.2.21 < MIN(STOC5.2.22, 2), STOC5.2.21, IIF(MIN(STOC5.2.20, 2) > STOC5.2.22 AND STOC5.2.22 < MIN(STOC5.2.23, 2), STOC5.2.22, IIF(MIN(STOC5.2.21, 2) > STOC5.2.23 AND STOC5.2.23 < MIN(STOC5.2.24, 2), STOC5.2.23, IIF(MIN(STOC5.2.22, 2) > STOC5.2.24 AND STOC5.2.24 < MIN(STOC5.2.25, 2), STOC5.2.24, IIF(MIN(STOC5.2.23, 2) > STOC5.2.25 AND STOC5.2.25 < MIN(STOC5.2.26, 2), STOC5.2.25, IIF(MIN(STOC5.2.24, 2) > STOC5.2.26 AND STOC5.2.26 < MIN(STOC5.2.27, 2), STOC5.2.26, IIF(MIN(STOC5.2.25, 2) > STOC5.2.27 AND STOC5.2.27 < MIN(STOC5.2.28, 2), STOC5.2.27, IIF(MIN(STOC5.2.26, 2) > STOC5.2.28 AND STOC5.2.28 < MIN(STOC5.2.29, 2), STOC5.2.28, IIF(MIN(STOC5.2.27, 2) > STOC5.2.29 AND STOC5.2.29 < MIN(STOC5.2.30, 2), STOC5.2.29, IIF(MIN(STOC5.2.28, 2) > STOC5.2.30 AND STOC5.2.30 < MIN(STOC5.2.31, 2), STOC5.2.30, IIF(MIN(STOC5.2.29, 2) > STOC5.2.31 AND STOC5.2.31 < MIN(STOC5.2.32, 2), STOC5.2.31, IIF(MIN(STOC5.2.30, 2) > STOC5.2.32 AND STOC5.2.32 < MIN(STOC5.2.33, 2), STOC5.2.32, IIF(MIN(STOC5.2.31, 2) > STOC5.2.33 AND STOC5.2.33 < MIN(STOC5.2.34, 2), STOC5.2.33, IIF(MIN(STOC5.2.32, 2) > STOC5.2.34 AND STOC5.2.34 < MIN(STOC5.2.35, 2), STOC5.2.34, IIF(MIN(STOC5.2.33, 2) > STOC5.2.35 AND STOC5.2.35 < MIN(STOC5.2.36, 2), STOC5.2.35, 101))))))))))))))))))))))))))))))), STOC5.2.2, -10)
LOWER LOW
IIF(MIN(STOC5.2, 2) > STOC5.2.2 AND STOC5.2.2 < MIN(STOC5.2.3, 2) AND STOC5.2.2 < IIF(MIN(STOC5.2.3, 2) > STOC5.2.5 AND STOC5.2.5 < MIN(STOC5.2.6, 2), STOC5.2.5, IIF(MIN(STOC5.2.4, 2) > STOC5.2.6 AND STOC5.2.6 < MIN(STOC5.2.7, 2), STOC5.2.6, IIF(MIN(STOC5.2.5, 2) > STOC5.2.7 AND STOC5.2.7 < MIN(STOC5.2.8, 2), STOC5.2.7, IIF(MIN(STOC5.2.6, 2) > STOC5.2.8 AND STOC5.2.8 < MIN(STOC5.2.9, 2), STOC5.2.8, IIF(MIN(STOC5.2.7, 2) > STOC5.2.9 AND STOC5.2.9 < MIN(STOC5.2.10, 2), STOC5.2.9, IIF(MIN(STOC5.2.8, 2) > STOC5.2.10 AND STOC5.2.10 < MIN(STOC5.2.11, 2), STOC5.2.10, IIF(MIN(STOC5.2.9, 2) > STOC5.2.11 AND STOC5.2.11 < MIN(STOC5.2.12, 2), STOC5.2.11, IIF(MIN(STOC5.2.10, 2) > STOC5.2.12 AND STOC5.2.12 < MIN(STOC5.2.13, 2), STOC5.2.12, IIF(MIN(STOC5.2.11, 2) > STOC5.2.13 AND STOC5.2.13 < MIN(STOC5.2.14, 2), STOC5.2.13, IIF(MIN(STOC5.2.12, 2) > STOC5.2.14 AND STOC5.2.14 < MIN(STOC5.2.15, 2), STOC5.2.14, IIF(MIN(STOC5.2.13, 2) > STOC5.2.15 AND STOC5.2.15 < MIN(STOC5.2.16, 2), STOC5.2.15, IIF(MIN(STOC5.2.14, 2) > STOC5.2.16 AND STOC5.2.16 < MIN(STOC5.2.17, 2), STOC5.2.16, IIF(MIN(STOC5.2.15, 2) > STOC5.2.17 AND STOC5.2.17 < MIN(STOC5.2.18, 2), STOC5.2.17, IIF(MIN(STOC5.2.16, 2) > STOC5.2.18 AND STOC5.2.18 < MIN(STOC5.2.19, 2), STOC5.2.18, IIF(MIN(STOC5.2.17, 2) > STOC5.2.19 AND STOC5.2.19 < MIN(STOC5.2.20, 2), STOC5.2.19, IIF(MIN(STOC5.2.18, 2) > STOC5.2.20 AND STOC5.2.20 < MIN(STOC5.2.21, 2), STOC5.2.20, IIF(MIN(STOC5.2.19, 2) > STOC5.2.21 AND STOC5.2.21 < MIN(STOC5.2.22, 2), STOC5.2.21, IIF(MIN(STOC5.2.20, 2) > STOC5.2.22 AND STOC5.2.22 < MIN(STOC5.2.23, 2), STOC5.2.22, IIF(MIN(STOC5.2.21, 2) > STOC5.2.23 AND STOC5.2.23 < MIN(STOC5.2.24, 2), STOC5.2.23, IIF(MIN(STOC5.2.22, 2) > STOC5.2.24 AND STOC5.2.24 < MIN(STOC5.2.25, 2), STOC5.2.24, IIF(MIN(STOC5.2.23, 2) > STOC5.2.25 AND STOC5.2.25 < MIN(STOC5.2.26, 2), STOC5.2.25, IIF(MIN(STOC5.2.24, 2) > STOC5.2.26 AND STOC5.2.26 < MIN(STOC5.2.27, 2), STOC5.2.26, IIF(MIN(STOC5.2.25, 2) > STOC5.2.27 AND STOC5.2.27 < MIN(STOC5.2.28, 2), STOC5.2.27, IIF(MIN(STOC5.2.26, 2) > STOC5.2.28 AND STOC5.2.28 < MIN(STOC5.2.29, 2), STOC5.2.28, IIF(MIN(STOC5.2.27, 2) > STOC5.2.29 AND STOC5.2.29 < MIN(STOC5.2.30, 2), STOC5.2.29, IIF(MIN(STOC5.2.28, 2) > STOC5.2.30 AND STOC5.2.30 < MIN(STOC5.2.31, 2), STOC5.2.30, IIF(MIN(STOC5.2.29, 2) > STOC5.2.31 AND STOC5.2.31 < MIN(STOC5.2.32, 2), STOC5.2.31, IIF(MIN(STOC5.2.30, 2) > STOC5.2.32 AND STOC5.2.32 < MIN(STOC5.2.33, 2), STOC5.2.32, IIF(MIN(STOC5.2.31, 2) > STOC5.2.33 AND STOC5.2.33 < MIN(STOC5.2.34, 2), STOC5.2.33, IIF(MIN(STOC5.2.32, 2) > STOC5.2.34 AND STOC5.2.34 < MIN(STOC5.2.35, 2), STOC5.2.34, IIF(MIN(STOC5.2.33, 2) > STOC5.2.35 AND STOC5.2.35 < MIN(STOC5.2.36, 2), STOC5.2.35, -1))))))))))))))))))))))))))))))), STOC5.2.2, -10)
And i use them everyday .... but I tried plotting them on SMI main line but the dots are not plotting correctly so if u can just modify in the HH, HL, LH, LL formulas to fit on SMI ..please that would be a great visual secondary confirmation as some signals are caught visually better when looking SMI
thanks
|