I would appreciate help with a scan looking for stocks trading within a percentage or range of percentage of a crossover of either a Simple moving average or exponential moving average.

Example is 2% above crossover of EMA13 and EMA34. this could be for daily, weekly hours or minutes.I would really appreciate this Bruce if you can help out . TIA

The following Condition Formula should return true for when price is at least 2% above price the last time EMA13 crossed through EMA34 in either direction as long as that crossover happened within the most recent 105-bars. Something similar for the value of the intersection of the two moving averages quickly gets too long and slow to be practical or post in the forums.

Days Since Last Peak (or other day-counting needs)

100 * (C / (ABS(SGN(XAVGC13 - XAVGC34) <> SGN(XAVGC13.1 - XAVGC34.1)) * C + ABS(SGN(XAVGC13 - XAVGC34) = SGN(XAVGC13.1 - XAVGC34.1)) * (ABS(SGN(XAVGC13.1 - XAVGC34.1) <> SGN(XAVGC13.2 - XAVGC34.2)) * C1 + ABS(SGN(XAVGC13.1 - XAVGC34.1) = SGN(XAVGC13.2 - XAVGC34.2)) * (ABS(SGN(XAVGC13.2 - XAVGC34.2) <> SGN(XAVGC13.3 - XAVGC34.3)) * C2 + ABS(SGN(XAVGC13.2 - XAVGC34.2) = SGN(XAVGC13.3 - XAVGC34.3)) * (ABS(SGN(XAVGC13.3 - XAVGC34.3) <> SGN(XAVGC13.4 - XAVGC34.4)) * C3 + ABS(SGN(XAVGC13.3 - XAVGC34.3) = SGN(XAVGC13.4 - XAVGC34.4)) * (ABS(SGN(XAVGC13.4 - XAVGC34.4) <> SGN(XAVGC13.5 - XAVGC34.5)) * C4 + ABS(SGN(XAVGC13.4 - XAVGC34.4) = SGN(XAVGC13.5 - XAVGC34.5)) * (ABS(SGN(XAVGC13.5 - XAVGC34.5) <> SGN(XAVGC13.6 - XAVGC34.6)) * C5 + ABS(SGN(XAVGC13.5 - XAVGC34.5) = SGN(XAVGC13.6 - XAVGC34.6)) * (ABS(SGN(XAVGC13.6 - XAVGC34.6) <> SGN(XAVGC13.7 - XAVGC34.7)) * C6 + ABS(SGN(XAVGC13.6 - XAVGC34.6) = SGN(XAVGC13.7 - XAVGC34.7)) * (ABS(SGN(XAVGC13.7 - XAVGC34.7) <> SGN(XAVGC13.8 - XAVGC34.8)) * C7 + ABS(SGN(XAVGC13.7 - XAVGC34.7) = SGN(XAVGC13.8 - XAVGC34.8)) * (ABS(SGN(XAVGC13.8 - XAVGC34.8) <> SGN(XAVGC13.9 - XAVGC34.9)) * C8 + ABS(SGN(XAVGC13.8 - XAVGC34.8) = SGN(XAVGC13.9 - XAVGC34.9)) * (ABS(SGN(XAVGC13.9 - XAVGC34.9) <> SGN(XAVGC13.10 - XAVGC34.10)) * C9 + ABS(SGN(XAVGC13.9 - XAVGC34.9) = SGN(XAVGC13.10 - XAVGC34.10)) * (ABS(SGN(XAVGC13.10 - XAVGC34.10) <> SGN(XAVGC13.11 - XAVGC34.11)) * C10 + ABS(SGN(XAVGC13.10 - XAVGC34.10) = SGN(XAVGC13.11 - XAVGC34.11)) * (ABS(SGN(XAVGC13.11 - XAVGC34.11) <> SGN(XAVGC13.12 - XAVGC34.12)) * C11 + ABS(SGN(XAVGC13.11 - XAVGC34.11) = SGN(XAVGC13.12 - XAVGC34.12)) * (ABS(SGN(XAVGC13.12 - XAVGC34.12) <> SGN(XAVGC13.13 - XAVGC34.13)) * C12 + ABS(SGN(XAVGC13.12 - XAVGC34.12) = SGN(XAVGC13.13 - XAVGC34.13)) * (ABS(SGN(XAVGC13.13 - XAVGC34.13) <> SGN(XAVGC13.14 - XAVGC34.14)) * C13 + ABS(SGN(XAVGC13.13 - XAVGC34.13) = SGN(XAVGC13.14 - XAVGC34.14)) * (ABS(SGN(XAVGC13.14 - XAVGC34.14) <> SGN(XAVGC13.15 - XAVGC34.15)) * C14 + ABS(SGN(XAVGC13.14 - XAVGC34.14) = SGN(XAVGC13.15 - XAVGC34.15)) * (ABS(SGN(XAVGC13.15 - XAVGC34.15) <> SGN(XAVGC13.16 - XAVGC34.16)) * C15 + ABS(SGN(XAVGC13.15 - XAVGC34.15) = SGN(XAVGC13.16 - XAVGC34.16)) * (ABS(SGN(XAVGC13.16 - XAVGC34.16) <> SGN(XAVGC13.17 - XAVGC34.17)) * C16 + ABS(SGN(XAVGC13.16 - XAVGC34.16) = SGN(XAVGC13.17 - XAVGC34.17)) * (ABS(SGN(XAVGC13.17 - XAVGC34.17) <> SGN(XAVGC13.18 - XAVGC34.18)) * C17 + ABS(SGN(XAVGC13.17 - XAVGC34.17) = SGN(XAVGC13.18 - XAVGC34.18)) * (ABS(SGN(XAVGC13.18 - XAVGC34.18) <> SGN(XAVGC13.19 - XAVGC34.19)) * C18 + ABS(SGN(XAVGC13.18 - XAVGC34.18) = SGN(XAVGC13.19 - XAVGC34.19)) * (ABS(SGN(XAVGC13.19 - XAVGC34.19) <> SGN(XAVGC13.20 - XAVGC34.20)) * C19 + ABS(SGN(XAVGC13.19 - XAVGC34.19) = SGN(XAVGC13.20 - XAVGC34.20)) * (ABS(SGN(XAVGC13.20 - XAVGC34.20) <> SGN(XAVGC13.21 - XAVGC34.21)) * C20 + ABS(SGN(XAVGC13.20 - XAVGC34.20) = SGN(XAVGC13.21 - XAVGC34.21)) * (ABS(SGN(XAVGC13.21 - XAVGC34.21) <> SGN(XAVGC13.22 - XAVGC34.22)) * C21 + ABS(SGN(XAVGC13.21 - XAVGC34.21) = SGN(XAVGC13.22 - XAVGC34.22)) * (ABS(SGN(XAVGC13.22 - XAVGC34.22) <> SGN(XAVGC13.23 - XAVGC34.23)) * C22 + ABS(SGN(XAVGC13.22 - XAVGC34.22) = SGN(XAVGC13.23 - XAVGC34.23)) * (ABS(SGN(XAVGC13.23 - XAVGC34.23) <> SGN(XAVGC13.24 - XAVGC34.24)) * C23 + ABS(SGN(XAVGC13.23 - XAVGC34.23) = SGN(XAVGC13.24 - XAVGC34.24)) * (ABS(SGN(XAVGC13.24 - XAVGC34.24) <> SGN(XAVGC13.25 - XAVGC34.25)) * C24 + ABS(SGN(XAVGC13.24 - XAVGC34.24) = SGN(XAVGC13.25 - XAVGC34.25)) * (ABS(SGN(XAVGC13.25 - XAVGC34.25) <> SGN(XAVGC13.26 - XAVGC34.26)) * C25 + ABS(SGN(XAVGC13.25 - XAVGC34.25) = SGN(XAVGC13.26 - XAVGC34.26)) * (ABS(SGN(XAVGC13.26 - XAVGC34.26) <> SGN(XAVGC13.27 - XAVGC34.27)) * C26 + ABS(SGN(XAVGC13.26 - XAVGC34.26) = SGN(XAVGC13.27 - XAVGC34.27)) * (ABS(SGN(XAVGC13.27 - XAVGC34.27) <> SGN(XAVGC13.28 - XAVGC34.28)) * C27 + ABS(SGN(XAVGC13.27 - XAVGC34.27) = SGN(XAVGC13.28 - XAVGC34.28)) * (ABS(SGN(XAVGC13.28 - XAVGC34.28) <> SGN(XAVGC13.29 - XAVGC34.29)) * C28 + ABS(SGN(XAVGC13.28 - XAVGC34.28) = SGN(XAVGC13.29 - XAVGC34.29)) * (ABS(SGN(XAVGC13.29 - XAVGC34.29) <> SGN(XAVGC13.30 - XAVGC34.30)) * C29 + ABS(SGN(XAVGC13.29 - XAVGC34.29) = SGN(XAVGC13.30 - XAVGC34.30)) * (ABS(SGN(XAVGC13.30 - XAVGC34.30) <> SGN(XAVGC13.31 - XAVGC34.31)) * C30 + ABS(SGN(XAVGC13.30 - XAVGC34.30) = SGN(XAVGC13.31 - XAVGC34.31)) * (ABS(SGN(XAVGC13.31 - XAVGC34.31) <> SGN(XAVGC13.32 - XAVGC34.32)) * C31 + ABS(SGN(XAVGC13.31 - XAVGC34.31) = SGN(XAVGC13.32 - XAVGC34.32)) * (ABS(SGN(XAVGC13.32 - XAVGC34.32) <> SGN(XAVGC13.33 - XAVGC34.33)) * C32 + ABS(SGN(XAVGC13.32 - XAVGC34.32) = SGN(XAVGC13.33 - XAVGC34.33)) * (ABS(SGN(XAVGC13.33 - XAVGC34.33) <> SGN(XAVGC13.34 - XAVGC34.34)) * C33 + ABS(SGN(XAVGC13.33 - XAVGC34.33) = SGN(XAVGC13.34 - XAVGC34.34)) * (ABS(SGN(XAVGC13.34 - XAVGC34.34) <> SGN(XAVGC13.35 - XAVGC34.35)) * C34 + ABS(SGN(XAVGC13.34 - XAVGC34.34) = SGN(XAVGC13.35 - XAVGC34.35)) * (ABS(SGN(XAVGC13.35 - XAVGC34.35) <> SGN(XAVGC13.36 - XAVGC34.36)) * C35 + ABS(SGN(XAVGC13.35 - XAVGC34.35) = SGN(XAVGC13.36 - XAVGC34.36)) * (ABS(SGN(XAVGC13.36 - XAVGC34.36) <> SGN(XAVGC13.37 - XAVGC34.37)) * C36 + ABS(SGN(XAVGC13.36 - XAVGC34.36) = SGN(XAVGC13.37 - XAVGC34.37)) * (ABS(SGN(XAVGC13.37 - XAVGC34.37) <> SGN(XAVGC13.38 - XAVGC34.38)) * C37 + ABS(SGN(XAVGC13.37 - XAVGC34.37) = SGN(XAVGC13.38 - XAVGC34.38)) * (ABS(SGN(XAVGC13.38 - XAVGC34.38) <> SGN(XAVGC13.39 - XAVGC34.39)) * C38 + ABS(SGN(XAVGC13.38 - XAVGC34.38) = SGN(XAVGC13.39 - XAVGC34.39)) * (ABS(SGN(XAVGC13.39 - XAVGC34.39) <> SGN(XAVGC13.40 - XAVGC34.40)) * C39 + ABS(SGN(XAVGC13.39 - XAVGC34.39) = SGN(XAVGC13.40 - XAVGC34.40)) * (ABS(SGN(XAVGC13.40 - XAVGC34.40) <> SGN(XAVGC13.41 - XAVGC34.41)) * C40 + ABS(SGN(XAVGC13.40 - XAVGC34.40) = SGN(XAVGC13.41 - XAVGC34.41)) * (ABS(SGN(XAVGC13.41 - XAVGC34.41) <> SGN(XAVGC13.42 - XAVGC34.42)) * C41 + ABS(SGN(XAVGC13.41 - XAVGC34.41) = SGN(XAVGC13.42 - XAVGC34.42)) * (ABS(SGN(XAVGC13.42 - XAVGC34.42) <> SGN(XAVGC13.43 - XAVGC34.43)) * C42 + ABS(SGN(XAVGC13.42 - XAVGC34.42) = SGN(XAVGC13.43 - XAVGC34.43)) * (ABS(SGN(XAVGC13.43 - XAVGC34.43) <> SGN(XAVGC13.44 - XAVGC34.44)) * C43 + ABS(SGN(XAVGC13.43 - XAVGC34.43) = SGN(XAVGC13.44 - XAVGC34.44)) * (ABS(SGN(XAVGC13.44 - XAVGC34.44) <> SGN(XAVGC13.45 - XAVGC34.45)) * C44 + ABS(SGN(XAVGC13.44 - XAVGC34.44) = SGN(XAVGC13.45 - XAVGC34.45)) * (ABS(SGN(XAVGC13.45 - XAVGC34.45) <> SGN(XAVGC13.46 - XAVGC34.46)) * C45 + ABS(SGN(XAVGC13.45 - XAVGC34.45) = SGN(XAVGC13.46 - XAVGC34.46)) * (ABS(SGN(XAVGC13.46 - XAVGC34.46) <> SGN(XAVGC13.47 - XAVGC34.47)) * C46 + ABS(SGN(XAVGC13.46 - XAVGC34.46) = SGN(XAVGC13.47 - XAVGC34.47)) * (ABS(SGN(XAVGC13.47 - XAVGC34.47) <> SGN(XAVGC13.48 - XAVGC34.48)) * C47 + ABS(SGN(XAVGC13.47 - XAVGC34.47) = SGN(XAVGC13.48 - XAVGC34.48)) * (ABS(SGN(XAVGC13.48 - XAVGC34.48) <> SGN(XAVGC13.49 - XAVGC34.49)) * C48 + ABS(SGN(XAVGC13.48 - XAVGC34.48) = SGN(XAVGC13.49 - XAVGC34.49)) * (ABS(SGN(XAVGC13.49 - XAVGC34.49) <> SGN(XAVGC13.50 - XAVGC34.50)) * C49 + ABS(SGN(XAVGC13.49 - XAVGC34.49) = SGN(XAVGC13.50 - XAVGC34.50)) * (ABS(SGN(XAVGC13.50 - XAVGC34.50) <> SGN(XAVGC13.51 - XAVGC34.51)) * C50 + ABS(SGN(XAVGC13.50 - XAVGC34.50) = SGN(XAVGC13.51 - XAVGC34.51)) * (ABS(SGN(XAVGC13.51 - XAVGC34.51) <> SGN(XAVGC13.52 - XAVGC34.52)) * C51 + ABS(SGN(XAVGC13.51 - XAVGC34.51) = SGN(XAVGC13.52 - XAVGC34.52)) * (ABS(SGN(XAVGC13.52 - XAVGC34.52) <> SGN(XAVGC13.53 - XAVGC34.53)) * C52 + ABS(SGN(XAVGC13.52 - XAVGC34.52) = SGN(XAVGC13.53 - XAVGC34.53)) * (ABS(SGN(XAVGC13.53 - XAVGC34.53) <> SGN(XAVGC13.54 - XAVGC34.54)) * C53 + ABS(SGN(XAVGC13.53 - XAVGC34.53) = SGN(XAVGC13.54 - XAVGC34.54)) * (ABS(SGN(XAVGC13.54 - XAVGC34.54) <> SGN(XAVGC13.55 - XAVGC34.55)) * C54 + ABS(SGN(XAVGC13.54 - XAVGC34.54) = SGN(XAVGC13.55 - XAVGC34.55)) * (ABS(SGN(XAVGC13.55 - XAVGC34.55) <> SGN(XAVGC13.56 - XAVGC34.56)) * C55 + ABS(SGN(XAVGC13.55 - XAVGC34.55) = SGN(XAVGC13.56 - XAVGC34.56)) * (ABS(SGN(XAVGC13.56 - XAVGC34.56) <> SGN(XAVGC13.57 - XAVGC34.57)) * C56 + ABS(SGN(XAVGC13.56 - XAVGC34.56) = SGN(XAVGC13.57 - XAVGC34.57)) * (ABS(SGN(XAVGC13.57 - XAVGC34.57) <> SGN(XAVGC13.58 - XAVGC34.58)) * C57 + ABS(SGN(XAVGC13.57 - XAVGC34.57) = SGN(XAVGC13.58 - XAVGC34.58)) * (ABS(SGN(XAVGC13.58 - XAVGC34.58) <> SGN(XAVGC13.59 - XAVGC34.59)) * C58 + ABS(SGN(XAVGC13.58 - XAVGC34.58) = SGN(XAVGC13.59 - XAVGC34.59)) * (ABS(SGN(XAVGC13.59 - XAVGC34.59) <> SGN(XAVGC13.60 - XAVGC34.60)) * C59 + ABS(SGN(XAVGC13.59 - XAVGC34.59) = SGN(XAVGC13.60 - XAVGC34.60)) * (ABS(SGN(XAVGC13.60 - XAVGC34.60) <> SGN(XAVGC13.61 - XAVGC34.61)) * C60 + ABS(SGN(XAVGC13.60 - XAVGC34.60) = SGN(XAVGC13.61 - XAVGC34.61)) * (ABS(SGN(XAVGC13.61 - XAVGC34.61) <> SGN(XAVGC13.62 - XAVGC34.62)) * C61 + ABS(SGN(XAVGC13.61 - XAVGC34.61) = SGN(XAVGC13.62 - XAVGC34.62)) * (ABS(SGN(XAVGC13.62 - XAVGC34.62) <> SGN(XAVGC13.63 - XAVGC34.63)) * C62 + ABS(SGN(XAVGC13.62 - XAVGC34.62) = SGN(XAVGC13.63 - XAVGC34.63)) * (ABS(SGN(XAVGC13.63 - XAVGC34.63) <> SGN(XAVGC13.64 - XAVGC34.64)) * C63 + ABS(SGN(XAVGC13.63 - XAVGC34.63) = SGN(XAVGC13.64 - XAVGC34.64)) * (ABS(SGN(XAVGC13.64 - XAVGC34.64) <> SGN(XAVGC13.65 - XAVGC34.65)) * C64 + ABS(SGN(XAVGC13.64 - XAVGC34.64) = SGN(XAVGC13.65 - XAVGC34.65)) * (ABS(SGN(XAVGC13.65 - XAVGC34.65) <> SGN(XAVGC13.66 - XAVGC34.66)) * C65 + ABS(SGN(XAVGC13.65 - XAVGC34.65) = SGN(XAVGC13.66 - XAVGC34.66)) * (ABS(SGN(XAVGC13.66 - XAVGC34.66) <> SGN(XAVGC13.67 - XAVGC34.67)) * C66 + ABS(SGN(XAVGC13.66 - XAVGC34.66) = SGN(XAVGC13.67 - XAVGC34.67)) * (ABS(SGN(XAVGC13.67 - XAVGC34.67) <> SGN(XAVGC13.68 - XAVGC34.68)) * C67 + ABS(SGN(XAVGC13.67 - XAVGC34.67) = SGN(XAVGC13.68 - XAVGC34.68)) * (ABS(SGN(XAVGC13.68 - XAVGC34.68) <> SGN(XAVGC13.69 - XAVGC34.69)) * C68 + ABS(SGN(XAVGC13.68 - XAVGC34.68) = SGN(XAVGC13.69 - XAVGC34.69)) * (ABS(SGN(XAVGC13.69 - XAVGC34.69) <> SGN(XAVGC13.70 - XAVGC34.70)) * C69 + ABS(SGN(XAVGC13.69 - XAVGC34.69) = SGN(XAVGC13.70 - XAVGC34.70)) * (ABS(SGN(XAVGC13.70 - XAVGC34.70) <> SGN(XAVGC13.71 - XAVGC34.71)) * C70 + ABS(SGN(XAVGC13.70 - XAVGC34.70) = SGN(XAVGC13.71 - XAVGC34.71)) * (ABS(SGN(XAVGC13.71 - XAVGC34.71) <> SGN(XAVGC13.72 - XAVGC34.72)) * C71 + ABS(SGN(XAVGC13.71 - XAVGC34.71) = SGN(XAVGC13.72 - XAVGC34.72)) * (ABS(SGN(XAVGC13.72 - XAVGC34.72) <> SGN(XAVGC13.73 - XAVGC34.73)) * C72 + ABS(SGN(XAVGC13.72 - XAVGC34.72) = SGN(XAVGC13.73 - XAVGC34.73)) * (ABS(SGN(XAVGC13.73 - XAVGC34.73) <> SGN(XAVGC13.74 - XAVGC34.74)) * C73 + ABS(SGN(XAVGC13.73 - XAVGC34.73) = SGN(XAVGC13.74 - XAVGC34.74)) * (ABS(SGN(XAVGC13.74 - XAVGC34.74) <> SGN(XAVGC13.75 - XAVGC34.75)) * C74 + ABS(SGN(XAVGC13.74 - XAVGC34.74) = SGN(XAVGC13.75 - XAVGC34.75)) * (ABS(SGN(XAVGC13.75 - XAVGC34.75) <> SGN(XAVGC13.76 - XAVGC34.76)) * C75 + ABS(SGN(XAVGC13.75 - XAVGC34.75) = SGN(XAVGC13.76 - XAVGC34.76)) * (ABS(SGN(XAVGC13.76 - XAVGC34.76) <> SGN(XAVGC13.77 - XAVGC34.77)) * C76 + ABS(SGN(XAVGC13.76 - XAVGC34.76) = SGN(XAVGC13.77 - XAVGC34.77)) * (ABS(SGN(XAVGC13.77 - XAVGC34.77) <> SGN(XAVGC13.78 - XAVGC34.78)) * C77 + ABS(SGN(XAVGC13.77 - XAVGC34.77) = SGN(XAVGC13.78 - XAVGC34.78)) * (ABS(SGN(XAVGC13.78 - XAVGC34.78) <> SGN(XAVGC13.79 - XAVGC34.79)) * C78 + ABS(SGN(XAVGC13.78 - XAVGC34.78) = SGN(XAVGC13.79 - XAVGC34.79)) * (ABS(SGN(XAVGC13.79 - XAVGC34.79) <> SGN(XAVGC13.80 - XAVGC34.80)) * C79 + ABS(SGN(XAVGC13.79 - XAVGC34.79) = SGN(XAVGC13.80 - XAVGC34.80)) * (ABS(SGN(XAVGC13.80 - XAVGC34.80) <> SGN(XAVGC13.81 - XAVGC34.81)) * C80 + ABS(SGN(XAVGC13.80 - XAVGC34.80) = SGN(XAVGC13.81 - XAVGC34.81)) * (ABS(SGN(XAVGC13.81 - XAVGC34.81) <> SGN(XAVGC13.82 - XAVGC34.82)) * C81 + ABS(SGN(XAVGC13.81 - XAVGC34.81) = SGN(XAVGC13.82 - XAVGC34.82)) * (ABS(SGN(XAVGC13.82 - XAVGC34.82) <> SGN(XAVGC13.83 - XAVGC34.83)) * C82 + ABS(SGN(XAVGC13.82 - XAVGC34.82) = SGN(XAVGC13.83 - XAVGC34.83)) * (ABS(SGN(XAVGC13.83 - XAVGC34.83) <> SGN(XAVGC13.84 - XAVGC34.84)) * C83 + ABS(SGN(XAVGC13.83 - XAVGC34.83) = SGN(XAVGC13.84 - XAVGC34.84)) * (ABS(SGN(XAVGC13.84 - XAVGC34.84) <> SGN(XAVGC13.85 - XAVGC34.85)) * C84 + ABS(SGN(XAVGC13.84 - XAVGC34.84) = SGN(XAVGC13.85 - XAVGC34.85)) * (ABS(SGN(XAVGC13.85 - XAVGC34.85) <> SGN(XAVGC13.86 - XAVGC34.86)) * C85 + ABS(SGN(XAVGC13.85 - XAVGC34.85) = SGN(XAVGC13.86 - XAVGC34.86)) * (ABS(SGN(XAVGC13.86 - XAVGC34.86) <> SGN(XAVGC13.87 - XAVGC34.87)) * C86 + ABS(SGN(XAVGC13.86 - XAVGC34.86) = SGN(XAVGC13.87 - XAVGC34.87)) * (ABS(SGN(XAVGC13.87 - XAVGC34.87) <> SGN(XAVGC13.88 - XAVGC34.88)) * C87 + ABS(SGN(XAVGC13.87 - XAVGC34.87) = SGN(XAVGC13.88 - XAVGC34.88)) * (ABS(SGN(XAVGC13.88 - XAVGC34.88) <> SGN(XAVGC13.89 - XAVGC34.89)) * C88 + ABS(SGN(XAVGC13.88 - XAVGC34.88) = SGN(XAVGC13.89 - XAVGC34.89)) * (ABS(SGN(XAVGC13.89 - XAVGC34.89) <> SGN(XAVGC13.90 - XAVGC34.90)) * C89 + ABS(SGN(XAVGC13.89 - XAVGC34.89) = SGN(XAVGC13.90 - XAVGC34.90)) * (ABS(SGN(XAVGC13.90 - XAVGC34.90) <> SGN(XAVGC13.91 - XAVGC34.91)) * C90 + ABS(SGN(XAVGC13.90 - XAVGC34.90) = SGN(XAVGC13.91 - XAVGC34.91)) * (ABS(SGN(XAVGC13.91 - XAVGC34.91) <> SGN(XAVGC13.92 - XAVGC34.92)) * C91 + ABS(SGN(XAVGC13.91 - XAVGC34.91) = SGN(XAVGC13.92 - XAVGC34.92)) * (ABS(SGN(XAVGC13.92 - XAVGC34.92) <> SGN(XAVGC13.93 - XAVGC34.93)) * C92 + ABS(SGN(XAVGC13.92 - XAVGC34.92) = SGN(XAVGC13.93 - XAVGC34.93)) * (ABS(SGN(XAVGC13.93 - XAVGC34.93) <> SGN(XAVGC13.94 - XAVGC34.94)) * C93 + ABS(SGN(XAVGC13.93 - XAVGC34.93) = SGN(XAVGC13.94 - XAVGC34.94)) * (ABS(SGN(XAVGC13.94 - XAVGC34.94) <> SGN(XAVGC13.95 - XAVGC34.95)) * C94 + ABS(SGN(XAVGC13.94 - XAVGC34.94) = SGN(XAVGC13.95 - XAVGC34.95)) * (ABS(SGN(XAVGC13.95 - XAVGC34.95) <> SGN(XAVGC13.96 - XAVGC34.96)) * C95 + ABS(SGN(XAVGC13.95 - XAVGC34.95) = SGN(XAVGC13.96 - XAVGC34.96)) * (ABS(SGN(XAVGC13.96 - XAVGC34.96) <> SGN(XAVGC13.97 - XAVGC34.97)) * C96 + ABS(SGN(XAVGC13.96 - XAVGC34.96) = SGN(XAVGC13.97 - XAVGC34.97)) * (ABS(SGN(XAVGC13.97 - XAVGC34.97) <> SGN(XAVGC13.98 - XAVGC34.98)) * C97 + ABS(SGN(XAVGC13.97 - XAVGC34.97) = SGN(XAVGC13.98 - XAVGC34.98)) * (ABS(SGN(XAVGC13.98 - XAVGC34.98) <> SGN(XAVGC13.99 - XAVGC34.99)) * C98 + ABS(SGN(XAVGC13.98 - XAVGC34.98) = SGN(XAVGC13.99 - XAVGC34.99)) * (ABS(SGN(XAVGC13.99 - XAVGC34.99) <> SGN(XAVGC13.100 - XAVGC34.100)) * C99 + ABS(SGN(XAVGC13.99 - XAVGC34.99) = SGN(XAVGC13.100 - XAVGC34.100)) * (ABS(SGN(XAVGC13.100 - XAVGC34.100) <> SGN(XAVGC13.101 - XAVGC34.101)) * C100 + ABS(SGN(XAVGC13.100 - XAVGC34.100) = SGN(XAVGC13.101 - XAVGC34.101)) * (ABS(SGN(XAVGC13.101 - XAVGC34.101) <> SGN(XAVGC13.102 - XAVGC34.102)) * C101 + ABS(SGN(XAVGC13.101 - XAVGC34.101) = SGN(XAVGC13.102 - XAVGC34.102)) * (ABS(SGN(XAVGC13.102 - XAVGC34.102) <> SGN(XAVGC13.103 - XAVGC34.103)) * C102 + ABS(SGN(XAVGC13.102 - XAVGC34.102) = SGN(XAVGC13.103 - XAVGC34.103)) * (ABS(SGN(XAVGC13.103 - XAVGC34.103) <> SGN(XAVGC13.104 - XAVGC34.104)) * C103 + ABS(SGN(XAVGC13.103 - XAVGC34.103) = SGN(XAVGC13.104 - XAVGC34.104)) * (ABS(SGN(XAVGC13.104 - XAVGC34.104) <> SGN(XAVGC13.105 - XAVGC34.105)) * C104 + ABS(SGN(XAVGC13.104 - XAVGC34.104) = SGN(XAVGC13.105 - XAVGC34.105)) * (ABS(SGN(XAVGC13.105 - XAVGC34.105) <> SGN(XAVGC13.106 - XAVGC34.106)) * C105)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) >= 2

Thx for your prompt response . Wondering anyway you can show me how to set it up as above the cross over or below that crossover . Example anything beween 3 - 5%  above a cross up of EMA 13 & EMA34 . Also what would i need to change in order to do the reverse if am trying to short a stock for instance, Once again thanks for your assistance

Note that I have already indicated that attempting to find the value of the crossover instead of price at the time of the crossover results in a formula which is too long and slow to be practical or post in the forums. This means that the following instructions still only relate to price at the time of the crossover.

Consider for a moment the formula for a percent change between the previous bar and the current bar:

100 * (C / C1 - 1)

If the most recent cross of interest were on the previous bar, then this would be the percentage that price was above or the price at the time of the cross.

In the formula given in my first response, we were checking for this value to be greater than or equal to 2:

100 * (C / C1 - 1) >= 2

But since we did not actually know when the cross happened, we substituted a very long formula for C1 to calculate what price was on the bar when the moving averages crossed in either direction (as long as that cross happened within the most recent 105 bars).

We can create a similar short formula to check if price is between 3 - 5% above the previous bar:

3 <= 100 * (C / C1 - 1) AND 100 * (C / C1 - 1) <= 5

But this form would mean we need to substitute for C1 twice resulting in a formula which is too long and slow to be practical or post in the forums. We can make a slightly less intuitive formula for this which only has one instance of C1 for which we would need to make a substitution:

ABS(C / C1 - 1.04) <= .01

Note that 1.04 represents the point that is exactly half way between being 3% and 5% above C1 ((1.03 + 1.05) / 2 = 1.04) and that .01 represents half the distance between 3% and 5% ((1.05 - 1.03) / 2 = .01).

A similar formula for being between 3 and 5% below would be:

ABS(C / C1 - .96) <= .01

Now it becomes a matter of substituting in a formula for price at the time of the last cross into these formulas. In the case of a XAVGC13 crossup through XAVGC34 and being 3-5% above the price at the bar of the cross (within 105 bars), we get:

ABS(C / (ABS(XAVGC13 > XAVGC34 AND XAVGC13.1 <= XAVGC34.1) * C + ABS(XAVGC13 <= XAVGC34 OR XAVGC13.1 > XAVGC34.1) * (ABS(XAVGC13.1 > XAVGC34.1 AND XAVGC13.2 <= XAVGC34.2) * C1 + ABS(XAVGC13.1 <= XAVGC34.1 OR XAVGC13.2 > XAVGC34.2) * (ABS(XAVGC13.2 > XAVGC34.2 AND XAVGC13.3 <= XAVGC34.3) * C2 + ABS(XAVGC13.2 <= XAVGC34.2 OR XAVGC13.3 > XAVGC34.3) * (ABS(XAVGC13.3 > XAVGC34.3 AND XAVGC13.4 <= XAVGC34.4) * C3 + ABS(XAVGC13.3 <= XAVGC34.3 OR XAVGC13.4 > XAVGC34.4) * (ABS(XAVGC13.4 > XAVGC34.4 AND XAVGC13.5 <= XAVGC34.5) * C4 + ABS(XAVGC13.4 <= XAVGC34.4 OR XAVGC13.5 > XAVGC34.5) * (ABS(XAVGC13.5 > XAVGC34.5 AND XAVGC13.6 <= XAVGC34.6) * C5 + ABS(XAVGC13.5 <= XAVGC34.5 OR XAVGC13.6 > XAVGC34.6) * (ABS(XAVGC13.6 > XAVGC34.6 AND XAVGC13.7 <= XAVGC34.7) * C6 + ABS(XAVGC13.6 <= XAVGC34.6 OR XAVGC13.7 > XAVGC34.7) * (ABS(XAVGC13.7 > XAVGC34.7 AND XAVGC13.8 <= XAVGC34.8) * C7 + ABS(XAVGC13.7 <= XAVGC34.7 OR XAVGC13.8 > XAVGC34.8) * (ABS(XAVGC13.8 > XAVGC34.8 AND XAVGC13.9 <= XAVGC34.9) * C8 + ABS(XAVGC13.8 <= XAVGC34.8 OR XAVGC13.9 > XAVGC34.9) * (ABS(XAVGC13.9 > XAVGC34.9 AND XAVGC13.10 <= XAVGC34.10) * C9 + ABS(XAVGC13.9 <= XAVGC34.9 OR XAVGC13.10 > XAVGC34.10) * (ABS(XAVGC13.10 > XAVGC34.10 AND XAVGC13.11 <= XAVGC34.11) * C10 + ABS(XAVGC13.10 <= XAVGC34.10 OR XAVGC13.11 > XAVGC34.11) * (ABS(XAVGC13.11 > XAVGC34.11 AND XAVGC13.12 <= XAVGC34.12) * C11 + ABS(XAVGC13.11 <= XAVGC34.11 OR XAVGC13.12 > XAVGC34.12) * (ABS(XAVGC13.12 > XAVGC34.12 AND XAVGC13.13 <= XAVGC34.13) * C12 + ABS(XAVGC13.12 <= XAVGC34.12 OR XAVGC13.13 > XAVGC34.13) * (ABS(XAVGC13.13 > XAVGC34.13 AND XAVGC13.14 <= XAVGC34.14) * C13 + ABS(XAVGC13.13 <= XAVGC34.13 OR XAVGC13.14 > XAVGC34.14) * (ABS(XAVGC13.14 > XAVGC34.14 AND XAVGC13.15 <= XAVGC34.15) * C14 + ABS(XAVGC13.14 <= XAVGC34.14 OR XAVGC13.15 > XAVGC34.15) * (ABS(XAVGC13.15 > XAVGC34.15 AND XAVGC13.16 <= XAVGC34.16) * C15 + ABS(XAVGC13.15 <= XAVGC34.15 OR XAVGC13.16 > XAVGC34.16) * (ABS(XAVGC13.16 > XAVGC34.16 AND XAVGC13.17 <= XAVGC34.17) * C16 + ABS(XAVGC13.16 <= XAVGC34.16 OR XAVGC13.17 > XAVGC34.17) * (ABS(XAVGC13.17 > XAVGC34.17 AND XAVGC13.18 <= XAVGC34.18) * C17 + ABS(XAVGC13.17 <= XAVGC34.17 OR XAVGC13.18 > XAVGC34.18) * (ABS(XAVGC13.18 > XAVGC34.18 AND XAVGC13.19 <= XAVGC34.19) * C18 + ABS(XAVGC13.18 <= XAVGC34.18 OR XAVGC13.19 > XAVGC34.19) * (ABS(XAVGC13.19 > XAVGC34.19 AND XAVGC13.20 <= XAVGC34.20) * C19 + ABS(XAVGC13.19 <= XAVGC34.19 OR XAVGC13.20 > XAVGC34.20) * (ABS(XAVGC13.20 > XAVGC34.20 AND XAVGC13.21 <= XAVGC34.21) * C20 + ABS(XAVGC13.20 <= XAVGC34.20 OR XAVGC13.21 > XAVGC34.21) * (ABS(XAVGC13.21 > XAVGC34.21 AND XAVGC13.22 <= XAVGC34.22) * C21 + ABS(XAVGC13.21 <= XAVGC34.21 OR XAVGC13.22 > XAVGC34.22) * (ABS(XAVGC13.22 > XAVGC34.22 AND XAVGC13.23 <= XAVGC34.23) * C22 + ABS(XAVGC13.22 <= XAVGC34.22 OR XAVGC13.23 > XAVGC34.23) * (ABS(XAVGC13.23 > XAVGC34.23 AND XAVGC13.24 <= XAVGC34.24) * C23 + ABS(XAVGC13.23 <= XAVGC34.23 OR XAVGC13.24 > XAVGC34.24) * (ABS(XAVGC13.24 > XAVGC34.24 AND XAVGC13.25 <= XAVGC34.25) * C24 + ABS(XAVGC13.24 <= XAVGC34.24 OR XAVGC13.25 > XAVGC34.25) * (ABS(XAVGC13.25 > XAVGC34.25 AND XAVGC13.26 <= XAVGC34.26) * C25 + ABS(XAVGC13.25 <= XAVGC34.25 OR XAVGC13.26 > XAVGC34.26) * (ABS(XAVGC13.26 > XAVGC34.26 AND XAVGC13.27 <= XAVGC34.27) * C26 + ABS(XAVGC13.26 <= XAVGC34.26 OR XAVGC13.27 > XAVGC34.27) * (ABS(XAVGC13.27 > XAVGC34.27 AND XAVGC13.28 <= XAVGC34.28) * C27 + ABS(XAVGC13.27 <= XAVGC34.27 OR XAVGC13.28 > XAVGC34.28) * (ABS(XAVGC13.28 > XAVGC34.28 AND XAVGC13.29 <= XAVGC34.29) * C28 + ABS(XAVGC13.28 <= XAVGC34.28 OR XAVGC13.29 > XAVGC34.29) * (ABS(XAVGC13.29 > XAVGC34.29 AND XAVGC13.30 <= XAVGC34.30) * C29 + ABS(XAVGC13.29 <= XAVGC34.29 OR XAVGC13.30 > XAVGC34.30) * (ABS(XAVGC13.30 > XAVGC34.30 AND XAVGC13.31 <= XAVGC34.31) * C30 + ABS(XAVGC13.30 <= XAVGC34.30 OR XAVGC13.31 > XAVGC34.31) * (ABS(XAVGC13.31 > XAVGC34.31 AND XAVGC13.32 <= XAVGC34.32) * C31 + ABS(XAVGC13.31 <= XAVGC34.31 OR XAVGC13.32 > XAVGC34.32) * (ABS(XAVGC13.32 > XAVGC34.32 AND XAVGC13.33 <= XAVGC34.33) * C32 + ABS(XAVGC13.32 <= XAVGC34.32 OR XAVGC13.33 > XAVGC34.33) * (ABS(XAVGC13.33 > XAVGC34.33 AND XAVGC13.34 <= XAVGC34.34) * C33 + ABS(XAVGC13.33 <= XAVGC34.33 OR XAVGC13.34 > XAVGC34.34) * (ABS(XAVGC13.34 > XAVGC34.34 AND XAVGC13.35 <= XAVGC34.35) * C34 + ABS(XAVGC13.34 <= XAVGC34.34 OR XAVGC13.35 > XAVGC34.35) * (ABS(XAVGC13.35 > XAVGC34.35 AND XAVGC13.36 <= XAVGC34.36) * C35 + ABS(XAVGC13.35 <= XAVGC34.35 OR XAVGC13.36 > XAVGC34.36) * (ABS(XAVGC13.36 > XAVGC34.36 AND XAVGC13.37 <= XAVGC34.37) * C36 + ABS(XAVGC13.36 <= XAVGC34.36 OR XAVGC13.37 > XAVGC34.37) * (ABS(XAVGC13.37 > XAVGC34.37 AND XAVGC13.38 <= XAVGC34.38) * C37 + ABS(XAVGC13.37 <= XAVGC34.37 OR XAVGC13.38 > XAVGC34.38) * (ABS(XAVGC13.38 > XAVGC34.38 AND XAVGC13.39 <= XAVGC34.39) * C38 + ABS(XAVGC13.38 <= XAVGC34.38 OR XAVGC13.39 > XAVGC34.39) * (ABS(XAVGC13.39 > XAVGC34.39 AND XAVGC13.40 <= XAVGC34.40) * C39 + ABS(XAVGC13.39 <= XAVGC34.39 OR XAVGC13.40 > XAVGC34.40) * (ABS(XAVGC13.40 > XAVGC34.40 AND XAVGC13.41 <= XAVGC34.41) * C40 + ABS(XAVGC13.40 <= XAVGC34.40 OR XAVGC13.41 > XAVGC34.41) * (ABS(XAVGC13.41 > XAVGC34.41 AND XAVGC13.42 <= XAVGC34.42) * C41 + ABS(XAVGC13.41 <= XAVGC34.41 OR XAVGC13.42 > XAVGC34.42) * (ABS(XAVGC13.42 > XAVGC34.42 AND XAVGC13.43 <= XAVGC34.43) * C42 + ABS(XAVGC13.42 <= XAVGC34.42 OR XAVGC13.43 > XAVGC34.43) * (ABS(XAVGC13.43 > XAVGC34.43 AND XAVGC13.44 <= XAVGC34.44) * C43 + ABS(XAVGC13.43 <= XAVGC34.43 OR XAVGC13.44 > XAVGC34.44) * (ABS(XAVGC13.44 > XAVGC34.44 AND XAVGC13.45 <= XAVGC34.45) * C44 + ABS(XAVGC13.44 <= XAVGC34.44 OR XAVGC13.45 > XAVGC34.45) * (ABS(XAVGC13.45 > XAVGC34.45 AND XAVGC13.46 <= XAVGC34.46) * C45 + ABS(XAVGC13.45 <= XAVGC34.45 OR XAVGC13.46 > XAVGC34.46) * (ABS(XAVGC13.46 > XAVGC34.46 AND XAVGC13.47 <= XAVGC34.47) * C46 + ABS(XAVGC13.46 <= XAVGC34.46 OR XAVGC13.47 > XAVGC34.47) * (ABS(XAVGC13.47 > XAVGC34.47 AND XAVGC13.48 <= XAVGC34.48) * C47 + ABS(XAVGC13.47 <= XAVGC34.47 OR XAVGC13.48 > XAVGC34.48) * (ABS(XAVGC13.48 > XAVGC34.48 AND XAVGC13.49 <= XAVGC34.49) * C48 + ABS(XAVGC13.48 <= XAVGC34.48 OR XAVGC13.49 > XAVGC34.49) * (ABS(XAVGC13.49 > XAVGC34.49 AND XAVGC13.50 <= XAVGC34.50) * C49 + ABS(XAVGC13.49 <= XAVGC34.49 OR XAVGC13.50 > XAVGC34.50) * (ABS(XAVGC13.50 > XAVGC34.50 AND XAVGC13.51 <= XAVGC34.51) * C50 + ABS(XAVGC13.50 <= XAVGC34.50 OR XAVGC13.51 > XAVGC34.51) * (ABS(XAVGC13.51 > XAVGC34.51 AND XAVGC13.52 <= XAVGC34.52) * C51 + ABS(XAVGC13.51 <= XAVGC34.51 OR XAVGC13.52 > XAVGC34.52) * (ABS(XAVGC13.52 > XAVGC34.52 AND XAVGC13.53 <= XAVGC34.53) * C52 + ABS(XAVGC13.52 <= XAVGC34.52 OR XAVGC13.53 > XAVGC34.53) * (ABS(XAVGC13.53 > XAVGC34.53 AND XAVGC13.54 <= XAVGC34.54) * C53 + ABS(XAVGC13.53 <= XAVGC34.53 OR XAVGC13.54 > XAVGC34.54) * (ABS(XAVGC13.54 > XAVGC34.54 AND XAVGC13.55 <= XAVGC34.55) * C54 + ABS(XAVGC13.54 <= XAVGC34.54 OR XAVGC13.55 > XAVGC34.55) * (ABS(XAVGC13.55 > XAVGC34.55 AND XAVGC13.56 <= XAVGC34.56) * C55 + ABS(XAVGC13.55 <= XAVGC34.55 OR XAVGC13.56 > XAVGC34.56) * (ABS(XAVGC13.56 > XAVGC34.56 AND XAVGC13.57 <= XAVGC34.57) * C56 + ABS(XAVGC13.56 <= XAVGC34.56 OR XAVGC13.57 > XAVGC34.57) * (ABS(XAVGC13.57 > XAVGC34.57 AND XAVGC13.58 <= XAVGC34.58) * C57 + ABS(XAVGC13.57 <= XAVGC34.57 OR XAVGC13.58 > XAVGC34.58) * (ABS(XAVGC13.58 > XAVGC34.58 AND XAVGC13.59 <= XAVGC34.59) * C58 + ABS(XAVGC13.58 <= XAVGC34.58 OR XAVGC13.59 > XAVGC34.59) * (ABS(XAVGC13.59 > XAVGC34.59 AND XAVGC13.60 <= XAVGC34.60) * C59 + ABS(XAVGC13.59 <= XAVGC34.59 OR XAVGC13.60 > XAVGC34.60) * (ABS(XAVGC13.60 > XAVGC34.60 AND XAVGC13.61 <= XAVGC34.61) * C60 + ABS(XAVGC13.60 <= XAVGC34.60 OR XAVGC13.61 > XAVGC34.61) * (ABS(XAVGC13.61 > XAVGC34.61 AND XAVGC13.62 <= XAVGC34.62) * C61 + ABS(XAVGC13.61 <= XAVGC34.61 OR XAVGC13.62 > XAVGC34.62) * (ABS(XAVGC13.62 > XAVGC34.62 AND XAVGC13.63 <= XAVGC34.63) * C62 + ABS(XAVGC13.62 <= XAVGC34.62 OR XAVGC13.63 > XAVGC34.63) * (ABS(XAVGC13.63 > XAVGC34.63 AND XAVGC13.64 <= XAVGC34.64) * C63 + ABS(XAVGC13.63 <= XAVGC34.63 OR XAVGC13.64 > XAVGC34.64) * (ABS(XAVGC13.64 > XAVGC34.64 AND XAVGC13.65 <= XAVGC34.65) * C64 + ABS(XAVGC13.64 <= XAVGC34.64 OR XAVGC13.65 > XAVGC34.65) * (ABS(XAVGC13.65 > XAVGC34.65 AND XAVGC13.66 <= XAVGC34.66) * C65 + ABS(XAVGC13.65 <= XAVGC34.65 OR XAVGC13.66 > XAVGC34.66) * (ABS(XAVGC13.66 > XAVGC34.66 AND XAVGC13.67 <= XAVGC34.67) * C66 + ABS(XAVGC13.66 <= XAVGC34.66 OR XAVGC13.67 > XAVGC34.67) * (ABS(XAVGC13.67 > XAVGC34.67 AND XAVGC13.68 <= XAVGC34.68) * C67 + ABS(XAVGC13.67 <= XAVGC34.67 OR XAVGC13.68 > XAVGC34.68) * (ABS(XAVGC13.68 > XAVGC34.68 AND XAVGC13.69 <= XAVGC34.69) * C68 + ABS(XAVGC13.68 <= XAVGC34.68 OR XAVGC13.69 > XAVGC34.69) * (ABS(XAVGC13.69 > XAVGC34.69 AND XAVGC13.70 <= XAVGC34.70) * C69 + ABS(XAVGC13.69 <= XAVGC34.69 OR XAVGC13.70 > XAVGC34.70) * (ABS(XAVGC13.70 > XAVGC34.70 AND XAVGC13.71 <= XAVGC34.71) * C70 + ABS(XAVGC13.70 <= XAVGC34.70 OR XAVGC13.71 > XAVGC34.71) * (ABS(XAVGC13.71 > XAVGC34.71 AND XAVGC13.72 <= XAVGC34.72) * C71 + ABS(XAVGC13.71 <= XAVGC34.71 OR XAVGC13.72 > XAVGC34.72) * (ABS(XAVGC13.72 > XAVGC34.72 AND XAVGC13.73 <= XAVGC34.73) * C72 + ABS(XAVGC13.72 <= XAVGC34.72 OR XAVGC13.73 > XAVGC34.73) * (ABS(XAVGC13.73 > XAVGC34.73 AND XAVGC13.74 <= XAVGC34.74) * C73 + ABS(XAVGC13.73 <= XAVGC34.73 OR XAVGC13.74 > XAVGC34.74) * (ABS(XAVGC13.74 > XAVGC34.74 AND XAVGC13.75 <= XAVGC34.75) * C74 + ABS(XAVGC13.74 <= XAVGC34.74 OR XAVGC13.75 > XAVGC34.75) * (ABS(XAVGC13.75 > XAVGC34.75 AND XAVGC13.76 <= XAVGC34.76) * C75 + ABS(XAVGC13.75 <= XAVGC34.75 OR XAVGC13.76 > XAVGC34.76) * (ABS(XAVGC13.76 > XAVGC34.76 AND XAVGC13.77 <= XAVGC34.77) * C76 + ABS(XAVGC13.76 <= XAVGC34.76 OR XAVGC13.77 > XAVGC34.77) * (ABS(XAVGC13.77 > XAVGC34.77 AND XAVGC13.78 <= XAVGC34.78) * C77 + ABS(XAVGC13.77 <= XAVGC34.77 OR XAVGC13.78 > XAVGC34.78) * (ABS(XAVGC13.78 > XAVGC34.78 AND XAVGC13.79 <= XAVGC34.79) * C78 + ABS(XAVGC13.78 <= XAVGC34.78 OR XAVGC13.79 > XAVGC34.79) * (ABS(XAVGC13.79 > XAVGC34.79 AND XAVGC13.80 <= XAVGC34.80) * C79 + ABS(XAVGC13.79 <= XAVGC34.79 OR XAVGC13.80 > XAVGC34.80) * (ABS(XAVGC13.80 > XAVGC34.80 AND XAVGC13.81 <= XAVGC34.81) * C80 + ABS(XAVGC13.80 <= XAVGC34.80 OR XAVGC13.81 > XAVGC34.81) * (ABS(XAVGC13.81 > XAVGC34.81 AND XAVGC13.82 <= XAVGC34.82) * C81 + ABS(XAVGC13.81 <= XAVGC34.81 OR XAVGC13.82 > XAVGC34.82) * (ABS(XAVGC13.82 > XAVGC34.82 AND XAVGC13.83 <= XAVGC34.83) * C82 + ABS(XAVGC13.82 <= XAVGC34.82 OR XAVGC13.83 > XAVGC34.83) * (ABS(XAVGC13.83 > XAVGC34.83 AND XAVGC13.84 <= XAVGC34.84) * C83 + ABS(XAVGC13.83 <= XAVGC34.83 OR XAVGC13.84 > XAVGC34.84) * (ABS(XAVGC13.84 > XAVGC34.84 AND XAVGC13.85 <= XAVGC34.85) * C84 + ABS(XAVGC13.84 <= XAVGC34.84 OR XAVGC13.85 > XAVGC34.85) * (ABS(XAVGC13.85 > XAVGC34.85 AND XAVGC13.86 <= XAVGC34.86) * C85 + ABS(XAVGC13.85 <= XAVGC34.85 OR XAVGC13.86 > XAVGC34.86) * (ABS(XAVGC13.86 > XAVGC34.86 AND XAVGC13.87 <= XAVGC34.87) * C86 + ABS(XAVGC13.86 <= XAVGC34.86 OR XAVGC13.87 > XAVGC34.87) * (ABS(XAVGC13.87 > XAVGC34.87 AND XAVGC13.88 <= XAVGC34.88) * C87 + ABS(XAVGC13.87 <= XAVGC34.87 OR XAVGC13.88 > XAVGC34.88) * (ABS(XAVGC13.88 > XAVGC34.88 AND XAVGC13.89 <= XAVGC34.89) * C88 + ABS(XAVGC13.88 <= XAVGC34.88 OR XAVGC13.89 > XAVGC34.89) * (ABS(XAVGC13.89 > XAVGC34.89 AND XAVGC13.90 <= XAVGC34.90) * C89 + ABS(XAVGC13.89 <= XAVGC34.89 OR XAVGC13.90 > XAVGC34.90) * (ABS(XAVGC13.90 > XAVGC34.90 AND XAVGC13.91 <= XAVGC34.91) * C90 + ABS(XAVGC13.90 <= XAVGC34.90 OR XAVGC13.91 > XAVGC34.91) * (ABS(XAVGC13.91 > XAVGC34.91 AND XAVGC13.92 <= XAVGC34.92) * C91 + ABS(XAVGC13.91 <= XAVGC34.91 OR XAVGC13.92 > XAVGC34.92) * (ABS(XAVGC13.92 > XAVGC34.92 AND XAVGC13.93 <= XAVGC34.93) * C92 + ABS(XAVGC13.92 <= XAVGC34.92 OR XAVGC13.93 > XAVGC34.93) * (ABS(XAVGC13.93 > XAVGC34.93 AND XAVGC13.94 <= XAVGC34.94) * C93 + ABS(XAVGC13.93 <= XAVGC34.93 OR XAVGC13.94 > XAVGC34.94) * (ABS(XAVGC13.94 > XAVGC34.94 AND XAVGC13.95 <= XAVGC34.95) * C94 + ABS(XAVGC13.94 <= XAVGC34.94 OR XAVGC13.95 > XAVGC34.95) * (ABS(XAVGC13.95 > XAVGC34.95 AND XAVGC13.96 <= XAVGC34.96) * C95 + ABS(XAVGC13.95 <= XAVGC34.95 OR XAVGC13.96 > XAVGC34.96) * (ABS(XAVGC13.96 > XAVGC34.96 AND XAVGC13.97 <= XAVGC34.97) * C96 + ABS(XAVGC13.96 <= XAVGC34.96 OR XAVGC13.97 > XAVGC34.97) * (ABS(XAVGC13.97 > XAVGC34.97 AND XAVGC13.98 <= XAVGC34.98) * C97 + ABS(XAVGC13.97 <= XAVGC34.97 OR XAVGC13.98 > XAVGC34.98) * (ABS(XAVGC13.98 > XAVGC34.98 AND XAVGC13.99 <= XAVGC34.99) * C98 + ABS(XAVGC13.98 <= XAVGC34.98 OR XAVGC13.99 > XAVGC34.99) * (ABS(XAVGC13.99 > XAVGC34.99 AND XAVGC13.100 <= XAVGC34.100) * C99 + ABS(XAVGC13.99 <= XAVGC34.99 OR XAVGC13.100 > XAVGC34.100) * (ABS(XAVGC13.100 > XAVGC34.100 AND XAVGC13.101 <= XAVGC34.101) * C100 + ABS(XAVGC13.100 <= XAVGC34.100 OR XAVGC13.101 > XAVGC34.101) * (ABS(XAVGC13.101 > XAVGC34.101 AND XAVGC13.102 <= XAVGC34.102) * C101 + ABS(XAVGC13.101 <= XAVGC34.101 OR XAVGC13.102 > XAVGC34.102) * (ABS(XAVGC13.102 > XAVGC34.102 AND XAVGC13.103 <= XAVGC34.103) * C102 + ABS(XAVGC13.102 <= XAVGC34.102 OR XAVGC13.103 > XAVGC34.103) * (ABS(XAVGC13.103 > XAVGC34.103 AND XAVGC13.104 <= XAVGC34.104) * C103 + ABS(XAVGC13.103 <= XAVGC34.103 OR XAVGC13.104 > XAVGC34.104) * (ABS(XAVGC13.104 > XAVGC34.104 AND XAVGC13.105 <= XAVGC34.105) * C104))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1.04) <= .01

And in the case of a XAVGC13 crossdown through XAVGC34 and being 3-5% below the price at the bar of the cross (within 105 bars), we get:

ABS(C / (ABS(XAVGC13 < XAVGC34 AND XAVGC13.1 >= XAVGC34.1) * C + ABS(XAVGC13 >= XAVGC34 OR XAVGC13.1 < XAVGC34.1) * (ABS(XAVGC13.1 < XAVGC34.1 AND XAVGC13.2 >= XAVGC34.2) * C1 + ABS(XAVGC13.1 >= XAVGC34.1 OR XAVGC13.2 < XAVGC34.2) * (ABS(XAVGC13.2 < XAVGC34.2 AND XAVGC13.3 >= XAVGC34.3) * C2 + ABS(XAVGC13.2 >= XAVGC34.2 OR XAVGC13.3 < XAVGC34.3) * (ABS(XAVGC13.3 < XAVGC34.3 AND XAVGC13.4 >= XAVGC34.4) * C3 + ABS(XAVGC13.3 >= XAVGC34.3 OR XAVGC13.4 < XAVGC34.4) * (ABS(XAVGC13.4 < XAVGC34.4 AND XAVGC13.5 >= XAVGC34.5) * C4 + ABS(XAVGC13.4 >= XAVGC34.4 OR XAVGC13.5 < XAVGC34.5) * (ABS(XAVGC13.5 < XAVGC34.5 AND XAVGC13.6 >= XAVGC34.6) * C5 + ABS(XAVGC13.5 >= XAVGC34.5 OR XAVGC13.6 < XAVGC34.6) * (ABS(XAVGC13.6 < XAVGC34.6 AND XAVGC13.7 >= XAVGC34.7) * C6 + ABS(XAVGC13.6 >= XAVGC34.6 OR XAVGC13.7 < XAVGC34.7) * (ABS(XAVGC13.7 < XAVGC34.7 AND XAVGC13.8 >= XAVGC34.8) * C7 + ABS(XAVGC13.7 >= XAVGC34.7 OR XAVGC13.8 < XAVGC34.8) * (ABS(XAVGC13.8 < XAVGC34.8 AND XAVGC13.9 >= XAVGC34.9) * C8 + ABS(XAVGC13.8 >= XAVGC34.8 OR XAVGC13.9 < XAVGC34.9) * (ABS(XAVGC13.9 < XAVGC34.9 AND XAVGC13.10 >= XAVGC34.10) * C9 + ABS(XAVGC13.9 >= XAVGC34.9 OR XAVGC13.10 < XAVGC34.10) * (ABS(XAVGC13.10 < XAVGC34.10 AND XAVGC13.11 >= XAVGC34.11) * C10 + ABS(XAVGC13.10 >= XAVGC34.10 OR XAVGC13.11 < XAVGC34.11) * (ABS(XAVGC13.11 < XAVGC34.11 AND XAVGC13.12 >= XAVGC34.12) * C11 + ABS(XAVGC13.11 >= XAVGC34.11 OR XAVGC13.12 < XAVGC34.12) * (ABS(XAVGC13.12 < XAVGC34.12 AND XAVGC13.13 >= XAVGC34.13) * C12 + ABS(XAVGC13.12 >= XAVGC34.12 OR XAVGC13.13 < XAVGC34.13) * (ABS(XAVGC13.13 < XAVGC34.13 AND XAVGC13.14 >= XAVGC34.14) * C13 + ABS(XAVGC13.13 >= XAVGC34.13 OR XAVGC13.14 < XAVGC34.14) * (ABS(XAVGC13.14 < XAVGC34.14 AND XAVGC13.15 >= XAVGC34.15) * C14 + ABS(XAVGC13.14 >= XAVGC34.14 OR XAVGC13.15 < XAVGC34.15) * (ABS(XAVGC13.15 < XAVGC34.15 AND XAVGC13.16 >= XAVGC34.16) * C15 + ABS(XAVGC13.15 >= XAVGC34.15 OR XAVGC13.16 < XAVGC34.16) * (ABS(XAVGC13.16 < XAVGC34.16 AND XAVGC13.17 >= XAVGC34.17) * C16 + ABS(XAVGC13.16 >= XAVGC34.16 OR XAVGC13.17 < XAVGC34.17) * (ABS(XAVGC13.17 < XAVGC34.17 AND XAVGC13.18 >= XAVGC34.18) * C17 + ABS(XAVGC13.17 >= XAVGC34.17 OR XAVGC13.18 < XAVGC34.18) * (ABS(XAVGC13.18 < XAVGC34.18 AND XAVGC13.19 >= XAVGC34.19) * C18 + ABS(XAVGC13.18 >= XAVGC34.18 OR XAVGC13.19 < XAVGC34.19) * (ABS(XAVGC13.19 < XAVGC34.19 AND XAVGC13.20 >= XAVGC34.20) * C19 + ABS(XAVGC13.19 >= XAVGC34.19 OR XAVGC13.20 < XAVGC34.20) * (ABS(XAVGC13.20 < XAVGC34.20 AND XAVGC13.21 >= XAVGC34.21) * C20 + ABS(XAVGC13.20 >= XAVGC34.20 OR XAVGC13.21 < XAVGC34.21) * (ABS(XAVGC13.21 < XAVGC34.21 AND XAVGC13.22 >= XAVGC34.22) * C21 + ABS(XAVGC13.21 >= XAVGC34.21 OR XAVGC13.22 < XAVGC34.22) * (ABS(XAVGC13.22 < XAVGC34.22 AND XAVGC13.23 >= XAVGC34.23) * C22 + ABS(XAVGC13.22 >= XAVGC34.22 OR XAVGC13.23 < XAVGC34.23) * (ABS(XAVGC13.23 < XAVGC34.23 AND XAVGC13.24 >= XAVGC34.24) * C23 + ABS(XAVGC13.23 >= XAVGC34.23 OR XAVGC13.24 < XAVGC34.24) * (ABS(XAVGC13.24 < XAVGC34.24 AND XAVGC13.25 >= XAVGC34.25) * C24 + ABS(XAVGC13.24 >= XAVGC34.24 OR XAVGC13.25 < XAVGC34.25) * (ABS(XAVGC13.25 < XAVGC34.25 AND XAVGC13.26 >= XAVGC34.26) * C25 + ABS(XAVGC13.25 >= XAVGC34.25 OR XAVGC13.26 < XAVGC34.26) * (ABS(XAVGC13.26 < XAVGC34.26 AND XAVGC13.27 >= XAVGC34.27) * C26 + ABS(XAVGC13.26 >= XAVGC34.26 OR XAVGC13.27 < XAVGC34.27) * (ABS(XAVGC13.27 < XAVGC34.27 AND XAVGC13.28 >= XAVGC34.28) * C27 + ABS(XAVGC13.27 >= XAVGC34.27 OR XAVGC13.28 < XAVGC34.28) * (ABS(XAVGC13.28 < XAVGC34.28 AND XAVGC13.29 >= XAVGC34.29) * C28 + ABS(XAVGC13.28 >= XAVGC34.28 OR XAVGC13.29 < XAVGC34.29) * (ABS(XAVGC13.29 < XAVGC34.29 AND XAVGC13.30 >= XAVGC34.30) * C29 + ABS(XAVGC13.29 >= XAVGC34.29 OR XAVGC13.30 < XAVGC34.30) * (ABS(XAVGC13.30 < XAVGC34.30 AND XAVGC13.31 >= XAVGC34.31) * C30 + ABS(XAVGC13.30 >= XAVGC34.30 OR XAVGC13.31 < XAVGC34.31) * (ABS(XAVGC13.31 < XAVGC34.31 AND XAVGC13.32 >= XAVGC34.32) * C31 + ABS(XAVGC13.31 >= XAVGC34.31 OR XAVGC13.32 < XAVGC34.32) * (ABS(XAVGC13.32 < XAVGC34.32 AND XAVGC13.33 >= XAVGC34.33) * C32 + ABS(XAVGC13.32 >= XAVGC34.32 OR XAVGC13.33 < XAVGC34.33) * (ABS(XAVGC13.33 < XAVGC34.33 AND XAVGC13.34 >= XAVGC34.34) * C33 + ABS(XAVGC13.33 >= XAVGC34.33 OR XAVGC13.34 < XAVGC34.34) * (ABS(XAVGC13.34 < XAVGC34.34 AND XAVGC13.35 >= XAVGC34.35) * C34 + ABS(XAVGC13.34 >= XAVGC34.34 OR XAVGC13.35 < XAVGC34.35) * (ABS(XAVGC13.35 < XAVGC34.35 AND XAVGC13.36 >= XAVGC34.36) * C35 + ABS(XAVGC13.35 >= XAVGC34.35 OR XAVGC13.36 < XAVGC34.36) * (ABS(XAVGC13.36 < XAVGC34.36 AND XAVGC13.37 >= XAVGC34.37) * C36 + ABS(XAVGC13.36 >= XAVGC34.36 OR XAVGC13.37 < XAVGC34.37) * (ABS(XAVGC13.37 < XAVGC34.37 AND XAVGC13.38 >= XAVGC34.38) * C37 + ABS(XAVGC13.37 >= XAVGC34.37 OR XAVGC13.38 < XAVGC34.38) * (ABS(XAVGC13.38 < XAVGC34.38 AND XAVGC13.39 >= XAVGC34.39) * C38 + ABS(XAVGC13.38 >= XAVGC34.38 OR XAVGC13.39 < XAVGC34.39) * (ABS(XAVGC13.39 < XAVGC34.39 AND XAVGC13.40 >= XAVGC34.40) * C39 + ABS(XAVGC13.39 >= XAVGC34.39 OR XAVGC13.40 < XAVGC34.40) * (ABS(XAVGC13.40 < XAVGC34.40 AND XAVGC13.41 >= XAVGC34.41) * C40 + ABS(XAVGC13.40 >= XAVGC34.40 OR XAVGC13.41 < XAVGC34.41) * (ABS(XAVGC13.41 < XAVGC34.41 AND XAVGC13.42 >= XAVGC34.42) * C41 + ABS(XAVGC13.41 >= XAVGC34.41 OR XAVGC13.42 < XAVGC34.42) * (ABS(XAVGC13.42 < XAVGC34.42 AND XAVGC13.43 >= XAVGC34.43) * C42 + ABS(XAVGC13.42 >= XAVGC34.42 OR XAVGC13.43 < XAVGC34.43) * (ABS(XAVGC13.43 < XAVGC34.43 AND XAVGC13.44 >= XAVGC34.44) * C43 + ABS(XAVGC13.43 >= XAVGC34.43 OR XAVGC13.44 < XAVGC34.44) * (ABS(XAVGC13.44 < XAVGC34.44 AND XAVGC13.45 >= XAVGC34.45) * C44 + ABS(XAVGC13.44 >= XAVGC34.44 OR XAVGC13.45 < XAVGC34.45) * (ABS(XAVGC13.45 < XAVGC34.45 AND XAVGC13.46 >= XAVGC34.46) * C45 + ABS(XAVGC13.45 >= XAVGC34.45 OR XAVGC13.46 < XAVGC34.46) * (ABS(XAVGC13.46 < XAVGC34.46 AND XAVGC13.47 >= XAVGC34.47) * C46 + ABS(XAVGC13.46 >= XAVGC34.46 OR XAVGC13.47 < XAVGC34.47) * (ABS(XAVGC13.47 < XAVGC34.47 AND XAVGC13.48 >= XAVGC34.48) * C47 + ABS(XAVGC13.47 >= XAVGC34.47 OR XAVGC13.48 < XAVGC34.48) * (ABS(XAVGC13.48 < XAVGC34.48 AND XAVGC13.49 >= XAVGC34.49) * C48 + ABS(XAVGC13.48 >= XAVGC34.48 OR XAVGC13.49 < XAVGC34.49) * (ABS(XAVGC13.49 < XAVGC34.49 AND XAVGC13.50 >= XAVGC34.50) * C49 + ABS(XAVGC13.49 >= XAVGC34.49 OR XAVGC13.50 < XAVGC34.50) * (ABS(XAVGC13.50 < XAVGC34.50 AND XAVGC13.51 >= XAVGC34.51) * C50 + ABS(XAVGC13.50 >= XAVGC34.50 OR XAVGC13.51 < XAVGC34.51) * (ABS(XAVGC13.51 < XAVGC34.51 AND XAVGC13.52 >= XAVGC34.52) * C51 + ABS(XAVGC13.51 >= XAVGC34.51 OR XAVGC13.52 < XAVGC34.52) * (ABS(XAVGC13.52 < XAVGC34.52 AND XAVGC13.53 >= XAVGC34.53) * C52 + ABS(XAVGC13.52 >= XAVGC34.52 OR XAVGC13.53 < XAVGC34.53) * (ABS(XAVGC13.53 < XAVGC34.53 AND XAVGC13.54 >= XAVGC34.54) * C53 + ABS(XAVGC13.53 >= XAVGC34.53 OR XAVGC13.54 < XAVGC34.54) * (ABS(XAVGC13.54 < XAVGC34.54 AND XAVGC13.55 >= XAVGC34.55) * C54 + ABS(XAVGC13.54 >= XAVGC34.54 OR XAVGC13.55 < XAVGC34.55) * (ABS(XAVGC13.55 < XAVGC34.55 AND XAVGC13.56 >= XAVGC34.56) * C55 + ABS(XAVGC13.55 >= XAVGC34.55 OR XAVGC13.56 < XAVGC34.56) * (ABS(XAVGC13.56 < XAVGC34.56 AND XAVGC13.57 >= XAVGC34.57) * C56 + ABS(XAVGC13.56 >= XAVGC34.56 OR XAVGC13.57 < XAVGC34.57) * (ABS(XAVGC13.57 < XAVGC34.57 AND XAVGC13.58 >= XAVGC34.58) * C57 + ABS(XAVGC13.57 >= XAVGC34.57 OR XAVGC13.58 < XAVGC34.58) * (ABS(XAVGC13.58 < XAVGC34.58 AND XAVGC13.59 >= XAVGC34.59) * C58 + ABS(XAVGC13.58 >= XAVGC34.58 OR XAVGC13.59 < XAVGC34.59) * (ABS(XAVGC13.59 < XAVGC34.59 AND XAVGC13.60 >= XAVGC34.60) * C59 + ABS(XAVGC13.59 >= XAVGC34.59 OR XAVGC13.60 < XAVGC34.60) * (ABS(XAVGC13.60 < XAVGC34.60 AND XAVGC13.61 >= XAVGC34.61) * C60 + ABS(XAVGC13.60 >= XAVGC34.60 OR XAVGC13.61 < XAVGC34.61) * (ABS(XAVGC13.61 < XAVGC34.61 AND XAVGC13.62 >= XAVGC34.62) * C61 + ABS(XAVGC13.61 >= XAVGC34.61 OR XAVGC13.62 < XAVGC34.62) * (ABS(XAVGC13.62 < XAVGC34.62 AND XAVGC13.63 >= XAVGC34.63) * C62 + ABS(XAVGC13.62 >= XAVGC34.62 OR XAVGC13.63 < XAVGC34.63) * (ABS(XAVGC13.63 < XAVGC34.63 AND XAVGC13.64 >= XAVGC34.64) * C63 + ABS(XAVGC13.63 >= XAVGC34.63 OR XAVGC13.64 < XAVGC34.64) * (ABS(XAVGC13.64 < XAVGC34.64 AND XAVGC13.65 >= XAVGC34.65) * C64 + ABS(XAVGC13.64 >= XAVGC34.64 OR XAVGC13.65 < XAVGC34.65) * (ABS(XAVGC13.65 < XAVGC34.65 AND XAVGC13.66 >= XAVGC34.66) * C65 + ABS(XAVGC13.65 >= XAVGC34.65 OR XAVGC13.66 < XAVGC34.66) * (ABS(XAVGC13.66 < XAVGC34.66 AND XAVGC13.67 >= XAVGC34.67) * C66 + ABS(XAVGC13.66 >= XAVGC34.66 OR XAVGC13.67 < XAVGC34.67) * (ABS(XAVGC13.67 < XAVGC34.67 AND XAVGC13.68 >= XAVGC34.68) * C67 + ABS(XAVGC13.67 >= XAVGC34.67 OR XAVGC13.68 < XAVGC34.68) * (ABS(XAVGC13.68 < XAVGC34.68 AND XAVGC13.69 >= XAVGC34.69) * C68 + ABS(XAVGC13.68 >= XAVGC34.68 OR XAVGC13.69 < XAVGC34.69) * (ABS(XAVGC13.69 < XAVGC34.69 AND XAVGC13.70 >= XAVGC34.70) * C69 + ABS(XAVGC13.69 >= XAVGC34.69 OR XAVGC13.70 < XAVGC34.70) * (ABS(XAVGC13.70 < XAVGC34.70 AND XAVGC13.71 >= XAVGC34.71) * C70 + ABS(XAVGC13.70 >= XAVGC34.70 OR XAVGC13.71 < XAVGC34.71) * (ABS(XAVGC13.71 < XAVGC34.71 AND XAVGC13.72 >= XAVGC34.72) * C71 + ABS(XAVGC13.71 >= XAVGC34.71 OR XAVGC13.72 < XAVGC34.72) * (ABS(XAVGC13.72 < XAVGC34.72 AND XAVGC13.73 >= XAVGC34.73) * C72 + ABS(XAVGC13.72 >= XAVGC34.72 OR XAVGC13.73 < XAVGC34.73) * (ABS(XAVGC13.73 < XAVGC34.73 AND XAVGC13.74 >= XAVGC34.74) * C73 + ABS(XAVGC13.73 >= XAVGC34.73 OR XAVGC13.74 < XAVGC34.74) * (ABS(XAVGC13.74 < XAVGC34.74 AND XAVGC13.75 >= XAVGC34.75) * C74 + ABS(XAVGC13.74 >= XAVGC34.74 OR XAVGC13.75 < XAVGC34.75) * (ABS(XAVGC13.75 < XAVGC34.75 AND XAVGC13.76 >= XAVGC34.76) * C75 + ABS(XAVGC13.75 >= XAVGC34.75 OR XAVGC13.76 < XAVGC34.76) * (ABS(XAVGC13.76 < XAVGC34.76 AND XAVGC13.77 >= XAVGC34.77) * C76 + ABS(XAVGC13.76 >= XAVGC34.76 OR XAVGC13.77 < XAVGC34.77) * (ABS(XAVGC13.77 < XAVGC34.77 AND XAVGC13.78 >= XAVGC34.78) * C77 + ABS(XAVGC13.77 >= XAVGC34.77 OR XAVGC13.78 < XAVGC34.78) * (ABS(XAVGC13.78 < XAVGC34.78 AND XAVGC13.79 >= XAVGC34.79) * C78 + ABS(XAVGC13.78 >= XAVGC34.78 OR XAVGC13.79 < XAVGC34.79) * (ABS(XAVGC13.79 < XAVGC34.79 AND XAVGC13.80 >= XAVGC34.80) * C79 + ABS(XAVGC13.79 >= XAVGC34.79 OR XAVGC13.80 < XAVGC34.80) * (ABS(XAVGC13.80 < XAVGC34.80 AND XAVGC13.81 >= XAVGC34.81) * C80 + ABS(XAVGC13.80 >= XAVGC34.80 OR XAVGC13.81 < XAVGC34.81) * (ABS(XAVGC13.81 < XAVGC34.81 AND XAVGC13.82 >= XAVGC34.82) * C81 + ABS(XAVGC13.81 >= XAVGC34.81 OR XAVGC13.82 < XAVGC34.82) * (ABS(XAVGC13.82 < XAVGC34.82 AND XAVGC13.83 >= XAVGC34.83) * C82 + ABS(XAVGC13.82 >= XAVGC34.82 OR XAVGC13.83 < XAVGC34.83) * (ABS(XAVGC13.83 < XAVGC34.83 AND XAVGC13.84 >= XAVGC34.84) * C83 + ABS(XAVGC13.83 >= XAVGC34.83 OR XAVGC13.84 < XAVGC34.84) * (ABS(XAVGC13.84 < XAVGC34.84 AND XAVGC13.85 >= XAVGC34.85) * C84 + ABS(XAVGC13.84 >= XAVGC34.84 OR XAVGC13.85 < XAVGC34.85) * (ABS(XAVGC13.85 < XAVGC34.85 AND XAVGC13.86 >= XAVGC34.86) * C85 + ABS(XAVGC13.85 >= XAVGC34.85 OR XAVGC13.86 < XAVGC34.86) * (ABS(XAVGC13.86 < XAVGC34.86 AND XAVGC13.87 >= XAVGC34.87) * C86 + ABS(XAVGC13.86 >= XAVGC34.86 OR XAVGC13.87 < XAVGC34.87) * (ABS(XAVGC13.87 < XAVGC34.87 AND XAVGC13.88 >= XAVGC34.88) * C87 + ABS(XAVGC13.87 >= XAVGC34.87 OR XAVGC13.88 < XAVGC34.88) * (ABS(XAVGC13.88 < XAVGC34.88 AND XAVGC13.89 >= XAVGC34.89) * C88 + ABS(XAVGC13.88 >= XAVGC34.88 OR XAVGC13.89 < XAVGC34.89) * (ABS(XAVGC13.89 < XAVGC34.89 AND XAVGC13.90 >= XAVGC34.90) * C89 + ABS(XAVGC13.89 >= XAVGC34.89 OR XAVGC13.90 < XAVGC34.90) * (ABS(XAVGC13.90 < XAVGC34.90 AND XAVGC13.91 >= XAVGC34.91) * C90 + ABS(XAVGC13.90 >= XAVGC34.90 OR XAVGC13.91 < XAVGC34.91) * (ABS(XAVGC13.91 < XAVGC34.91 AND XAVGC13.92 >= XAVGC34.92) * C91 + ABS(XAVGC13.91 >= XAVGC34.91 OR XAVGC13.92 < XAVGC34.92) * (ABS(XAVGC13.92 < XAVGC34.92 AND XAVGC13.93 >= XAVGC34.93) * C92 + ABS(XAVGC13.92 >= XAVGC34.92 OR XAVGC13.93 < XAVGC34.93) * (ABS(XAVGC13.93 < XAVGC34.93 AND XAVGC13.94 >= XAVGC34.94) * C93 + ABS(XAVGC13.93 >= XAVGC34.93 OR XAVGC13.94 < XAVGC34.94) * (ABS(XAVGC13.94 < XAVGC34.94 AND XAVGC13.95 >= XAVGC34.95) * C94 + ABS(XAVGC13.94 >= XAVGC34.94 OR XAVGC13.95 < XAVGC34.95) * (ABS(XAVGC13.95 < XAVGC34.95 AND XAVGC13.96 >= XAVGC34.96) * C95 + ABS(XAVGC13.95 >= XAVGC34.95 OR XAVGC13.96 < XAVGC34.96) * (ABS(XAVGC13.96 < XAVGC34.96 AND XAVGC13.97 >= XAVGC34.97) * C96 + ABS(XAVGC13.96 >= XAVGC34.96 OR XAVGC13.97 < XAVGC34.97) * (ABS(XAVGC13.97 < XAVGC34.97 AND XAVGC13.98 >= XAVGC34.98) * C97 + ABS(XAVGC13.97 >= XAVGC34.97 OR XAVGC13.98 < XAVGC34.98) * (ABS(XAVGC13.98 < XAVGC34.98 AND XAVGC13.99 >= XAVGC34.99) * C98 + ABS(XAVGC13.98 >= XAVGC34.98 OR XAVGC13.99 < XAVGC34.99) * (ABS(XAVGC13.99 < XAVGC34.99 AND XAVGC13.100 >= XAVGC34.100) * C99 + ABS(XAVGC13.99 >= XAVGC34.99 OR XAVGC13.100 < XAVGC34.100) * (ABS(XAVGC13.100 < XAVGC34.100 AND XAVGC13.101 >= XAVGC34.101) * C100 + ABS(XAVGC13.100 >= XAVGC34.100 OR XAVGC13.101 < XAVGC34.101) * (ABS(XAVGC13.101 < XAVGC34.101 AND XAVGC13.102 >= XAVGC34.102) * C101 + ABS(XAVGC13.101 >= XAVGC34.101 OR XAVGC13.102 < XAVGC34.102) * (ABS(XAVGC13.102 < XAVGC34.102 AND XAVGC13.103 >= XAVGC34.103) * C102 + ABS(XAVGC13.102 >= XAVGC34.102 OR XAVGC13.103 < XAVGC34.103) * (ABS(XAVGC13.103 < XAVGC34.103 AND XAVGC13.104 >= XAVGC34.104) * C103 + ABS(XAVGC13.103 >= XAVGC34.103 OR XAVGC13.104 < XAVGC34.104) * (ABS(XAVGC13.104 < XAVGC34.104 AND XAVGC13.105 >= XAVGC34.105) * C104))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - .96) <= .01

THX a million, appreciate it. I might have to bother you for further assistance . If only I could find that $500M powerball that I misplaced so I could share and give you 75% of it for your assistance, :)

You're welcome.