c_macd_signal_9d_dividend_and_split_adjusted#

c_macd_signal_9d_dividend_and_split_adjusted(c_macd_26d_12d_dividend_and_split_adjusted)[source]

Calculate the MACD signal line (9-day EMA of MACD) for dividend-and-split-adjusted close prices.

Parameters:: c_macd_26d_12d_dividend_and_split_adjusted (DataColumn) – The MACD values calculated from the 12-day and 26-day EMAs of the adjusted close prices.
Returns:: The MACD signal line values.
Return type:: DataColumn

Notes

MACD is computed as the difference between the 12-day and 26-day EMAs:

\[\mathrm{MACD}_{26,12} = \mathrm{EMA}_{12} - \mathrm{EMA}_{26}\]

The signal line is the 9-day EMA of the MACD series:

\[\mathrm{Signal}_9 = \mathrm{EMA}_9(\mathrm{MACD}_{26,12})\]

In Excel, assuming your adjusted close prices start in column A at cell A2:

Calculate the 12-day EMA: - In cell B13, enter:
```
=AVERAGE(A2:A13)
```
- In cell B14, enter:
```
=(A14*(2/(12+1)))+(B13*(1-(2/(12+1))))
```
- Drag the formula down through column B.
Calculate the 26-day EMA: - In cell C27, enter:
```
=AVERAGE(A2:A27)
```
- In cell C28, enter:
```
=(A28*(2/(26+1)))+(C27*(1-(2/(26+1))))
```
- Drag the formula down through column C.
Calculate the MACD line: - In cell D28, enter:
```
=B28 - C28
```
- Drag the formula down through column D.
Calculate the 9-day EMA of the MACD (signal line): - In cell E36, enter:
```
=AVERAGE(D28:D36)
```
- In cell E37, enter:
```
=(D37*(2/(9+1)))+(E36*(1-(2/(9+1))))
```
- Drag the formula down through column E.