Worden Discussion Forum

Registered User
Joined: 8/23/2013
Posts: 245

Forgot to ask what is the max Look Back (i would assume 500 - but that might be the part that makes the formula too long)

IF that is not the Long factor then

Uptrend Begin Point Formula: L / ABS(L = MINL20 AND L = MINL78)

Uptrend End Point Formula: H / ABS(H = MAXH20 AND H = MAXH78)

AND

Downtrend Begin Point Formula: H / ABS(H = MAXH20 AND H = MAXH78)

Downtrend End Point Formula: L / ABS(L = MINL20 AND L = MINL78)

Registered User
Joined: 8/23/2013
Posts: 245

QUOTE (Bruce_L)

I absolutely cannot create a formulas short enough to be practical which sets the beginning point of an uptrend as the most recent point where L = MINL20 AND L = MINL78 and the end of the uptrend as the highest high since then (for the reasons already described above).

The same is true of setting the beginning point of a downtrend as the most recent point where H = MAXH20 AND H = MAXH78 and the end of the downtrend as the lowest low since then.

We might be able to connect the most recent low where L = MINL20 and L = MINL78 to the most recent point where H = MAXH20 AND H = MAXH78, but only if we set a maximum number of bars to look back for the recent occurance of both. I don't know how long we can set such a lookback. Some quick experiments would lead me to believe it will be too short for what you want to do however.

You can plot the following Custom PCF Indicator in the same pane and scale as price to see where the various low endpoints would be plotted as this doesn't require the long formulas.

- Plot Style: Dot
- Period: 1
- Average Type: Doesn't matter.
- Formula: L / ABS(L = MINL20 AND L = MINL78)

And the following Custom PCF Indicator in the same pane and scale as price to see where the various high endpoints would be plotted.

- Plot Style: Dot
- Period: 1
- Average Type: Doesn't matter.
- Formula: H / ABS(H = MAXH20 AND H = MAXH78)

The long formula part which may or may not be possible comes from trying to connect the dots.

Yes this would be plotting the lines as they were designed to be plotted

I am assuming the dots have to be connected to the be able to plot the 2/3 and 1/3 counterparts, as they are the important plots - The Origin Plot is just the means to the end - the 2/3 and 1/3 are the important lines needed (That being said in case the 2/3 and 1/3 lines can be plotted with a lesser length formula)

Thanks for all the help

Registered User
Joined: 8/23/2013
Posts: 245

QUOTE (MoreAces)

Perfect Uptrend Begin Point Formula: L / ABS(L = MINL20 AND L = MINL78)

The End Point would remain as is now

Perfect Downtren Begin Poin Formula: H / ABS(H = MAXH20 AND H = MAXH78)

The End Point would remain as is now

IF the Connecting of the dots is what requires the Long Look Back and The Above would not then possible this could work

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

It ends up turning out that I can't create the formula in a fashion that is fast enough to be practical or post in the forums.

The reason is that determining how many bars since the current 78 bar low was made repeats the same 78 bar low calculation 78 times and only needs to be done once as a result.

ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

But if we need to know how many bars it has been since the low was the 78 bar at the time (instead of the current 78 bar low), we need to calculate a different 78 bar low for every bar. That means the further I can go out and still post even just that part of the formula in the forums is to 58 bars ago.

