Registered User Joined: 11/30/2004 Posts: 33
|
Trying to write a formula in 12.2 where MACD (X and S) is greater than the moving average today but was less than the moving average 5 days ago.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A Condition Formula for the Exponential MACD Histogram being above zero currently but below zero 5-bars ago could be written as (this is the same as the MACD being above its moving average now, but below it 5-bars ago):
XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.5 - XAVGC26.5 < XAVG(XAVGC12.5,9) - XAVG(XAVGC26.5,9)
A Simple version of this formula would just get rid of all six Xs in the formula.
Understanding MACD
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 11/30/2004 Posts: 33
|
Thank You.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|