Hi Bruce,

Is it possible to project the MACD into the future with this what I mean is for example if today the MACD is ticking down what price will the stock need to trade for the MACD to tick higher and be above the previous bar

Can this be done in TC2000 V17 as an indicator

Thanks

Kind regards

The price at which an exponential MACD 12, 26 would not change during the next bar would be (note that this value can change as the bar current bar continues to form):

(27 * XAVGC12 - 13 * XAVGC26) / 14

So if price is above this value during the next bar then the MACD will go up and if price is below this value, it will go down.

The one bar ago version will tell you the price at which MACD will go up or down for the current bar.

(27 * XAVGC12.1 - 13 * XAVGC26.1) / 14

Bruce,

I have not been able to make it work

For example 

Stock Symbol BB

Close at 14.40 On the 1/9/18 - MACD Higher than on the previous bar - MACD Projected(The formula you provide it) says 13.57

So basically if the next bar close is above 13.57 the MACD will rise and if it is below 13.57 the MACD will fall below the previous bar

Next Bar Day 1/10/18

Close 13.67 which is above 13.57 but the MACD is lower than on the previous bar

Please help

On January 9, the value is 13.57 and the price on January 10 is 13.67 just as you said.

Exponential MACD 12,26 on January 9 is 0.83 and went up to 0.84 on January 10. This means MACD went up just as indicated by the formula and not down.

I see the problem sorry for not expresing myself clear, I was talking about the MACD Histogram 12,26,9

Sorry for not expresing myself clearly

The MACD Histogram on the 1/9/18 was 0.32 and on the 1/10/18 0.26

Can it be done the same witht the MACD Histogram?

The price at which an exponential MACD Histogram 12,26,9 would not change during the next bar would be (note that this value can change as the bar current bar continues to form):

(65 * XAVGC26 + 819 * XAVGC9 - 765 * XAVGC12) / 119

So if price is above this value during the next bar then the MACD Histogram will go up and if price is below this value, it will go down.

The one bar ago version will tell you the price at which MACD will go up or down for the current bar.

(65 * XAVGC26.1 + 819 * XAVGC9.1 - 765 * XAVGC12.1) / 119

Thanks now works!!!!!

Sorry for the misunderstanding

You're welcome.