I have scripts that create a start and end points -  IS THERE a way to come up with PCF that takes my points and creates a trendline from the to extend right (and hopefully create alert )

There is definitely no built in way of doing this within TC2000.

If you are already using a script of some sort to generate the endpoints, there might be a way to generate a PCF using a script as well. I use Excel to create most of the longer formulas.

yes i created a script to do the end points a BUT since the original script creates my end point - later in the day that level is not relevant - kinda of like he Speed Resistance line what makes the center line or top line continue in the right extenision

Also I have created a script that plots my fib retracement levels for me (works great) but it on show the levels (is there  way i can modify my plot to plot a horizontal like so that i can see it on other time frames instead of just  my daily?

I guess I misunderstood your original request. I thought you had a script that generated end points with at least dates and/or times and possibly even values. I thought that you wanted to extend the straight line connecting those endpoints into the future. I did not realize the endpoints and values were a moving target.

There is almost no way to calculate daily values and display them on an intraday chart using any sort of automated formula.

This is a enhancement that has been pending for a long time.

http://forums.worden.com/default.aspx?g=posts&t=62572

Ability to plot daily / weekly / monthly values on intraday chart.

Basic feature which most platforms typically have. Would be good for tc2000 to add this soon.

yes it is a beginning value and ending value that could span several days - even if the values were from one point on a daily to another point on another day - still trying to create a line between the 2 points to extend into the future (as a trendline) and be alerted when crossed over

Also I have created a script that plots my fib retracement levels for me (works great) but it on show the levels (is there way i can modify my plot to plot a horizontal like so that i can see it on other time frames instead of just my daily?

that statement is actually  i have a formula that calulates fib and plots but it is a different level each day i would like thos points to plot horizontal lines for he day

So I am not proposing that this is something that is simple to do. I personally wouldn't try it without some artificial method of creating the PCF.

You can write a formula which will connect two lines (not talking PCF at this point just math) in way that also just specifies one point and a slope. The following is deliberately simplistic, but the concepts work with just about any numbers.

So let us say one endpoint has a value of 5 on June 2, 2015 and a value of 6 on June 4, 2015.

If you want a straight line on an arithmetic chart then you could use either endpoint as a the starting point with the slope set at 0.50 per daily bar. This means the basic thing you need to represent can be written as follows.

5 + .5 * days since June 2, 2015

Or as:

6 + .5 * days since June 4, 2015

Or even as:

.5 * days since May 18, 2015

So to write a formula for this, you need to determine how many days it has been since a bar where you know the value or have calculated the value of the line at that bar

The Personal Criteria Formula Language does not have any built in "since" syntax which would give us the number of bars, but the techniques in the Days Since Last Peak (or other day-counting needs) topic can be used to calculate the number of bars since something which can be identified using a formula happened.

So what is needed is to identify something specific about a date to use in the formula. This could be something as simple as C = C'06/04/2015' to check for the closing price being the same as the closing price of June 4, 2015. Note that if a price bar closed at this price on a later bar, that the count would start over however, so you would probably want to use something a bit more complicated.

If the formula is intraday, you would not be able to use date references in the formulas. You would need to extract (probably via export) some numeric value from the data to check against (and probably not use =, but an approximate comparison of some sort to avoid rounding issues).

If you are really plotting this on a daily chart, it should be a lot easier to do than the other request.

I don't know the details of the formula you are using, but you will most likely be able to substitute dates for the bars ago parameters being used in the formula to plot it as horizontal lines across the entire chart. You would have to change the formula each trading day, but it should work.

i dont think i could manage that, but i am using like MAXH MINL

actually trying to plot a Speed Line Top Point to Bottom Point (the calculate the 2/3 and 1/3 Lines

I am doing that part so far as the center line directly above he lower connection (end Point) of the lower line and if the next candle went straight UP thru the center line the cross over value would be correct

As time moves forward with new candles right my center line calculation does not change (but the Speed Line of course plots downward and to the right (which) of course make my value incorrect

Thanks

We could automate this to some extent, but I suspect the result will not meet your expectations.

We can't just calculate and plot a lines based on the highest high and lowest low over the most recent x bars.

What we can do is plot what the most recent endpoint would be if we connected the highest high and lowest low over the most recent x bars.

Such a plot would be a straight line only in cases where both Donchian Channels of Period x and Offset 0 do not change from one bar to the next. If either value changes the resulting "Speed Line" would jog instead of being straight.

The plot can also stop being a straight line if the most recent time price was at its high or low changed even when the values of that high or low did not change, but this should happen far less often for most actively trading stocks.

If you Plot Donchian Channels on the chart with a Period of 50 and an Offset of 0 and plot a Custom PCF Indicator with the following Formula in the same pane and scale as price, you will hopefully see what I mean.

MINL50 + (MAXH50 - MINL50) / ((ABS(L > MINL50) * (ABS(L1 = MINL50) + ABS(L1 > MINL50) * (ABS(L2 = MINL50) * 2 + ABS(L2 > MINL50) * (ABS(L3 = MINL50) * 3 + ABS(L3 > MINL50) * (ABS(L4 = MINL50) * 4 + ABS(L4 > MINL50) * (ABS(L5 = MINL50) * 5 + ABS(L5 > MINL50) * (ABS(L6 = MINL50) * 6 + ABS(L6 > MINL50) * (ABS(L7 = MINL50) * 7 + ABS(L7 > MINL50) * (ABS(L8 = MINL50) * 8 + ABS(L8 > MINL50) * (ABS(L9 = MINL50) * 9 + ABS(L9 > MINL50) * (ABS(L10 = MINL50) * 10 + ABS(L10 > MINL50) * (ABS(L11 = MINL50) * 11 + ABS(L11 > MINL50) * (ABS(L12 = MINL50) * 12 + ABS(L12 > MINL50) * (ABS(L13 = MINL50) * 13 + ABS(L13 > MINL50) * (ABS(L14 = MINL50) * 14 + ABS(L14 > MINL50) * (ABS(L15 = MINL50) * 15 + ABS(L15 > MINL50) * (ABS(L16 = MINL50) * 16 + ABS(L16 > MINL50) * (ABS(L17 = MINL50) * 17 + ABS(L17 > MINL50) * (ABS(L18 = MINL50) * 18 + ABS(L18 > MINL50) * (ABS(L19 = MINL50) * 19 + ABS(L19 > MINL50) * (ABS(L20 = MINL50) * 20 + ABS(L20 > MINL50) * (ABS(L21 = MINL50) * 21 + ABS(L21 > MINL50) * (ABS(L22 = MINL50) * 22 + ABS(L22 > MINL50) * (ABS(L23 = MINL50) * 23 + ABS(L23 > MINL50) * (ABS(L24 = MINL50) * 24 + ABS(L24 > MINL50) * (ABS(L25 = MINL50) * 25 + ABS(L25 > MINL50) * (ABS(L26 = MINL50) * 26 + ABS(L26 > MINL50) * (ABS(L27 = MINL50) * 27 + ABS(L27 > MINL50) * (ABS(L28 = MINL50) * 28 + ABS(L28 > MINL50) * (ABS(L29 = MINL50) * 29 + ABS(L29 > MINL50) * (ABS(L30 = MINL50) * 30 + ABS(L30 > MINL50) * (ABS(L31 = MINL50) * 31 + ABS(L31 > MINL50) * (ABS(L32 = MINL50) * 32 + ABS(L32 > MINL50) * (ABS(L33 = MINL50) * 33 + ABS(L33 > MINL50) * (ABS(L34 = MINL50) * 34 + ABS(L34 > MINL50) * (ABS(L35 = MINL50) * 35 + ABS(L35 > MINL50) * (ABS(L36 = MINL50) * 36 + ABS(L36 > MINL50) * (ABS(L37 = MINL50) * 37 + ABS(L37 > MINL50) * (ABS(L38 = MINL50) * 38 + ABS(L38 > MINL50) * (ABS(L39 = MINL50) * 39 + ABS(L39 > MINL50) * (ABS(L40 = MINL50) * 40 + ABS(L40 > MINL50) * (ABS(L41 = MINL50) * 41 + ABS(L41 > MINL50) * (ABS(L42 = MINL50) * 42 + ABS(L42 > MINL50) * (ABS(L43 = MINL50) * 43 + ABS(L43 > MINL50) * (ABS(L44 = MINL50) * 44 + ABS(L44 > MINL50) * (ABS(L45 = MINL50) * 45 + ABS(L45 > MINL50) * (ABS(L46 = MINL50) * 46 + ABS(L46 > MINL50) * (ABS(L47 = MINL50) * 47 + ABS(L47 > MINL50) * (ABS(L48 = MINL50) * 48 + ABS(L48 > MINL50) * (ABS(L49 = MINL50) * 49)))))))))))))))))))))))))))))))))))))))))))))))))) - (ABS(H < MAXH50) * (ABS(H1 = MAXH50) + ABS(H1 < MAXH50) * (ABS(H2 = MAXH50) * 2 + ABS(H2 < MAXH50) * (ABS(H3 = MAXH50) * 3 + ABS(H3 < MAXH50) * (ABS(H4 = MAXH50) * 4 + ABS(H4 < MAXH50) * (ABS(H5 = MAXH50) * 5 + ABS(H5 < MAXH50) * (ABS(H6 = MAXH50) * 6 + ABS(H6 < MAXH50) * (ABS(H7 = MAXH50) * 7 + ABS(H7 < MAXH50) * (ABS(H8 = MAXH50) * 8 + ABS(H8 < MAXH50) * (ABS(H9 = MAXH50) * 9 + ABS(H9 < MAXH50) * (ABS(H10 = MAXH50) * 10 + ABS(H10 < MAXH50) * (ABS(H11 = MAXH50) * 11 + ABS(H11 < MAXH50) * (ABS(H12 = MAXH50) * 12 + ABS(H12 < MAXH50) * (ABS(H13 = MAXH50) * 13 + ABS(H13 < MAXH50) * (ABS(H14 = MAXH50) * 14 + ABS(H14 < MAXH50) * (ABS(H15 = MAXH50) * 15 + ABS(H15 < MAXH50) * (ABS(H16 = MAXH50) * 16 + ABS(H16 < MAXH50) * (ABS(H17 = MAXH50) * 17 + ABS(H17 < MAXH50) * (ABS(H18 = MAXH50) * 18 + ABS(H18 < MAXH50) * (ABS(H19 = MAXH50) * 19 + ABS(H19 < MAXH50) * (ABS(H20 = MAXH50) * 20 + ABS(H20 < MAXH50) * (ABS(H21 = MAXH50) * 21 + ABS(H21 < MAXH50) * (ABS(H22 = MAXH50) * 22 + ABS(H22 < MAXH50) * (ABS(H23 = MAXH50) * 23 + ABS(H23 < MAXH50) * (ABS(H24 = MAXH50) * 24 + ABS(H24 < MAXH50) * (ABS(H25 = MAXH50) * 25 + ABS(H25 < MAXH50) * (ABS(H26 = MAXH50) * 26 + ABS(H26 < MAXH50) * (ABS(H27 = MAXH50) * 27 + ABS(H27 < MAXH50) * (ABS(H28 = MAXH50) * 28 + ABS(H28 < MAXH50) * (ABS(H29 = MAXH50) * 29 + ABS(H29 < MAXH50) * (ABS(H30 = MAXH50) * 30 + ABS(H30 < MAXH50) * (ABS(H31 = MAXH50) * 31 + ABS(H31 < MAXH50) * (ABS(H32 = MAXH50) * 32 + ABS(H32 < MAXH50) * (ABS(H33 = MAXH50) * 33 + ABS(H33 < MAXH50) * (ABS(H34 = MAXH50) * 34 + ABS(H34 < MAXH50) * (ABS(H35 = MAXH50) * 35 + ABS(H35 < MAXH50) * (ABS(H36 = MAXH50) * 36 + ABS(H36 < MAXH50) * (ABS(H37 = MAXH50) * 37 + ABS(H37 < MAXH50) * (ABS(H38 = MAXH50) * 38 + ABS(H38 < MAXH50) * (ABS(H39 = MAXH50) * 39 + ABS(H39 < MAXH50) * (ABS(H40 = MAXH50) * 40 + ABS(H40 < MAXH50) * (ABS(H41 = MAXH50) * 41 + ABS(H41 < MAXH50) * (ABS(H42 = MAXH50) * 42 + ABS(H42 < MAXH50) * (ABS(H43 = MAXH50) * 43 + ABS(H43 < MAXH50) * (ABS(H44 = MAXH50) * 44 + ABS(H44 < MAXH50) * (ABS(H45 = MAXH50) * 45 + ABS(H45 < MAXH50) * (ABS(H46 = MAXH50) * 46 + ABS(H46 < MAXH50) * (ABS(H47 = MAXH50) * 47 + ABS(H47 < MAXH50) * (ABS(H48 = MAXH50) * 48 + ABS(H48 < MAXH50) * (ABS(H49 = MAXH50) * 49))))))))))))))))))))))))))))))))))))))))))))))))))) * (ABS(L > MINL50) * (ABS(L1 = MINL50) + ABS(L1 > MINL50) * (ABS(L2 = MINL50) * 2 + ABS(L2 > MINL50) * (ABS(L3 = MINL50) * 3 + ABS(L3 > MINL50) * (ABS(L4 = MINL50) * 4 + ABS(L4 > MINL50) * (ABS(L5 = MINL50) * 5 + ABS(L5 > MINL50) * (ABS(L6 = MINL50) * 6 + ABS(L6 > MINL50) * (ABS(L7 = MINL50) * 7 + ABS(L7 > MINL50) * (ABS(L8 = MINL50) * 8 + ABS(L8 > MINL50) * (ABS(L9 = MINL50) * 9 + ABS(L9 > MINL50) * (ABS(L10 = MINL50) * 10 + ABS(L10 > MINL50) * (ABS(L11 = MINL50) * 11 + ABS(L11 > MINL50) * (ABS(L12 = MINL50) * 12 + ABS(L12 > MINL50) * (ABS(L13 = MINL50) * 13 + ABS(L13 > MINL50) * (ABS(L14 = MINL50) * 14 + ABS(L14 > MINL50) * (ABS(L15 = MINL50) * 15 + ABS(L15 > MINL50) * (ABS(L16 = MINL50) * 16 + ABS(L16 > MINL50) * (ABS(L17 = MINL50) * 17 + ABS(L17 > MINL50) * (ABS(L18 = MINL50) * 18 + ABS(L18 > MINL50) * (ABS(L19 = MINL50) * 19 + ABS(L19 > MINL50) * (ABS(L20 = MINL50) * 20 + ABS(L20 > MINL50) * (ABS(L21 = MINL50) * 21 + ABS(L21 > MINL50) * (ABS(L22 = MINL50) * 22 + ABS(L22 > MINL50) * (ABS(L23 = MINL50) * 23 + ABS(L23 > MINL50) * (ABS(L24 = MINL50) * 24 + ABS(L24 > MINL50) * (ABS(L25 = MINL50) * 25 + ABS(L25 > MINL50) * (ABS(L26 = MINL50) * 26 + ABS(L26 > MINL50) * (ABS(L27 = MINL50) * 27 + ABS(L27 > MINL50) * (ABS(L28 = MINL50) * 28 + ABS(L28 > MINL50) * (ABS(L29 = MINL50) * 29 + ABS(L29 > MINL50) * (ABS(L30 = MINL50) * 30 + ABS(L30 > MINL50) * (ABS(L31 = MINL50) * 31 + ABS(L31 > MINL50) * (ABS(L32 = MINL50) * 32 + ABS(L32 > MINL50) * (ABS(L33 = MINL50) * 33 + ABS(L33 > MINL50) * (ABS(L34 = MINL50) * 34 + ABS(L34 > MINL50) * (ABS(L35 = MINL50) * 35 + ABS(L35 > MINL50) * (ABS(L36 = MINL50) * 36 + ABS(L36 > MINL50) * (ABS(L37 = MINL50) * 37 + ABS(L37 > MINL50) * (ABS(L38 = MINL50) * 38 + ABS(L38 > MINL50) * (ABS(L39 = MINL50) * 39 + ABS(L39 > MINL50) * (ABS(L40 = MINL50) * 40 + ABS(L40 > MINL50) * (ABS(L41 = MINL50) * 41 + ABS(L41 > MINL50) * (ABS(L42 = MINL50) * 42 + ABS(L42 > MINL50) * (ABS(L43 = MINL50) * 43 + ABS(L43 > MINL50) * (ABS(L44 = MINL50) * 44 + ABS(L44 > MINL50) * (ABS(L45 = MINL50) * 45 + ABS(L45 > MINL50) * (ABS(L46 = MINL50) * 46 + ABS(L46 > MINL50) * (ABS(L47 = MINL50) * 47 + ABS(L47 > MINL50) * (ABS(L48 = MINL50) * 48 + ABS(L48 > MINL50) * (ABS(L49 = MINL50) * 49))))))))))))))))))))))))))))))))))))))))))))))))))

The 2/3 and 1/3 formulas would end up being a bit more complicated because you would need to know if the highest high or lowest low was more recent to determine the direction. The formula for the Speed Line itself doesn't care because the line intersects both points. But the 2/3 and 1/3 formulas only intersect the older of the two points.

Note also that the line is straight only in an arithmetic scale. You would need a different formula to calculate a straight line in a logarithmic scale.

i made a pcf on with this fromula but i dont quite understand what this is support to represent -

What is being plotted is the right endpoint a speedline drawn by connecting the highest and lowest values over the most recent 50 bars. A "50-period speed line" is to this Custom PCF Indicator as a 50 period Linear Regression Line indicator is to a a 50-period Moving Linear Regression Indicator.

Make sure the scaling in the price pane is set to Arithmetic.

Add the Custom PCF Indicator to the same pane and scale as price.

Add Donchian Channels 50, 0 to the price. This means you will need to change the Offset from 1 to 0. Leave Based Ont set to High and Low.

Now look for places where the Custom PCF Indicator is a straight line and the top and bottom Donchian Channels are not changing and where both the top and bottom Donchian Channels actually touched price.

Connect the most recent point where price touched the top Donchian Channel to the most recent point where price touched the bottom Donchian Channel and extend the line into the future. You can put a ruler or straight edge on the screen to make this easier instead of doing it mentally if you want.

This extension will correspond exactly to the straight portion of the Custom PCF Indicator. It is in fact a short segment of what the speed line would have been at that point in time in the past if you were creating the speed line by connecting the highest and lowest points over the most recent 50 bars at the time.

Now understand this doesn't look at all like a speed line and that's why I said I didn't think the results would meet your expectations.

It doesn't look like a speed line for multiple reasons.

It is calculated based an arbitrary period of 50 bars. While this could be changed, the place where somebody might manually draw a speed line very well might not be based on the highest and lowest prices over the most recent 50 bars. In fact, it would probably be entirely arbitrary based on what that particular person sees as an important high and an important low.

It plot isn't calculated based on a fixed range of bars. The highs and lows of the most recent bar are frequently going to change from one bar to the next. This can happen because there is a new high or a new low, but it is also going to happen because on old high or an old high drops out of the calculations. This dropping out effect is what causes price to not touch the Donchian Channels.

This next reason is related to the last reason. Price isn't plotted as a straight line. Because it is plotting the end points of what would have been the line, it usually isn't going to be straght at all. That it actually is straight for a period of time (unlike most Moving Linear Regression Lines) has to do with only 2 bars being involved in its calculations. As long as those two bar don't change, the Custom PCF Indicator will remain straight.

If you give me a symbol with the dates of the high and low on a daily chart you want to use to construct the speed line, I can probably create an example formula for you which plots a straight line using those points. It might allow me to make it a bit more obvious how it works.

An Indicator Formula based on manually chosen highs and lows would need to be manually constructed. I might be able to make a template which would allow you to use the Replace feature of a text editor to create your own formulas fairly easily. The formulas would still be long, but they might not be all that difficult to create. I would have to play with it to know for sure.

open my account and look at Chart Named "30M speed Test" if you want to see formulas

http://www.screencast.com/t/HvAFz8LEX  

This MAXH78 MINL78 needs some work as it does not always represent the most recent low price

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.

about to check all this out, when i first set up MY formulas and they of course did not progress to the right in line with the actual speed line, i removed them. BUT last night i left MY formulas on the chart and reviewed them on the charts i found that MY plots for the uptrends 1/3 2/3 lines actually were the same plots (excluding the extensions part you are working on here) So the fact that these only work for the downtrends was expected.  DID you use my formulas on the 30M speed test chart to create your formulas for the part to calculate the end point of the 1/3 and 2/3 plots

I went back to that chart and added MY formulas for the Uptrend 1/3 and 2/3 LINES

Thanks for all the Help

As Always your are the best

BOOYAH - AWESOME - UNREAL and add anything else you think fits this great formula

I see that my forumla actually created the start (endpoint for the 1/3 and 2/3 Line) for you forumula to continue out.

The post from last evening about the MAXH 78 MINL78 still not being perfect - they do work out well and i just created a scan condition on MY 10m chart using this that the MAXH78 and MAXH20 had to be near equal for me to scan the cross overs so the scan results actually only come into play when these are valid lines.

Again these look awesome and of course would like the UPtrend counterparts

I didn't actually use your formulas to create my formulas, but I did use the lines created by your formulas to verify the approach I was using resulted in the same values at the point where your formulas had the values you indicated you wanted.

I've shortened the formulas by about a third (I changed it in the three 78 period formulas given above as well). This introduces a division by zero issue into the math (which is why I hadn't done it earlier), but it should only happen when going in the "wrong" direction (so I don't think it should actually cause any problems).

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

still some impertections on my end how can i take my formula below (my downtrend 1/3 line (the top)

( ( ( ( MAXH78 - MINL78 ) * 0.666 ) - (MAXH78 - MINL78) )+ MAXH78 )  

and this is MY downtrend 2/3 Line (Middle)

( ( ( ( MAXH78 - MINL78 ) * 0.333 ) - (MAXH78 - MINL78) )+ MAXH78 )

These are represent where my end point starts (BUT these need fine tuning not include every point I m trying to work on that

QUESTION FOR NOW?  CAN THE FORMULAS YOU MADE BE USED ON 10M AS WELL AS 30m

When I originally proposed an automated method I mentioned, "I suspect the result will not meet your expectations." It is a far from perfect solution and I am pleasantly surprised at your fairly positive reaction after seeing how it works.

The formulas are specifically designed around the most recent places where price made a 78 bar high and low to use as the speed line. Beyond that, the time frame does not matter.

As long as the 10 minute also uses the most recent places where price made a 78 bar high or low, the formulas should work there as well. If that isn't the definition used, it won't work.

It will not work where the definition is anything besides the endpoints of the speedline being the most recent 78 bar high and low. So this means it will not work in case where your formulas do not accurately define the second endpoint with the first endpoint actually touching the 78 bar high or low.

Note that the lines might coincidently work with other speed lines, but it will only do so because the lines also would be defined by the most recent 78 bar high and low.

--------------------------------------------------------------------

If you can come up with an exact mathematical definition of what constitutes a high and low, we might be able to use that definition instead. The formulas were designed as they are because of the lines that were on the chart when I looked at it.

For example, we could have a high be a pivot high where it is surrounded by a specified number lower highs on both sides and the low be a pivot low where it is surrounded by a specified number of higher lows on both sides.

What we can't do is come up with something which will automatically connect things that look like highs and lows without some sort of exact definition which could be used by the formula to identify those points.

--------------------------------------------------------------------

I am going to qualify that statement somewhat.... if you identify the bars manually and are willing to use the replace function in a text editor, I could probably come up with a template of some sort which would work based on arbitrarily defined end points. There may be complications I have not anticipated which would actually make it so this doesn't work, but it seems like it could when I think about the concept in general.

I HAVE TO COME up with a set of qualifications as to which bar 78H to use which i have kinda of add to the "30M Speed Test" chart on my account

I am basically saying

 MAXH78 <= MAXH20 + .08 and MAXH20 > MAXH20.1

for begin Point  which elimiates the use of a MAXH78 Line that is just dropping because of time NOT actually because the candle created it

I am going refine that slightly more to have it correct at all times

Actually this is perfect as IS

You realize you just created a Speed Line that auto plots and is scanable!!! Awesome

We can (mostly you) create a Auto Trendline as well (i will have to figure out the levels to peak)

Well if you think it is perfect as is, we will leave things stand as they are, at least for now.

If you do come up with some refinements you would like to try, we will see if we can incorporate them into the concept then.

Thanks and will do

OK after further review the lines from the 6 formulas above are great for short term pull backs and predicted short term retracements as can be seen almost perfectly on the pullback on ALKS 30m chart on 6/18/15 - So these formulas remain AWESOME.

That said for the bigger picture and to plot Begin and End points at the bottom of downtrend for example on ALKS (the current formulas adjusted the begin point up as the MINL78 adjusted itself up overtime)

So I came up with a set of rules that I believe will actually Keep the Speed Line Begin Point Set at the Original Begin Point

The Rules are in my account on the "30M Speed Test" Chart

I see your rules, but I'm pretty sure I don't understand them.

You have a Begin Point - Requires Part 2 True and then Begin Point - Part 2 plotted in the same pane. I am not seeing very many cases where both of these are true at the same time however.

Then there is a When this is TRUE Begin Plot at MAXH78.6 line right below that. This line doesn't seem to line up with the Begin Plot line above much at all... but does seem to line up with Begin Point - Part 2 in cases where Begin Point was true in a relatively short span prior to Begin Point - Part 2.

So I'm not quite sure if these two panes are designed to be two different things or if the second of the Begin panes is designed to distill what we are already seeing in the first begin pane into a single formula.

In any case, there really need to be four formulas.

1 - Condition Formula which returns true on the first bar which is connected to draw the uptrend version of the speed line. This is currently just L = MINL78.

2- Condition Formula which returns true on the second bar which is connected to draw the uptrend version of the speed line. This is currently just H = MAXH78.

3 - Condition Formula which returns true on the first bar which is connected to draw the downtrend version of the speed line. This is currently just H = MAXH78.

4 - Condition Formula which returns true on the second bar which is connectod to draw the downtrend version of the speed line. This is currently just L = MINL78.

Note that the formulas above aren't really L = MINL78 and H = MAXH78. They are checking the current MINL78 and MAXH78 against previous lows and highs to determine which of those bars made the current lows and highs.

It is theoretically possible to use the actual L = MINL78 and H = MAXH78 formulas instead, but the issue is that the lookback goes from being exactly 78 bars to an unknown numbers of bars since in an uptrend it could be a very long time since L = MINL78 and in a downtrend it could be a very long time since H = MAXH78. This means we would need to manually specify a fixed number of bars to look back for such an occurrance (and if the lookback is too large, the formula becomes too large to be practical or post in the forums).

The last two paragraphs are more informational than anything else. What really needs to be done is to concentrate on the four required conditions. They may be staring me in the face in the form of the six Custom PCF Indicators you have plotted, but I haven't been able to get from those six formulas to the four formulas I would actually need.

i am re-describing the rule names - THEY are actually only meant to change / HOLD the begin Point at a lower level for the UP slope lines and HOLD the Begin Point of the Down Slope Line at  higher level

By having the Begin Points only valid when the 20 Period Line up with the 78 periods

The Plot that refers to the 78.6 was an attempt on my part to combine the Above Part 1 and Part 2 into 1 indicator

These are being re-named now "3M Speed TEST"

30M Speed Test - chart name

Bruce look at IMPV 15 min chart with our complete 2:30 - 2:45 bar and just for information what make the plots go into this eractic shape

Use my 30M Speed Test - chart and change to 15

Thanks

If I'm understanding your definition correctly (which I am not convinced is the case), the start point of the current uptrend would be the most recent low which was at or below the 19 bars before it and the 6 bars after it. You would then connect this to the highest high since that point to create the uptrend speed line.

And the start point of the current downtrend would be the most recent high which was at or above the 19 bars before it and the 6 bars after it. You would then connect this to the lowest low since that point to create the downtrend speed line.

The more I think about it, the more I think I probably can't create a reasonable sized formula for this or anything similar.

The reason the current 78bar formula can be "short" is because of its structure.

We know the value of the start of the uptrend is going to be MINL78. We don't have to determine how many bars ago it happened to determine the value.

We know the value of the start of the downtrend is going to be MAXH78. We don't have to determine how many bars ago it happened to determine the value.

We know the difference in the two values we need to connect is going to be MAXH78 - MINL78. We don't know to know how many bars ago the start and end points used to construct the speedline happened to calculate this range.

Calculating these values in and of itself comes at a cost in formula length and complexity. If this were the only issue, it might be do-able, but it isn't the only issue

The long portions of the current formulas all end up being to two "since" type formulas with lookbacks of 78 bars each. The reason I say we triple the size of the formula making just these changes is that we go from 2 such formulas to 6 such formulas in each formula. The lookback period would probably also need to increase somewhat, but let's ignore that aspect.

Calculating how many bars ago the highest high since the uptrend started happened or how many bars ago the lowest low since the downtrend started happened ends up being a much, much bigger problem.

In 1 of the six formulas we would need to nest in a bunch of other "since" type formulas. There would be one "since" formula with a lookback of 6 which would be checked if the start of the trend happened 6 bars, and one "since" formula with a lookback of 7 which would be checked if the start of the trend happened 7 bars, etc, all the way up to whatever final lookback we decide up. So if we went up to a lookback of 78 (and we would probably want to go higher), we would have 72 additional "since" types formulas. This means we've gone from 2 to 78 "since" types formulas even if the lookback stays at a maximum of 78 bars.

That just isn't the sort of thing I can actually write and post. For one thing it is just too slow. For another thing it because almost impossible to even copy and paste (there is a 32768 character limit to copy and paste using the Windows clipboard).

The start of the speedline for the Monday, June 22, 2015 2:15 PM bar is Wednesday June 17, 2015 2:30 PM bar. The end of the speedline is the Thursday, June 18, 2015 1:30 PM bar.

On the June 22, 2015 2:30 PM bar the start of the speedine switches to the low of the Wednesday June 17, 2015 2:45 PM  bar but the end stays the same.

Both of these bars are still an uptrend because the 78 bar low happened before the 78 bar high.

On the June 22, 2015 2:45 PM bar the start of the speed line switches to the former endpoint which is the high the Thursday, June 18, 2015 1:30 PM bar. The end point switches to the low of the Friday, June 19, 2015 12:30 PM bar.

The formula is now in a downtrend because the 78 bar high happened before the 78 bar low.

the only thing that needs to be true about the 19 Bar (MINL20 is that it and the MINL78 are equal) for the Begin Point of the UPTrend - the older formula was adjust the New Begin Point up every time the MINL78 Plot shifted up to the new and current MINL78 (but we do not want to change out begin point at that time unless the MINL20 were at that same point in time

The end points you currently have on both just right

not even sure if when the MINL20 = MINL78 has to be 6 bars (if the stock were sellin it would just keep moving the Begin Point Down until the falling Price Quit making lower lows

SEE IF THE BELOW 1 Rule simplifies

SO SIMPLER PROBABLY would work if the Begin Point of the Uptrend is MINL78 just like you have it now (with the rule that the Begin Point MINL78 = MINL20 at that single pont

Actually looking on some daily charts we have discovered sometime the MAXH78 end point is behind the begin point so far as the date is concerned. BUT the shorter term charts are pretty good

IF you took the begin point as  l last described in the above post - could the endpoint be the Highest high afterwards (this method would actually keep plot in tact UNTIL a New MINL78 match MINL20 created the next Begin Point  (would this not Keep the UPTrend Plots in Tact until a new UPTrend Begin point became active

Guess you would have to estabish an endpoint to begin some bars into the future or your first plot would be 2 bars LONG like MAXH20 but only plot create Endpoint after 10 bars into the future

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.

IS IT POSSIBLE TO LEAVE THE CURRENT ENDPOINT of each where they are now and  just created the Begin points of each are when the 20 and 78 are equal

I tryed replacing the MINL78 in the UPTrend Formual with

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

by adding ( )  on each end in the formula

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

which results with  "  Error in formula  Argument missing near /  "

 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