Excel VBA - Moving Average Convergence Divergence (MACD)

A signal line (or trigger line) is then formed by smoothing this with a further EMA. The standard period for this is 9 days,

Interpretation

MACD lines are often regarded as a trend following indicator designed to identify trend changes. The MACD histogram as drawn above is sometimes used as an oscillator. Three types of trading signals are generated:

• • MACD line crossing the signal line.

  • MACD line crossing 0.

  • Divergence between price and histogram, or between MACD line and price.

The signal line crossing is the usual trading rule. The standard interpretation is to buy when the MACD crosses up through the signal line, or sell when it crosses down through the signal line. These crossings may occur too frequently, and other tests may have to be applied.

The histogram shows when a crossing occurs. When the MACD line crosses through zero on the histogram it is said that the MACD line has crossed the signal line. The histogram can also help visualizing when the two lines are coming together. Both may still be rising, but coming together, so a falling histogram suggests a crossover may be approaching.

A crossing of the MACD line up through zero is interpreted as bullish, or down through zero as bearish. These crossings are of course simply the original EMA(12) line crossing up or down through the slower EMA(26) line.

Positive divergence between MACD and price arises when price makes a new selloff low, but the MACD doesn't make a new low (i.e. it remains above where it fell to on that previous price low). This is interpreted as bullish, suggesting the downtrend may be nearly over. Negative divergence is the same thing when rising (i.e. price makes a new rally high, but MACD doesn't rise as high as before), this is interpreted as bearish.

Divergence may be similarly interpreted on the price versus the histogram, where the new price levels are not confirmed by new histogram levels. Longer and sharper divergences (distinct peaks or troughs) are regarded as more significant than small shallow patterns in this case.

It is recommended to look at a MACD on a weekly scale before looking at a daily scale to avoid making short term trades against the direction of the intermediate trend.

Sometimes it is prudent to apply a price filter to the Bullish Moving Average Crossover to ensure that it will hold. An example of a price filter would be to buy if MACD breaks above the 9-day EMA and remains above for three days. The buy signal would then commence at the end of the third day.

Signal Processing

The MACD is a filtered measure of the velocity. The velocity has been passed through two first order linear low pass filters. The "signal line" is that resulting velocity, filtered again. The difference between those two, the histogram, is a measure of the acceleration, with all three filters applied. The "MACD crossing the signal line" suggests that the direction of the acceleration is changing. "MACD line crossing zero" suggests that the average velocity is changing direction.