| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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?
|
|
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
|
|
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.
|
|
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
|
|
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!
|
|
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.
|
|
|
Guest-1 |