ABS(L > MINL78) * (ABS(L1 = MINL78.1) * 1 + ABS(L1 > MINL78.1) * (ABS(L2 = MINL78.2) * 2 + ABS(L2 > MINL78.2) * (ABS(L3 = MINL78.3) * 3 + ABS(L3 > MINL78.3) * (ABS(L4 = MINL78.4) * 4 + ABS(L4 > MINL78.4) * (ABS(L5 = MINL78.5) * 5 + ABS(L5 > MINL78.5) * (ABS(L6 = MINL78.6) * 6 + ABS(L6 > MINL78.6) * (ABS(L7 = MINL78.7) * 7 + ABS(L7 > MINL78.7) * (ABS(L8 = MINL78.8) * 8 + ABS(L8 > MINL78.8) * (ABS(L9 = MINL78.9) * 9 + ABS(L9 > MINL78.9) * (ABS(L10 = MINL78.10) * 10 + ABS(L10 > MINL78.10) * (ABS(L11 = MINL78.11) * 11 + ABS(L11 > MINL78.11) * (ABS(L12 = MINL78.12) * 12 + ABS(L12 > MINL78.12) * (ABS(L13 = MINL78.13) * 13 + ABS(L13 > MINL78.13) * (ABS(L14 = MINL78.14) * 14 + ABS(L14 > MINL78.14) * (ABS(L15 = MINL78.15) * 15 + ABS(L15 > MINL78.15) * (ABS(L16 = MINL78.16) * 16 + ABS(L16 > MINL78.16) * (ABS(L17 = MINL78.17) * 17 + ABS(L17 > MINL78.17) * (ABS(L18 = MINL78.18) * 18 + ABS(L18 > MINL78.18) * (ABS(L19 = MINL78.19) * 19 + ABS(L19 > MINL78.19) * (ABS(L20 = MINL78.20) * 20 + ABS(L20 > MINL78.20) * (ABS(L21 = MINL78.21) * 21 + ABS(L21 > MINL78.21) * (ABS(L22 = MINL78.22) * 22 + ABS(L22 > MINL78.22) * (ABS(L23 = MINL78.23) * 23 + ABS(L23 > MINL78.23) * (ABS(L24 = MINL78.24) * 24 + ABS(L24 > MINL78.24) * (ABS(L25 = MINL78.25) * 25 + ABS(L25 > MINL78.25) * (ABS(L26 = MINL78.26) * 26 + ABS(L26 > MINL78.26) * (ABS(L27 = MINL78.27) * 27 + ABS(L27 > MINL78.27) * (ABS(L28 = MINL78.28) * 28 + ABS(L28 > MINL78.28) * (ABS(L29 = MINL78.29) * 29 + ABS(L29 > MINL78.29) * (ABS(L30 = MINL78.30) * 30 + ABS(L30 > MINL78.30) * (ABS(L31 = MINL78.31) * 31 + ABS(L31 > MINL78.31) * (ABS(L32 = MINL78.32) * 32 + ABS(L32 > MINL78.32) * (ABS(L33 = MINL78.33) * 33 + ABS(L33 > MINL78.33) * (ABS(L34 = MINL78.34) * 34 + ABS(L34 > MINL78.34) * (ABS(L35 = MINL78.35) * 35 + ABS(L35 > MINL78.35) * (ABS(L36 = MINL78.36) * 36 + ABS(L36 > MINL78.36) * (ABS(L37 = MINL78.37) * 37 + ABS(L37 > MINL78.37) * (ABS(L38 = MINL78.38) * 38 + ABS(L38 > MINL78.38) * (ABS(L39 = MINL78.39) * 39 + ABS(L39 > MINL78.39) * (ABS(L40 = MINL78.40) * 40 + ABS(L40 > MINL78.40) * (ABS(L41 = MINL78.41) * 41 + ABS(L41 > MINL78.41) * (ABS(L42 = MINL78.42) * 42 + ABS(L42 > MINL78.42) * (ABS(L43 = MINL78.43) * 43 + ABS(L43 > MINL78.43) * (ABS(L44 = MINL78.44) * 44 + ABS(L44 > MINL78.44) * (ABS(L45 = MINL78.45) * 45 + ABS(L45 > MINL78.45) * (ABS(L46 = MINL78.46) * 46 + ABS(L46 > MINL78.46) * (ABS(L47 = MINL78.47) * 47 + ABS(L47 > MINL78.47) * (ABS(L48 = MINL78.48) * 48 + ABS(L48 > MINL78.48) * (ABS(L49 = MINL78.49) * 49 + ABS(L49 > MINL78.49) * (ABS(L50 = MINL78.50) * 50 + ABS(L50 > MINL78.50) * (ABS(L51 = MINL78.51) * 51 + ABS(L51 > MINL78.51) * (ABS(L52 = MINL78.52) * 52 + ABS(L52 > MINL78.52) * (ABS(L53 = MINL78.53) * 53 + ABS(L53 > MINL78.53) * (ABS(L54 = MINL78.54) * 54 + ABS(L54 > MINL78.54) * (ABS(L55 = MINL78.55) * 55 + ABS(L55 > MINL78.55) * (ABS(L56 = MINL78.56) * 56 + ABS(L56 > MINL78.56) * (ABS(L57 = MINL78.57) * 57 + ABS(L57 > MINL78.57) * (ABS(L58 = MINL78.58) * 58))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

This may seem strange since the formula is actually shorter, but the it ends up being quite a bit slower.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

OK much shorter but how does this now get applied to the UPtrend Plots for the

3 uptrend slope (origin, 2/3 1/3)

3 down slope ( origiin 2/3 1/3)

And thanks

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I can't do it. The formulas given were just examples designed to explain why.

I can't even get out to 78 bars when checking for the start of either the uptrend or the downtrend using the new method.

The old method works and can go out to 78 bars because we are checking the low or high of the bar against either the current MINL78 or MAXH78.

Trying to identify the types of starts you want requires checking each bar not against the current value (so L34 gets compared to MINL78), but against the value at the time (so L34 needs to be compared to MINL78.34).

This means the method that works only needs to calculate MINL78 once even though it is in the formula 78 times.

But to identify the type of trend starts you actually want to do instead would need to calculate a different MINL78 for each bar. That would mean 78 different versions of MINL78 just to get out to the same number of bars. Going beyond even 58 bars makes just this portion of the formula too slow for me to post.

And the entire reason you would want to do this is to keep values which are older than 78 bars. This means you would ideally want the lookback to be quite a bit greater than 78 bars.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

Well thanks for all the effort AND the formula we have in tact are working out awesome (some times they give false scan results - But when i go to my chart where the Plots are smooth and still in a normal looking plot the results have been great

Thank you very much

and as always

Bruce remains the best

Registered User
Joined: 8/23/2013
Posts: 245

And is there a way to use these in formulas if rewritten calculate in a different way

H / ABS(H = MAXH20 AND H = MAXH78)

L / ABS(L = MINL20 AND L = MINL78)

When i try to use them differently i get error for divide by 0

Registered User
Joined: 8/23/2013
Posts: 245

QUOTE (Bruce_L)

OK. Let's take a look at the speed line running from the high of Thursday 6/4/2015 10:30:00 AM ET to the low of Tuesday 6/9/2015 11:00:00 AM ET on the 30 minute chart of FB.

A Formula which automatically plots the endpoints of the speed line is going to line up exactly with your speed line starting at the Tuesday 6/9/2015 11:00:00 AM ET low. It will be able to continue drawing the speed line until the purple line changes at the Friday 6/12/2015 10:30:00 AM bar when the Thursday 6/4/2015 10:30:00 AM ET bar which started the speed line drops out of the equation.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1)

The 2/3 Line can also be reproduced during the exact same span of bars using the following Indicator Formula.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) * 2 / 3

And the 1 / 3 Line can be reproduced during the same exact span of time using the following Indicator Formula.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) / 3

Note that while the Speed Line formula should work in all cases, the 2/3 Line and 1/3 Line formulas should only work for downtrends (where the high comes before the low).

If you had created an alert based on being above a Custom PCF Indicator based on the 2/3 Line, it would have triggered on the Tuesday 6/9/2015 12:00:00 ET bar.

If you had created an alert based on price being above up a Custom PCF Indicator based on the 1/3 Line, it would have triggered on the Wednesday, 6/10/2015 10:30:00 AM ET bar.

so we have this working well on intraday charts

If i want to try shorter max min bars for daily etc

is there easy way for me to change numbers

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you just want Condition Formulas just use:

H = MAXH78

Or use:

L = MINL78

The AND H = MAXH20 and AND L = MINL20 portions end up being redundant. The rest of the formula is just designed to get it to plot dots on the chart when true and not plot anything at all when false (because of the division by zero).

The formulas can be shortened to use shorter periods, but I'm not sure I'd call the process easy. They were created using the techniques described in the following topic.

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

You could probably use a text editor to replace 78 with a smaller number and then delete the extra terms in the formulas already provided, but you would have to be careful with the parentheses.

We can provide the fomulas for the shorter periods as well.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

Bruce you stated you never looked at my Formula for MY plots on "30M Speed Test" Chart in My Account - MY formula stated the begin points for each of the 3 Up sloping Plots and they may (hopefully) or may not Require a look back as they plot the Begin Point of each Plot - these might actually reduce the formula alot - NOT Sure on my end

Your formulas may be exactly what these become

These formulas are where the plots actually Begin to start the upward extenson

i guess since they all start at the same point these are the end points

UP Main Plot 0.00 Line (TOP) : MINL78 - ( ( ( MAXH78 - MINL78 ) * 0.000 ) - (MAXH78 - MINL78) ) )

Up Slope 2/3 Line (Center): (MINL78 - ( ( ( MAXH78 - MINL78 ) * 0.333 ) - (MAXH78 - MINL78) ) )

Up Slope 1/3 Line (Bottom) : (MINL78 - ( ( ( MAXH78 - MINL78 ) * 0.666 ) - (MAXH78 - MINL78) ) )

Hope these could possible help . Thank again

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The problem with using your formulas as I'm sure you are already aware is that they only plot the correct values at the exact bar of the second point used to create the speedline.

To plot the correct values at any other point, you need to know the slope of the speedline and you need to know the number of bars since the first point used to draw the speedline.

To know the slope of the speedline you need to know value of the first point used to plot the speedline and the value of the second point used to plot the speedline. These are easy, MAXH78 and MINL78, only the order changes.

To calculate the slope of the speedline you also need to know how many bars are between the first point used to plot the speedline and the second point used to plot the speedline. These calculations are the long complicated part.

Once you have the slope, you can multiply it by 1/3 and 2/3 to get the slopes of the other two lines.

Now it is just a matter of determining the number of bars since the first point and adding the slope (be it of the speed line itself or the 1/3 and 2/3) times the number of bars to get the value at that point.

You already have the number of bars for the first point from the calculations used to get the slope. TC2000 doesn't have any variables, so unless you can re-arrange the formula in such a way to avoid it, you would need to calculate this value again (our existing formulas only need to calculate this value once because of the form used for the formula).

Note that the existing formulas do line up with your formulas exactly as long as you use the correct formula (depending on if MAXH78 or MINL78 happened first).

Also note that your formulas do not work in cases where the existing formulas do not work. If my formulas work so do yours (at least at the correct points) and if your formulas work so do mine.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

Begin Bar ALL Lines : (MINL78 - ( ( ( MAXH78 - MINL78 ) * 1.00 ) - (MAXH78 - MINL78) ) )

does this help

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

No, it doesn't really help. Calculating the values of the various levels at the end point of the speedline is fairly straightforward.

In an uptrend:

End Value (3/3) = MAXH78
2/3 Value = (MINL78 + 2 * MAXH78) / 3
1/3 Value = (2 * MINL78 + MAXH78) / 3
Start Value (0/3) = MINL78

And in a downtrend:

Start Value (0/3) = MAXH78
1/3 Value = (MINL78 + 2 * MAXH78) / 3
2/3 Value = (2 * MINL78 + MAXH78) / 3
End Value (3/3) = MINL78

Note that these are actually all the same values, just reversed.

But how do you calculate the value of the next bar? That is the harder part because it requires knowing the slope or change in value from one bar to the next.

Speedline Slope (3/3) = (End Value - Start Value) / (Bars Since Start - Bars Since End)
2/3 Slope = (End Value - Start Value) / (Bars Since Start - Bars Since End) * 2 / 3
1/3 Slope = (End Value - Start Value) / (Bars Since Start - Bars Since End) / 3
Start Slope (0/3) = 0

If you know the value of one of these lines at any point, you can add the slope to get the value at the next bar or subtract the slope to get the value at the previous bar.

The best point to use ends up being the start because all of the lines have the same value at the start which means you can create a single formula with a factor to define all four values at any point.

Start Value + (Bars Since Start) * Slope * Factor

Or:

Start Value + (Bars Since Start) * (End Value - Start Value) / (Bars Since Start - Bars Since End) * Facto

Where Factor = 1 for the speedline, 2/3 for the 2/3 line, 1/3 for the 1/3 line and 0 for the start.

Start Value and End Value are short. They are always going to either be MINL78 or MAXH78.

It is the Bars Since Start and Bars Since End which are the long parts of the formula if you want to calculate values at any point besides the bars where the speedline starts or ends.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

ok thanks for all the help,

Still remains awesome

Registered User
Joined: 8/23/2013
Posts: 245

i will give the shorter periods some thought

They could be used well for the intraday stocks that pop and retrace quickly

But mainly these are not great on the daily and i would think the shorter period might work better

Registered User
Joined: 8/23/2013
Posts: 245

Bruce when you can work it in your day

I would appreciate the Shorter Time Period Formulas for 20 Period and 40 Period

Thanks

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The 40 period downtrend speedline:

MAXH40 + (MAXH40 - MINL40) / ((ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) - 1)

The 40 period downtrend 2/3 line:

MAXH40 + (MAXH40 - MINL40) / ((ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) - 1) * 2 / 3

The 40 period downtrend 1/3 line:

MAXH40 + (MAXH40 - MINL40) / ((ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) - 1) / 3

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The 40 period uptrend speedline:

MINL40 + (MAXH40 - MINL40) / (1 - (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39)))))))))))))))))))))))))))))))))))))))))

The 40 period uptrend 2/3 line:

MINL40 + (MAXH40 - MINL40) / (1 - (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39))))))))))))))))))))))))))))))))))))))))) * 2 / 3

