Syntax

The MACD is implemented as a composite function. The expression is:  

SUB(EMA(A1;12); EMA(A1;26))

Arguments

A1 must be an array.

Result

The result is an array. 

Description

The MACD is a trend-following momentum indicator that shows the relationship between two moving averages of prices. It is calculated by subtracting the value of a 26-day exponential moving average from a 12-day exponential moving average. The MACD proves most effective in wide-swinging trading markets. 

In a market that is accelerating upwards, the short moving average will rise faster than the longer moving average. This will lead to a rising MACD. 

In a market that is accelerating downwards, the short moving average will fall faster than the longer moving average. This will lead to a falling MACD. 

The MACD was developed by Gerald Appel. 

Related Examples

Windows Forms: Data Manipulation\Functions\Other Financial Functions