Hi

Is there a condition formula that can scan  when sma10 crossed the sma50, then I want to use the high of this crossing day  as my pivot point.  but I just want to scan or create an alert for individual stocks in my watchlist for when it price pass this pivot point with high volume. thanks

We can probably use the techniques in the Days Since Last Peak (or other day-counting needs) topic for this, but the formula is going to be quite long and limited in how far back it can looks for the cross between the SMA10 and SMA50.

How many bars back to you need to be able to look for the cross between the SMA10 and SMA50?

Does the direction of the cross between the SMA10 and SMA50 matter?

What constitutes high volume? Would something like twice the average volume over the most recent 10 bars work or do you want something else?

Does the direction of the cross between price and the pivot point matter? The formula will be about twice as long if it does (meaning the lookback would need to be shorter).

I want the use a least 10 days after the crossed.(sma10 cross up sma50)

and volume 40% above 50 day moving average on any of these 10 days

and the high point in the day the two average cross as my pivot point.

 I just want to scan or create an alert for individual stocks in my watchlist for when it price pass this pivot point with high volume(40% above 50 day moving average)

The following Indicator Formula will plot your pivot on the chart as long as SMA10 crossed up SMA50 during the most recent 60 bars (it will drop to 0 after 60 bars).

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

The following Condition Formula should return true if price crossed through this value between the previous close and the current bar or if this value intersects the current bar and volume is at least 40% above its own SMA50.