The 40 period uptrend 1/3 line:

MINL40 + (MAXH40 - MINL40) / (1 - (ABS(H < MAXH40) * (ABS(H1 = MAXH40) + ABS(H1 < MAXH40) * (ABS(H2 = MAXH40) * 2 + ABS(H2 < MAXH40) * (ABS(H3 = MAXH40) * 3 + ABS(H3 < MAXH40) * (ABS(H4 = MAXH40) * 4 + ABS(H4 < MAXH40) * (ABS(H5 = MAXH40) * 5 + ABS(H5 < MAXH40) * (ABS(H6 = MAXH40) * 6 + ABS(H6 < MAXH40) * (ABS(H7 = MAXH40) * 7 + ABS(H7 < MAXH40) * (ABS(H8 = MAXH40) * 8 + ABS(H8 < MAXH40) * (ABS(H9 = MAXH40) * 9 + ABS(H9 < MAXH40) * (ABS(H10 = MAXH40) * 10 + ABS(H10 < MAXH40) * (ABS(H11 = MAXH40) * 11 + ABS(H11 < MAXH40) * (ABS(H12 = MAXH40) * 12 + ABS(H12 < MAXH40) * (ABS(H13 = MAXH40) * 13 + ABS(H13 < MAXH40) * (ABS(H14 = MAXH40) * 14 + ABS(H14 < MAXH40) * (ABS(H15 = MAXH40) * 15 + ABS(H15 < MAXH40) * (ABS(H16 = MAXH40) * 16 + ABS(H16 < MAXH40) * (ABS(H17 = MAXH40) * 17 + ABS(H17 < MAXH40) * (ABS(H18 = MAXH40) * 18 + ABS(H18 < MAXH40) * (ABS(H19 = MAXH40) * 19 + ABS(H19 < MAXH40) * (ABS(H20 = MAXH40) * 20 + ABS(H20 < MAXH40) * (ABS(H21 = MAXH40) * 21 + ABS(H21 < MAXH40) * (ABS(H22 = MAXH40) * 22 + ABS(H22 < MAXH40) * (ABS(H23 = MAXH40) * 23 + ABS(H23 < MAXH40) * (ABS(H24 = MAXH40) * 24 + ABS(H24 < MAXH40) * (ABS(H25 = MAXH40) * 25 + ABS(H25 < MAXH40) * (ABS(H26 = MAXH40) * 26 + ABS(H26 < MAXH40) * (ABS(H27 = MAXH40) * 27 + ABS(H27 < MAXH40) * (ABS(H28 = MAXH40) * 28 + ABS(H28 < MAXH40) * (ABS(H29 = MAXH40) * 29 + ABS(H29 < MAXH40) * (ABS(H30 = MAXH40) * 30 + ABS(H30 < MAXH40) * (ABS(H31 = MAXH40) * 31 + ABS(H31 < MAXH40) * (ABS(H32 = MAXH40) * 32 + ABS(H32 < MAXH40) * (ABS(H33 = MAXH40) * 33 + ABS(H33 < MAXH40) * (ABS(H34 = MAXH40) * 34 + ABS(H34 < MAXH40) * (ABS(H35 = MAXH40) * 35 + ABS(H35 < MAXH40) * (ABS(H36 = MAXH40) * 36 + ABS(H36 < MAXH40) * (ABS(H37 = MAXH40) * 37 + ABS(H37 < MAXH40) * (ABS(H38 = MAXH40) * 38 + ABS(H38 < MAXH40) * (ABS(H39 = MAXH40) * 39)))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL40) * (ABS(L1 = MINL40) + ABS(L1 > MINL40) * (ABS(L2 = MINL40) * 2 + ABS(L2 > MINL40) * (ABS(L3 = MINL40) * 3 + ABS(L3 > MINL40) * (ABS(L4 = MINL40) * 4 + ABS(L4 > MINL40) * (ABS(L5 = MINL40) * 5 + ABS(L5 > MINL40) * (ABS(L6 = MINL40) * 6 + ABS(L6 > MINL40) * (ABS(L7 = MINL40) * 7 + ABS(L7 > MINL40) * (ABS(L8 = MINL40) * 8 + ABS(L8 > MINL40) * (ABS(L9 = MINL40) * 9 + ABS(L9 > MINL40) * (ABS(L10 = MINL40) * 10 + ABS(L10 > MINL40) * (ABS(L11 = MINL40) * 11 + ABS(L11 > MINL40) * (ABS(L12 = MINL40) * 12 + ABS(L12 > MINL40) * (ABS(L13 = MINL40) * 13 + ABS(L13 > MINL40) * (ABS(L14 = MINL40) * 14 + ABS(L14 > MINL40) * (ABS(L15 = MINL40) * 15 + ABS(L15 > MINL40) * (ABS(L16 = MINL40) * 16 + ABS(L16 > MINL40) * (ABS(L17 = MINL40) * 17 + ABS(L17 > MINL40) * (ABS(L18 = MINL40) * 18 + ABS(L18 > MINL40) * (ABS(L19 = MINL40) * 19 + ABS(L19 > MINL40) * (ABS(L20 = MINL40) * 20 + ABS(L20 > MINL40) * (ABS(L21 = MINL40) * 21 + ABS(L21 > MINL40) * (ABS(L22 = MINL40) * 22 + ABS(L22 > MINL40) * (ABS(L23 = MINL40) * 23 + ABS(L23 > MINL40) * (ABS(L24 = MINL40) * 24 + ABS(L24 > MINL40) * (ABS(L25 = MINL40) * 25 + ABS(L25 > MINL40) * (ABS(L26 = MINL40) * 26 + ABS(L26 > MINL40) * (ABS(L27 = MINL40) * 27 + ABS(L27 > MINL40) * (ABS(L28 = MINL40) * 28 + ABS(L28 > MINL40) * (ABS(L29 = MINL40) * 29 + ABS(L29 > MINL40) * (ABS(L30 = MINL40) * 30 + ABS(L30 > MINL40) * (ABS(L31 = MINL40) * 31 + ABS(L31 > MINL40) * (ABS(L32 = MINL40) * 32 + ABS(L32 > MINL40) * (ABS(L33 = MINL40) * 33 + ABS(L33 > MINL40) * (ABS(L34 = MINL40) * 34 + ABS(L34 > MINL40) * (ABS(L35 = MINL40) * 35 + ABS(L35 > MINL40) * (ABS(L36 = MINL40) * 36 + ABS(L36 > MINL40) * (ABS(L37 = MINL40) * 37 + ABS(L37 > MINL40) * (ABS(L38 = MINL40) * 38 + ABS(L38 > MINL40) * (ABS(L39 = MINL40) * 39))))))))))))))))))))))))))))))))))))))))) / 3

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The 20 period downtrend speedline:

MAXH20 + (MAXH20 - MINL20) / ((ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19)))))))))))))))))))) / (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) - 1)

The 20 period downtrend 2/3 line:

MAXH20 + (MAXH20 - MINL20) / ((ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19)))))))))))))))))))) / (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) - 1) * 2 / 3

