New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Project MACD Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
f.lb
Posted : Friday, January 12, 2018 11:28:20 AM
Gold Customer Gold Customer

Joined: 4/3/2012
Posts: 56

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

Bruce_L
Posted : Friday, January 12, 2018 11:40:48 AM


Worden Trainer

Joined: 10/7/2004
Posts: 61,564

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
Personal Criteria Formulas
TC2000 Support Articles
f.lb
Posted : Friday, January 12, 2018 12:05:12 PM
Gold Customer Gold Customer

Joined: 4/3/2012
Posts: 56

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

 

Bruce_L
Posted : Friday, January 12, 2018 12:11:56 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,564

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
f.lb
Posted : Friday, January 12, 2018 12:15:05 PM
Gold Customer Gold Customer

Joined: 4/3/2012
Posts: 56

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?

Bruce_L
Posted : Friday, January 12, 2018 12:20:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,564

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
f.lb
Posted : Friday, January 12, 2018 12:55:48 PM
Gold Customer Gold Customer

Joined: 4/3/2012
Posts: 56

Thanks now works!!!!!

Sorry for the misunderstanding

Bruce_L
Posted : Friday, January 12, 2018 12:56:15 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,564

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.