ABS(ABS(AVGC10 > AVGC50 AND AVGC10.1 <= AVGC50.1) * H + ABS(AVGC10 <= AVGC50 OR AVGC10.1 > AVGC50.1) * (ABS(AVGC10.1 > AVGC50.1 AND AVGC10.2 <= AVGC50.2) * H1 + ABS(AVGC10.1 <= AVGC50.1 OR AVGC10.2 > AVGC50.2) * (ABS(AVGC10.2 > AVGC50.2 AND AVGC10.3 <= AVGC50.3) * H2 + ABS(AVGC10.2 <= AVGC50.2 OR AVGC10.3 > AVGC50.3) * (ABS(AVGC10.3 > AVGC50.3 AND AVGC10.4 <= AVGC50.4) * H3 + ABS(AVGC10.3 <= AVGC50.3 OR AVGC10.4 > AVGC50.4) * (ABS(AVGC10.4 > AVGC50.4 AND AVGC10.5 <= AVGC50.5) * H4 + ABS(AVGC10.4 <= AVGC50.4 OR AVGC10.5 > AVGC50.5) * (ABS(AVGC10.5 > AVGC50.5 AND AVGC10.6 <= AVGC50.6) * H5 + ABS(AVGC10.5 <= AVGC50.5 OR AVGC10.6 > AVGC50.6) * (ABS(AVGC10.6 > AVGC50.6 AND AVGC10.7 <= AVGC50.7) * H6 + ABS(AVGC10.6 <= AVGC50.6 OR AVGC10.7 > AVGC50.7) * (ABS(AVGC10.7 > AVGC50.7 AND AVGC10.8 <= AVGC50.8) * H7 + ABS(AVGC10.7 <= AVGC50.7 OR AVGC10.8 > AVGC50.8) * (ABS(AVGC10.8 > AVGC50.8 AND AVGC10.9 <= AVGC50.9) * H8 + ABS(AVGC10.8 <= AVGC50.8 OR AVGC10.9 > AVGC50.9) * (ABS(AVGC10.9 > AVGC50.9 AND AVGC10.10 <= AVGC50.10) * H9 + ABS(AVGC10.9 <= AVGC50.9 OR AVGC10.10 > AVGC50.10) * (ABS(AVGC10.10 > AVGC50.10 AND AVGC10.11 <= AVGC50.11) * H10 + ABS(AVGC10.10 <= AVGC50.10 OR AVGC10.11 > AVGC50.11) * (ABS(AVGC10.11 > AVGC50.11 AND AVGC10.12 <= AVGC50.12) * H11 + ABS(AVGC10.11 <= AVGC50.11 OR AVGC10.12 > AVGC50.12) * (ABS(AVGC10.12 > AVGC50.12 AND AVGC10.13 <= AVGC50.13) * H12 + ABS(AVGC10.12 <= AVGC50.12 OR AVGC10.13 > AVGC50.13) * (ABS(AVGC10.13 > AVGC50.13 AND AVGC10.14 <= AVGC50.14) * H13 + ABS(AVGC10.13 <= AVGC50.13 OR AVGC10.14 > AVGC50.14) * (ABS(AVGC10.14 > AVGC50.14 AND AVGC10.15 <= AVGC50.15) * H14 + ABS(AVGC10.14 <= AVGC50.14 OR AVGC10.15 > AVGC50.15) * (ABS(AVGC10.15 > AVGC50.15 AND AVGC10.16 <= AVGC50.16) * H15 + ABS(AVGC10.15 <= AVGC50.15 OR AVGC10.16 > AVGC50.16) * (ABS(AVGC10.16 > AVGC50.16 AND AVGC10.17 <= AVGC50.17) * H16 + ABS(AVGC10.16 <= AVGC50.16 OR AVGC10.17 > AVGC50.17) * (ABS(AVGC10.17 > AVGC50.17 AND AVGC10.18 <= AVGC50.18) * H17 + ABS(AVGC10.17 <= AVGC50.17 OR AVGC10.18 > AVGC50.18) * (ABS(AVGC10.18 > AVGC50.18 AND AVGC10.19 <= AVGC50.19) * H18 + ABS(AVGC10.18 <= AVGC50.18 OR AVGC10.19 > AVGC50.19) * (ABS(AVGC10.19 > AVGC50.19 AND AVGC10.20 <= AVGC50.20) * H19 + ABS(AVGC10.19 <= AVGC50.19 OR AVGC10.20 > AVGC50.20) * (ABS(AVGC10.20 > AVGC50.20 AND AVGC10.21 <= AVGC50.21) * H20 + ABS(AVGC10.20 <= AVGC50.20 OR AVGC10.21 > AVGC50.21) * (ABS(AVGC10.21 > AVGC50.21 AND AVGC10.22 <= AVGC50.22) * H21 + ABS(AVGC10.21 <= AVGC50.21 OR AVGC10.22 > AVGC50.22) * (ABS(AVGC10.22 > AVGC50.22 AND AVGC10.23 <= AVGC50.23) * H22 + ABS(AVGC10.22 <= AVGC50.22 OR AVGC10.23 > AVGC50.23) * (ABS(AVGC10.23 > AVGC50.23 AND AVGC10.24 <= AVGC50.24) * H23 + ABS(AVGC10.23 <= AVGC50.23 OR AVGC10.24 > AVGC50.24) * (ABS(AVGC10.24 > AVGC50.24 AND AVGC10.25 <= AVGC50.25) * H24 + ABS(AVGC10.24 <= AVGC50.24 OR AVGC10.25 > AVGC50.25) * (ABS(AVGC10.25 > AVGC50.25 AND AVGC10.26 <= AVGC50.26) * H25 + ABS(AVGC10.25 <= AVGC50.25 OR AVGC10.26 > AVGC50.26) * (ABS(AVGC10.26 > AVGC50.26 AND AVGC10.27 <= AVGC50.27) * H26 + ABS(AVGC10.26 <= AVGC50.26 OR AVGC10.27 > AVGC50.27) * (ABS(AVGC10.27 > AVGC50.27 AND AVGC10.28 <= AVGC50.28) * H27 + ABS(AVGC10.27 <= AVGC50.27 OR AVGC10.28 > AVGC50.28) * (ABS(AVGC10.28 > AVGC50.28 AND AVGC10.29 <= AVGC50.29) * H28 + ABS(AVGC10.28 <= AVGC50.28 OR AVGC10.29 > AVGC50.29) * (ABS(AVGC10.29 > AVGC50.29 AND AVGC10.30 <= AVGC50.30) * H29 + ABS(AVGC10.29 <= AVGC50.29 OR AVGC10.30 > AVGC50.30) * (ABS(AVGC10.30 > AVGC50.30 AND AVGC10.31 <= AVGC50.31) * H30 + ABS(AVGC10.30 <= AVGC50.30 OR AVGC10.31 > AVGC50.31) * (ABS(AVGC10.31 > AVGC50.31 AND AVGC10.32 <= AVGC50.32) * H31 + ABS(AVGC10.31 <= AVGC50.31 OR AVGC10.32 > AVGC50.32) * (ABS(AVGC10.32 > AVGC50.32 AND AVGC10.33 <= AVGC50.33) * H32 + ABS(AVGC10.32 <= AVGC50.32 OR AVGC10.33 > AVGC50.33) * (ABS(AVGC10.33 > AVGC50.33 AND AVGC10.34 <= AVGC50.34) * H33 + ABS(AVGC10.33 <= AVGC50.33 OR AVGC10.34 > AVGC50.34) * (ABS(AVGC10.34 > AVGC50.34 AND AVGC10.35 <= AVGC50.35) * H34 + ABS(AVGC10.34 <= AVGC50.34 OR AVGC10.35 > AVGC50.35) * (ABS(AVGC10.35 > AVGC50.35 AND AVGC10.36 <= AVGC50.36) * H35 + ABS(AVGC10.35 <= AVGC50.35 OR AVGC10.36 > AVGC50.36) * (ABS(AVGC10.36 > AVGC50.36 AND AVGC10.37 <= AVGC50.37) * H36 + ABS(AVGC10.36 <= AVGC50.36 OR AVGC10.37 > AVGC50.37) * (ABS(AVGC10.37 > AVGC50.37 AND AVGC10.38 <= AVGC50.38) * H37 + ABS(AVGC10.37 <= AVGC50.37 OR AVGC10.38 > AVGC50.38) * (ABS(AVGC10.38 > AVGC50.38 AND AVGC10.39 <= AVGC50.39) * H38 + ABS(AVGC10.38 <= AVGC50.38 OR AVGC10.39 > AVGC50.39) * (ABS(AVGC10.39 > AVGC50.39 AND AVGC10.40 <= AVGC50.40) * H39 + ABS(AVGC10.39 <= AVGC50.39 OR AVGC10.40 > AVGC50.40) * (ABS(AVGC10.40 > AVGC50.40 AND AVGC10.41 <= AVGC50.41) * H40 + ABS(AVGC10.40 <= AVGC50.40 OR AVGC10.41 > AVGC50.41) * (ABS(AVGC10.41 > AVGC50.41 AND AVGC10.42 <= AVGC50.42) * H41 + ABS(AVGC10.41 <= AVGC50.41 OR AVGC10.42 > AVGC50.42) * (ABS(AVGC10.42 > AVGC50.42 AND AVGC10.43 <= AVGC50.43) * H42 + ABS(AVGC10.42 <= AVGC50.42 OR AVGC10.43 > AVGC50.43) * (ABS(AVGC10.43 > AVGC50.43 AND AVGC10.44 <= AVGC50.44) * H43 + ABS(AVGC10.43 <= AVGC50.43 OR AVGC10.44 > AVGC50.44) * (ABS(AVGC10.44 > AVGC50.44 AND AVGC10.45 <= AVGC50.45) * H44 + ABS(AVGC10.44 <= AVGC50.44 OR AVGC10.45 > AVGC50.45) * (ABS(AVGC10.45 > AVGC50.45 AND AVGC10.46 <= AVGC50.46) * H45 + ABS(AVGC10.45 <= AVGC50.45 OR AVGC10.46 > AVGC50.46) * (ABS(AVGC10.46 > AVGC50.46 AND AVGC10.47 <= AVGC50.47) * H46 + ABS(AVGC10.46 <= AVGC50.46 OR AVGC10.47 > AVGC50.47) * (ABS(AVGC10.47 > AVGC50.47 AND AVGC10.48 <= AVGC50.48) * H47 + ABS(AVGC10.47 <= AVGC50.47 OR AVGC10.48 > AVGC50.48) * (ABS(AVGC10.48 > AVGC50.48 AND AVGC10.49 <= AVGC50.49) * H48 + ABS(AVGC10.48 <= AVGC50.48 OR AVGC10.49 > AVGC50.49) * (ABS(AVGC10.49 > AVGC50.49 AND AVGC10.50 <= AVGC50.50) * H49 + ABS(AVGC10.49 <= AVGC50.49 OR AVGC10.50 > AVGC50.50) * (ABS(AVGC10.50 > AVGC50.50 AND AVGC10.51 <= AVGC50.51) * H50 + ABS(AVGC10.50 <= AVGC50.50 OR AVGC10.51 > AVGC50.51) * (ABS(AVGC10.51 > AVGC50.51 AND AVGC10.52 <= AVGC50.52) * H51 + ABS(AVGC10.51 <= AVGC50.51 OR AVGC10.52 > AVGC50.52) * (ABS(AVGC10.52 > AVGC50.52 AND AVGC10.53 <= AVGC50.53) * H52 + ABS(AVGC10.52 <= AVGC50.52 OR AVGC10.53 > AVGC50.53) * (ABS(AVGC10.53 > AVGC50.53 AND AVGC10.54 <= AVGC50.54) * H53 + ABS(AVGC10.53 <= AVGC50.53 OR AVGC10.54 > AVGC50.54) * (ABS(AVGC10.54 > AVGC50.54 AND AVGC10.55 <= AVGC50.55) * H54 + ABS(AVGC10.54 <= AVGC50.54 OR AVGC10.55 > AVGC50.55) * (ABS(AVGC10.55 > AVGC50.55 AND AVGC10.56 <= AVGC50.56) * H55 + ABS(AVGC10.55 <= AVGC50.55 OR AVGC10.56 > AVGC50.56) * (ABS(AVGC10.56 > AVGC50.56 AND AVGC10.57 <= AVGC50.57) * H56 + ABS(AVGC10.56 <= AVGC50.56 OR AVGC10.57 > AVGC50.57) * (ABS(AVGC10.57 > AVGC50.57 AND AVGC10.58 <= AVGC50.58) * H57 + ABS(AVGC10.57 <= AVGC50.57 OR AVGC10.58 > AVGC50.58) * (ABS(AVGC10.58 > AVGC50.58 AND AVGC10.59 <= AVGC50.59) * H58 + ABS(AVGC10.58 <= AVGC50.58 OR AVGC10.59 > AVGC50.59) * (ABS(AVGC10.59 > AVGC50.59 AND AVGC10.60 <= AVGC50.60) * H59))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - (H + L + 2 * C1 + ABS(H - C1) - ABS(C1 - L)) / 4) <= (H - L + ABS(H - C1) + ABS(C1 - L)) / 4 AND V >= 1.4 * AVGV50

thank you so much for the help

You're welcome.