The 20 period downtrend 1/3 line:

MAXH20 + (MAXH20 - MINL20) / ((ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19)))))))))))))))))))) / (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) - 1) / 3

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The 20 period uptrend speedline:

MINL20 + (MAXH20 - MINL20) / (1 - (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) / (ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19)))))))))))))))))))))

The 20 period uptrend 2/3 line:

MINL20 + (MAXH20 - MINL20) / (1 - (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) / (ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19))))))))))))))))))))) * 2 / 3

The 20 period uptrend 1/3 line:

MINL20 + (MAXH20 - MINL20) / (1 - (ABS(H < MAXH20) * (ABS(H1 = MAXH20) + ABS(H1 < MAXH20) * (ABS(H2 = MAXH20) * 2 + ABS(H2 < MAXH20) * (ABS(H3 = MAXH20) * 3 + ABS(H3 < MAXH20) * (ABS(H4 = MAXH20) * 4 + ABS(H4 < MAXH20) * (ABS(H5 = MAXH20) * 5 + ABS(H5 < MAXH20) * (ABS(H6 = MAXH20) * 6 + ABS(H6 < MAXH20) * (ABS(H7 = MAXH20) * 7 + ABS(H7 < MAXH20) * (ABS(H8 = MAXH20) * 8 + ABS(H8 < MAXH20) * (ABS(H9 = MAXH20) * 9 + ABS(H9 < MAXH20) * (ABS(H10 = MAXH20) * 10 + ABS(H10 < MAXH20) * (ABS(H11 = MAXH20) * 11 + ABS(H11 < MAXH20) * (ABS(H12 = MAXH20) * 12 + ABS(H12 < MAXH20) * (ABS(H13 = MAXH20) * 13 + ABS(H13 < MAXH20) * (ABS(H14 = MAXH20) * 14 + ABS(H14 < MAXH20) * (ABS(H15 = MAXH20) * 15 + ABS(H15 < MAXH20) * (ABS(H16 = MAXH20) * 16 + ABS(H16 < MAXH20) * (ABS(H17 = MAXH20) * 17 + ABS(H17 < MAXH20) * (ABS(H18 = MAXH20) * 18 + ABS(H18 < MAXH20) * (ABS(H19 = MAXH20) * 19)))))))))))))))))))) / (ABS(L > MINL20) * (ABS(L1 = MINL20) + ABS(L1 > MINL20) * (ABS(L2 = MINL20) * 2 + ABS(L2 > MINL20) * (ABS(L3 = MINL20) * 3 + ABS(L3 > MINL20) * (ABS(L4 = MINL20) * 4 + ABS(L4 > MINL20) * (ABS(L5 = MINL20) * 5 + ABS(L5 > MINL20) * (ABS(L6 = MINL20) * 6 + ABS(L6 > MINL20) * (ABS(L7 = MINL20) * 7 + ABS(L7 > MINL20) * (ABS(L8 = MINL20) * 8 + ABS(L8 > MINL20) * (ABS(L9 = MINL20) * 9 + ABS(L9 > MINL20) * (ABS(L10 = MINL20) * 10 + ABS(L10 > MINL20) * (ABS(L11 = MINL20) * 11 + ABS(L11 > MINL20) * (ABS(L12 = MINL20) * 12 + ABS(L12 > MINL20) * (ABS(L13 = MINL20) * 13 + ABS(L13 > MINL20) * (ABS(L14 = MINL20) * 14 + ABS(L14 > MINL20) * (ABS(L15 = MINL20) * 15 + ABS(L15 > MINL20) * (ABS(L16 = MINL20) * 16 + ABS(L16 > MINL20) * (ABS(L17 = MINL20) * 17 + ABS(L17 > MINL20) * (ABS(L18 = MINL20) * 18 + ABS(L18 > MINL20) * (ABS(L19 = MINL20) * 19))))))))))))))))))))) / 3

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

