Hi Bruce:

      Could you give me the price C at which Hull 9 crosses its EMA8?

Hull 9 should cross its own EMA8 on the current bar when C equals the following.

(81 * XAVGC8.1 + 111 * XAVGC8.2 + 98 * XAVGC8.3 + 50 * XAVGC8.4 + 2 * XAVGC8.5 - 19 * XAVGC8.6 - 22 * XAVGC8.7 - 16 * XAVGC8.8 - 10 * XAVGC8.9 - 4 * XAVGC8.10 - XAVGC8.11 - 111 * C1 - 98 * C2 - 50 * C3 - 2 * C4 + 19 * C5 + 22 * C6 + 16 * C7 + 10 * C8 + 4 * C9 + C10) / 81

Thanks!

Hi Bruce:

               Could you tell me for which price C that hull 9 would equal its  hull 3?

Thank you.

Hull 9 of price should cross the Hull 3 of price on the current bar when C equals the following.

(98 * C2 + 65 * C3 + 2 * C4 - 24 * C1 - 19 * C5 - 22 * C6 - 16 * C7 - 10 * C8 - 4 * C9 - C10) / 69

Hull 9 of price should cross its own Hull 3 on the current bar when C equals the following.

(159 * C1 - 215 * C2 - 401 * C3 - 323 * C4 - 72 * C5 + 45 * C6 + 72 * C7 + 45 * C8 + 36 * C9 + 12 * C10 - C11 - 4 * C12 - C13) / 648

Thank you :)

Hi Bruce: What is   the value of (hull9- its hull3) assuming c0 = c1. I.e. the two most

recent periods have the same close.?

Note that after reading your most recent question, I think I gave you the wrong thing in my Tuesday, January 17, 2017 3:21:46 PM ET response. I have added what I think you actually wanted to that response.

The Hull 9 of price minus its own Hull 3 should be the following when the current price is the same as the close of the previous bar.

(807 * C1 - 215 * C2 - 401 * C3 - 323 * C4 - 72 * C5 + 45 * C6 + 72 * C7 + 45 * C8 + 36 * C9 + 12 * C10 - C11 - 4 * C12 - C13) / 4860

Thanks for all the formulas.

Is it also possible to get a pcf for:

The Hull 9 of price minus its own Exponential 3  when the current price is the same as the close of the previous bar.

Please try the following.

(192 * C1 + 98 * C2 + 50 * C3 + 2 * C4 - 19 * C5 - 22 * C6 - 16 * C7 - 10 * C8 - 4 * C9 - C10) / 540 - XAVG(HAVGC9.1, 3) / 2

Hi Bruce:

               I am interested in hull9": i.e:  hull9c.0-2*hull9c.1+hull9c.2

and also what that would be if c0=c1.

hull9c.0-2*hull9c.1+hull9c.2

If you just want the current value, this can be written as follows (in v17).

HAVGC9 - 2 * HAVGC9.1 + HAVGC9.2

The value when C0 = C1 is going to be a bit longer as the last HAVGC9 needs to be manually expanded.

(192 * C1 + 98 * C2 + 50 * C3 + 2 * C4 - 19 * C5 - 22 * C6 - 16 * C7 - 10 * C8 - 4 * C9 - C10) / 270 - 2 * HAVGC9.1 + HAVGC9.2

Wow. Thank you - the v17 thing is exciting...

Hi Bruce:

      At what price will havgc9+37*(havgc9-havgc9.1)  cross below xavg(havgc9,8)?    :)

Please try the following Indicator Formula.

((189 * XAVG(HAVGC9.1, 8) + 8991 * HAVGC9.1) / 34 - 111 * C1 - 98 * C2 - 50 * C3 - 2 * C4 + 19 * C5 + 22 * C6 + 16 * C7 + 10 * C8 + 4 * C9 + C10) / 81

Thank you. Could you please all answer for "havgc9+1.5*(havgc9-havgc9.1)  cross below xavg(havgc9,8)"?

Also, is there a way to get the maximum and minimum ADX(14,14) over n periods?

Please try the following Indicator Formula.

((3780 * XAVG(HAVGC9.1, 8) + 7290 * HAVGC9.1) / 41 - 111 * C1 - 98 * C2 - 50 * C3 - 2 * C4 + 19 * C5 + 22 * C6 + 16 * C7 + 10 * C8 + 4 * C9 + C10) / 81

Thank yo. That works great!  

[a "subscribe" feature in the forums would be handy for update notifications.]

Hello.

I'm interested in this thread and would like to understand it more clearly. I saw it a while ago.

Is it possible to do someting similar for getting the price at which Hull8 changed from red to green and vice-versa?

Thank you very much.

 

There is a subscribe feature (watch this topic), it just doesn't work.

The idea as to how this works is that you create an equation where say two moving averages are equal or the previous and current values of a moving average are equal. Then you try to solve the equation for C (the difficulty of solving for C can vary dramatically).

In this case, it is fairly straightforward as long as we manually expand the Hull 8 moving averages.

HAVG8 = HAVG8.1

Manually expand the moving averages:

(312 * C + 427 * C1 + 376 * C2 + 190 * C3 + 4 * C4 - 74 * C5 - 80 * C6 - 50 * C7 - 20 * C8 - 5 * C9) / 1080 = (312 * C1 + 427 * C2 + 376 * C3 + 190 * C4 + 4 * C5 - 74 * C6 - 80 * C7 - 50 * C8 - 20 * C9 - 5 * C10) / 1080

Multiply both sides by 1080.

312 * C + 427 * C1 + 376 * C2 + 190 * C3 + 4 * C4 - 74 * C5 - 80 * C6 - 50 * C7 - 20 * C8 - 5 * C9 = 312 * C1 + 427 * C2 + 376 * C3 + 190 * C4 + 4 * C5 - 74 * C6 - 80 * C7 - 50 * C8 - 20 * C9 - 5 * C10

Combine terms.

312 * C = 51 * C2 + 186 * (C3 + C4) + 78 * C5 + 6 * C6 - 115 * C1 - 30 * (C7 + C8) - 15 * C9 - 5 * C10

Divide both sides by 312.

C = (51 * C2 + 186 * (C3 + C4) + 78 * C5 + 6 * C6 - 115 * C1 - 30 * (C7 + C8) - 15 * C9 - 5 * C10) / 312

Since we are solving for C, we can eliminate the left side of the equation.

(51 * C2 + 186 * (C3 + C4) + 78 * C5 + 6 * C6 - 115 * C1 - 30 * (C7 + C8) - 15 * C9 - 5 * C10) / 312

So the the above is the price at which the color would change on the current bar.

We don't have to go through all of the steps above again to figure out the price at which the color will change on the next bar if the current bar closes at the current price. All we need to do is subtract one from all of the bars ago parameters.

(51 * C1 + 186 * (C2 + C3) + 78 * C4 + 6 * C5 - 115 * C - 30 * (C6 + C7) - 15 * C8 - 5 * C9) / 312

[didn't know that, but someday!]

Impossible to thank you enough, Bruce. I'm really appreciative of the help and explanations. Have a great weekend.

You're welcome.