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

MACD Histogram Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
RODT
Posted : Monday, May 14, 2012 5:07:52 PM
Registered User
Joined: 1/9/2005
Posts: 18

I was looking for help on TC2000 Ver 7 MACD histogram formulas and found this one by Craig S from 2004 which I think has an error - see below:

Here is the posting by Craig:

MACD Today
(XAVGC20-XAVGC40)

MACD Crossing Up Through Zero Today
(XAVGC20.1-XAVGC40.1)<0 AND (XAVGC20-XAVGC40)>0

MACD Crossing Down Through Zero Today
(XAVGC20.1-XAVGC40.1)>0 AND (XAVGC20-XAVGC40)<0

MACD Histogram Today
(XAVGC20-XAVGC40)-(XAVG(XAVGC30,20)-XAVG(XAVGC40,30))

MACD Histogram Crossing From Negative to Positive Today
(XAVGC20-XAVGC40)>(XAVG(XAVGC30,20)-XAVG(XAVGC40,30)) AND (XAVGC20.1-XAVGC40.1)<(XAVG(XAVGC30.1,20)-XAVG(XAVGC40.1,30))

MACD Histogram Crossing From Positive to Negative Today
(XAVGC20-XAVGC40)<(XAVG(XAVGC30,20)-XAVG(XAVGC40,30)) AND (XAVGC20.1-XAVGC40.1)>(XAVG(XAVGC30.1,20)-XAVG(XAVGC40.1,30))


 The MAs are 20 & 40 and the period is 30 so should not the parts in the formula shown as (XAVGC30,20) actually be (XAVGC20,30)? Same for (XAVGC30.1,20) are not the 20 & 30 transposed?

 

Bruce_L
Posted : Monday, May 14, 2012 5:11:22 PM


Worden Trainer

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

XAVG(XAVGC30,20) and XAVG(XAVGC20,30) will return exactly the same results.

The reason it was written this way in the original topic was because there was a time when the XAVG() function would not accept an XAVGC indicator as an argument if the XAVGC indicator's period was greater than the period of the XAVG() function.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
RODT
Posted : Monday, May 14, 2012 5:36:49 PM
Registered User
Joined: 1/9/2005
Posts: 18

Thanks for the explanation. But if I have an MACD 40,30,20  as opposed to 40:20:30 should they not have different results? Your explanation would indicate that the results are the same.

Bruce_L
Posted : Tuesday, May 15, 2012 7:54:13 AM


Worden Trainer

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

Yes, you would get different results.

XAVGC40 - XAVGC30 - XAVG(XAVGC40,20) + XAVG(XAVGC30,20)

Will return the same results as:

XAVGC40 - XAVGC30 - XAVG(XAVGC20,40) + XAVG(XAVGC20,30)

Both would be accurate representations of an Exponential MACD Histogram 40,30,20.

An Exponential MACD Histogram 40,20,30 would change both the second and third terms in a way which would not return the same results however:

XAVGC40 - XAVGC20 - XAVG(XAVGC40,30) + XAVG(XAVGC20,30)

The second term changes from being a 30-Period Exponential Moving Average to a 20-Period Exponential Moving Average and the third term changes from being a 20-Period Exponential Moving Average of a 40-Period Exponential Moving Average to a 30-Period Exponential Moving Average of a 40-Period Exponential Moving Average.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mrcauldwell
Posted : Saturday, June 9, 2012 9:05:12 PM
Registered User
Joined: 12/18/2010
Posts: 5

If

MACD Histogram Today
(XAVGC20-XAVGC40)-(XAVG(XAVGC30,20)-XAVG(XAVGC40,30))

Does that mean that MACD Histogram ticking up can be calculated by this formula?

(XAVGC20-XAVGC40)-(XAVG(XAVGC30,20)-XAVG(XAVGC40,30)) > (XAVGC20.1-XAVGC40.1)-(XAVG(XAVGC30.1,20)-XAVG(XAVGC40.1,30))

 

Thank you!

StockGuy
Posted : Sunday, June 10, 2012 10:39:03 AM

Administration

Joined: 9/30/2004
Posts: 9,187

QUOTE (mrcauldwell)

If

MACD Histogram Today
(XAVGC20-XAVGC40)-(XAVG(XAVGC30,20)-XAVG(XAVGC40,30))

Does that mean that MACD Histogram ticking up can be calculated by this formula?

(XAVGC20-XAVGC40)-(XAVG(XAVGC30,20)-XAVG(XAVGC40,30)) > (XAVGC20.1-XAVGC40.1)-(XAVG(XAVGC30.1,20)-XAVG(XAVGC40.1,30))

 

Thank you!

Yes that will return True if MACD is > the previous MACD value.

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.