Thanks have a great weekend

Registered User
Joined: 8/23/2013
Posts: 245

Unrelated to this forum topic but something you shared here

Is there another way to say this

L / ABS(L = MINL20 AND L = MINL78) < L1 / ABS(L1 = MINL20.1 AND L1 = MINL78.1)

and is there another way to say this

H / ABS(H = MAXH20 AND H = MAXH78) > H1 / ABS(H1= MAXH20.1 AND H1 = MAXH78.1)

Registered User
Joined: 8/23/2013
Posts: 245

I got it - Thanks

( (L = MINL78 and L / ABS(L = MINL20 AND L = MINL78) ) AND ( L1 = MINL78.1 and L1 / ABS(L1 = MINL20.1 AND L1 = MINL78.1) ) )

Registered User
Joined: 8/23/2013
Posts: 245

Final 78 Bar Up Slope Speed Line

QUOTE (Bruce_L)

This would make the formula for the uptrend "moving" Speed Line the following.

MINL78 + (MAXH78 - MINL78) / (1 - (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

The formula for the uptrend moving 2/3 Line the following.

MINL78 + (MAXH78 - MINL78) / (1 - (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * 2 / 3

And the formula for the uptrend moving 1/3 Line the following.

MINL78 + (MAXH78 - MINL78) / (1 - (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / 3

Registered User
Joined: 8/23/2013
Posts: 245

Final 78 Down Slope Speed Line

QUOTE (Bruce_L)

This would make the formula for the downtrend "moving" Speed Line the following.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1)

The formula for the downtrend moving 2/3 Line the following.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) * 2 / 3

And the formula for the downtrend moving 1/3 Line the following.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) / 3

Registered User
Joined: 8/23/2013
Posts: 245

simple question on Example Uptrend Center 2/3 Up Line

If i had a condition that MINL5 on a chart was > 2/3 Line and the entire chart candles had never crossed below the 2/3 line BUT the MINL5 Value was currently lower than the current value of the 2/3 Line

THAT IS CONFUSING BUT I HOPE YOU GET THE IDEA,

Basically last 5 bars were always above the 2/3 Line

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There really isn't a good way to do this.

If I'm understanding correctly, you want to check for the low at each of the 5 most recent bars being above the current calculation for the 2/3 line if it were extended at least 4 bars back from the current bar.

This would require calculating each of those values and making individual comparisons for each bar. The Condition Formula would be about five times the size of the Indicator Formula for th 2/3 line. This would make it too long and slow to be practical or post in the forums.

What you could do instead is just create a Condition Formula for L > (Formula for 2/3 Line) and use it as the Boolean Formula in a Custom PCF % True Indicator with the Period set to 5 and the Average Type set to Simple. This would be equal to 100 if and only if the low at each bar was above the 2/3 line as calculated at that point in time. The problem with this approach is when the 2/3 line calculations are not actually straight over those 5 bars because of some sort of change in MINL78 or MAXH78.

Condition True at Least x Bars in a Row

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

What about a Moving Average on the 2/3 line Set to 1 , -5

Registered User
Joined: 8/23/2013
Posts: 245

cancel that - NO

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Unless I'm misunderstanding something, it would not be an improvement over using the Custom PCF % True Indicator method.

You would need to shift price and its moving average by 1, 2, 3 & 4 in addition to doing the direct comparison to make all of the desired comparisons. But the shifted version of the indicators would use the calculations at the time just like the Custom PCF % True Indicator version. So if the 2/3 line isn't straight because MINL78 or MAXH78 changed, then it would have exactly the same issue.

I would probably at least give the Custom PCF % True Indicator method a try to see what you think, but it is going to be problematic when MINL78 or MAXH78 changed in the most recent 5 bars.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

Bruce the 78 period are still working well (as i am sure you realize as i have not been much of a bother of late) - and Thanks again

I need 2 more lines plotted if you could for the 78 period setup

We have the uptrend Speed Line, the Uptrend 2/3 line, and the Uptrend 1/3 Line

I need a line between the Uptrend Speed Line and the Uptrend 2/3 Line

IF Uptrend Speed Line = 100

and Uptrend 2/3 Line = 66.6

Then My new Uptrend Line = 87.2

And the same for the DownTrend Lines

Thanks again

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The uptrend 5/6 line can be written as follows. It just changes the 2 / 3 at the end of the 2 / 3 line uptrend formula to a 5 / 6 instead.

MINL78 + (MAXH78 - MINL78) / (1 - (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * 5 / 6

A downtrend 5 / 6 line can be written as follows.

MAXH78 + (MAXH78 - MINL78) / ((ABS(L > MINL78) * (ABS(L1 = MINL78) + ABS(L1 > MINL78) * (ABS(L2 = MINL78) * 2 + ABS(L2 > MINL78) * (ABS(L3 = MINL78) * 3 + ABS(L3 > MINL78) * (ABS(L4 = MINL78) * 4 + ABS(L4 > MINL78) * (ABS(L5 = MINL78) * 5 + ABS(L5 > MINL78) * (ABS(L6 = MINL78) * 6 + ABS(L6 > MINL78) * (ABS(L7 = MINL78) * 7 + ABS(L7 > MINL78) * (ABS(L8 = MINL78) * 8 + ABS(L8 > MINL78) * (ABS(L9 = MINL78) * 9 + ABS(L9 > MINL78) * (ABS(L10 = MINL78) * 10 + ABS(L10 > MINL78) * (ABS(L11 = MINL78) * 11 + ABS(L11 > MINL78) * (ABS(L12 = MINL78) * 12 + ABS(L12 > MINL78) * (ABS(L13 = MINL78) * 13 + ABS(L13 > MINL78) * (ABS(L14 = MINL78) * 14 + ABS(L14 > MINL78) * (ABS(L15 = MINL78) * 15 + ABS(L15 > MINL78) * (ABS(L16 = MINL78) * 16 + ABS(L16 > MINL78) * (ABS(L17 = MINL78) * 17 + ABS(L17 > MINL78) * (ABS(L18 = MINL78) * 18 + ABS(L18 > MINL78) * (ABS(L19 = MINL78) * 19 + ABS(L19 > MINL78) * (ABS(L20 = MINL78) * 20 + ABS(L20 > MINL78) * (ABS(L21 = MINL78) * 21 + ABS(L21 > MINL78) * (ABS(L22 = MINL78) * 22 + ABS(L22 > MINL78) * (ABS(L23 = MINL78) * 23 + ABS(L23 > MINL78) * (ABS(L24 = MINL78) * 24 + ABS(L24 > MINL78) * (ABS(L25 = MINL78) * 25 + ABS(L25 > MINL78) * (ABS(L26 = MINL78) * 26 + ABS(L26 > MINL78) * (ABS(L27 = MINL78) * 27 + ABS(L27 > MINL78) * (ABS(L28 = MINL78) * 28 + ABS(L28 > MINL78) * (ABS(L29 = MINL78) * 29 + ABS(L29 > MINL78) * (ABS(L30 = MINL78) * 30 + ABS(L30 > MINL78) * (ABS(L31 = MINL78) * 31 + ABS(L31 > MINL78) * (ABS(L32 = MINL78) * 32 + ABS(L32 > MINL78) * (ABS(L33 = MINL78) * 33 + ABS(L33 > MINL78) * (ABS(L34 = MINL78) * 34 + ABS(L34 > MINL78) * (ABS(L35 = MINL78) * 35 + ABS(L35 > MINL78) * (ABS(L36 = MINL78) * 36 + ABS(L36 > MINL78) * (ABS(L37 = MINL78) * 37 + ABS(L37 > MINL78) * (ABS(L38 = MINL78) * 38 + ABS(L38 > MINL78) * (ABS(L39 = MINL78) * 39 + ABS(L39 > MINL78) * (ABS(L40 = MINL78) * 40 + ABS(L40 > MINL78) * (ABS(L41 = MINL78) * 41 + ABS(L41 > MINL78) * (ABS(L42 = MINL78) * 42 + ABS(L42 > MINL78) * (ABS(L43 = MINL78) * 43 + ABS(L43 > MINL78) * (ABS(L44 = MINL78) * 44 + ABS(L44 > MINL78) * (ABS(L45 = MINL78) * 45 + ABS(L45 > MINL78) * (ABS(L46 = MINL78) * 46 + ABS(L46 > MINL78) * (ABS(L47 = MINL78) * 47 + ABS(L47 > MINL78) * (ABS(L48 = MINL78) * 48 + ABS(L48 > MINL78) * (ABS(L49 = MINL78) * 49 + ABS(L49 > MINL78) * (ABS(L50 = MINL78) * 50 + ABS(L50 > MINL78) * (ABS(L51 = MINL78) * 51 + ABS(L51 > MINL78) * (ABS(L52 = MINL78) * 52 + ABS(L52 > MINL78) * (ABS(L53 = MINL78) * 53 + ABS(L53 > MINL78) * (ABS(L54 = MINL78) * 54 + ABS(L54 > MINL78) * (ABS(L55 = MINL78) * 55 + ABS(L55 > MINL78) * (ABS(L56 = MINL78) * 56 + ABS(L56 > MINL78) * (ABS(L57 = MINL78) * 57 + ABS(L57 > MINL78) * (ABS(L58 = MINL78) * 58 + ABS(L58 > MINL78) * (ABS(L59 = MINL78) * 59 + ABS(L59 > MINL78) * (ABS(L60 = MINL78) * 60 + ABS(L60 > MINL78) * (ABS(L61 = MINL78) * 61 + ABS(L61 > MINL78) * (ABS(L62 = MINL78) * 62 + ABS(L62 > MINL78) * (ABS(L63 = MINL78) * 63 + ABS(L63 > MINL78) * (ABS(L64 = MINL78) * 64 + ABS(L64 > MINL78) * (ABS(L65 = MINL78) * 65 + ABS(L65 > MINL78) * (ABS(L66 = MINL78) * 66 + ABS(L66 > MINL78) * (ABS(L67 = MINL78) * 67 + ABS(L67 > MINL78) * (ABS(L68 = MINL78) * 68 + ABS(L68 > MINL78) * (ABS(L69 = MINL78) * 69 + ABS(L69 > MINL78) * (ABS(L70 = MINL78) * 70 + ABS(L70 > MINL78) * (ABS(L71 = MINL78) * 71 + ABS(L71 > MINL78) * (ABS(L72 = MINL78) * 72 + ABS(L72 > MINL78) * (ABS(L73 = MINL78) * 73 + ABS(L73 > MINL78) * (ABS(L74 = MINL78) * 74 + ABS(L74 > MINL78) * (ABS(L75 = MINL78) * 75 + ABS(L75 > MINL78) * (ABS(L76 = MINL78) * 76 + ABS(L76 > MINL78) * (ABS(L77 = MINL78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (ABS(H < MAXH78) * (ABS(H1 = MAXH78) + ABS(H1 < MAXH78) * (ABS(H2 = MAXH78) * 2 + ABS(H2 < MAXH78) * (ABS(H3 = MAXH78) * 3 + ABS(H3 < MAXH78) * (ABS(H4 = MAXH78) * 4 + ABS(H4 < MAXH78) * (ABS(H5 = MAXH78) * 5 + ABS(H5 < MAXH78) * (ABS(H6 = MAXH78) * 6 + ABS(H6 < MAXH78) * (ABS(H7 = MAXH78) * 7 + ABS(H7 < MAXH78) * (ABS(H8 = MAXH78) * 8 + ABS(H8 < MAXH78) * (ABS(H9 = MAXH78) * 9 + ABS(H9 < MAXH78) * (ABS(H10 = MAXH78) * 10 + ABS(H10 < MAXH78) * (ABS(H11 = MAXH78) * 11 + ABS(H11 < MAXH78) * (ABS(H12 = MAXH78) * 12 + ABS(H12 < MAXH78) * (ABS(H13 = MAXH78) * 13 + ABS(H13 < MAXH78) * (ABS(H14 = MAXH78) * 14 + ABS(H14 < MAXH78) * (ABS(H15 = MAXH78) * 15 + ABS(H15 < MAXH78) * (ABS(H16 = MAXH78) * 16 + ABS(H16 < MAXH78) * (ABS(H17 = MAXH78) * 17 + ABS(H17 < MAXH78) * (ABS(H18 = MAXH78) * 18 + ABS(H18 < MAXH78) * (ABS(H19 = MAXH78) * 19 + ABS(H19 < MAXH78) * (ABS(H20 = MAXH78) * 20 + ABS(H20 < MAXH78) * (ABS(H21 = MAXH78) * 21 + ABS(H21 < MAXH78) * (ABS(H22 = MAXH78) * 22 + ABS(H22 < MAXH78) * (ABS(H23 = MAXH78) * 23 + ABS(H23 < MAXH78) * (ABS(H24 = MAXH78) * 24 + ABS(H24 < MAXH78) * (ABS(H25 = MAXH78) * 25 + ABS(H25 < MAXH78) * (ABS(H26 = MAXH78) * 26 + ABS(H26 < MAXH78) * (ABS(H27 = MAXH78) * 27 + ABS(H27 < MAXH78) * (ABS(H28 = MAXH78) * 28 + ABS(H28 < MAXH78) * (ABS(H29 = MAXH78) * 29 + ABS(H29 < MAXH78) * (ABS(H30 = MAXH78) * 30 + ABS(H30 < MAXH78) * (ABS(H31 = MAXH78) * 31 + ABS(H31 < MAXH78) * (ABS(H32 = MAXH78) * 32 + ABS(H32 < MAXH78) * (ABS(H33 = MAXH78) * 33 + ABS(H33 < MAXH78) * (ABS(H34 = MAXH78) * 34 + ABS(H34 < MAXH78) * (ABS(H35 = MAXH78) * 35 + ABS(H35 < MAXH78) * (ABS(H36 = MAXH78) * 36 + ABS(H36 < MAXH78) * (ABS(H37 = MAXH78) * 37 + ABS(H37 < MAXH78) * (ABS(H38 = MAXH78) * 38 + ABS(H38 < MAXH78) * (ABS(H39 = MAXH78) * 39 + ABS(H39 < MAXH78) * (ABS(H40 = MAXH78) * 40 + ABS(H40 < MAXH78) * (ABS(H41 = MAXH78) * 41 + ABS(H41 < MAXH78) * (ABS(H42 = MAXH78) * 42 + ABS(H42 < MAXH78) * (ABS(H43 = MAXH78) * 43 + ABS(H43 < MAXH78) * (ABS(H44 = MAXH78) * 44 + ABS(H44 < MAXH78) * (ABS(H45 = MAXH78) * 45 + ABS(H45 < MAXH78) * (ABS(H46 = MAXH78) * 46 + ABS(H46 < MAXH78) * (ABS(H47 = MAXH78) * 47 + ABS(H47 < MAXH78) * (ABS(H48 = MAXH78) * 48 + ABS(H48 < MAXH78) * (ABS(H49 = MAXH78) * 49 + ABS(H49 < MAXH78) * (ABS(H50 = MAXH78) * 50 + ABS(H50 < MAXH78) * (ABS(H51 = MAXH78) * 51 + ABS(H51 < MAXH78) * (ABS(H52 = MAXH78) * 52 + ABS(H52 < MAXH78) * (ABS(H53 = MAXH78) * 53 + ABS(H53 < MAXH78) * (ABS(H54 = MAXH78) * 54 + ABS(H54 < MAXH78) * (ABS(H55 = MAXH78) * 55 + ABS(H55 < MAXH78) * (ABS(H56 = MAXH78) * 56 + ABS(H56 < MAXH78) * (ABS(H57 = MAXH78) * 57 + ABS(H57 < MAXH78) * (ABS(H58 = MAXH78) * 58 + ABS(H58 < MAXH78) * (ABS(H59 = MAXH78) * 59 + ABS(H59 < MAXH78) * (ABS(H60 = MAXH78) * 60 + ABS(H60 < MAXH78) * (ABS(H61 = MAXH78) * 61 + ABS(H61 < MAXH78) * (ABS(H62 = MAXH78) * 62 + ABS(H62 < MAXH78) * (ABS(H63 = MAXH78) * 63 + ABS(H63 < MAXH78) * (ABS(H64 = MAXH78) * 64 + ABS(H64 < MAXH78) * (ABS(H65 = MAXH78) * 65 + ABS(H65 < MAXH78) * (ABS(H66 = MAXH78) * 66 + ABS(H66 < MAXH78) * (ABS(H67 = MAXH78) * 67 + ABS(H67 < MAXH78) * (ABS(H68 = MAXH78) * 68 + ABS(H68 < MAXH78) * (ABS(H69 = MAXH78) * 69 + ABS(H69 < MAXH78) * (ABS(H70 = MAXH78) * 70 + ABS(H70 < MAXH78) * (ABS(H71 = MAXH78) * 71 + ABS(H71 < MAXH78) * (ABS(H72 = MAXH78) * 72 + ABS(H72 < MAXH78) * (ABS(H73 = MAXH78) * 73 + ABS(H73 < MAXH78) * (ABS(H74 = MAXH78) * 74 + ABS(H74 < MAXH78) * (ABS(H75 = MAXH78) * 75 + ABS(H75 < MAXH78) * (ABS(H76 = MAXH78) * 76 + ABS(H76 < MAXH78) * (ABS(H77 = MAXH78) * 77)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1) * 5 / 6

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Registered User
Joined: 8/23/2013
Posts: 245

So all you had to change was *2/3 to * 5/6 and everything else is exactly the same ?

Thanks again

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Yes, that is all that needed to change. The 1 / 3 line basically has a * 1 / 3 there although the *1 part is left out because it doesn't change anything. The 2 / 3 line has a * 2 / 3 there. And half way between 2 / 3 and 1 is 5 / 6.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Guest-1