c_simple_moving_average_63d_close_split_adjusted#

c_simple_moving_average_63d_close_split_adjusted(m_close_split_adjusted)[source]

Calculate the 63-day (3 month) simple moving average (SMA) of the split-adjusted close prices.

Parameters:

m_close_split_adjusted (DataColumn) – The adjusted close prices.

Returns:

The 63-day simple moving average.

Return type:

DataColumn

Notes

The 63-day simple moving average is computed as:

\[\mathrm{SMA}_{63} = \frac{1}{63} \sum_{i=0}^{63} \mathrm{Adjusted\ Close}_{t-i}\]

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

  1. In cell B6, enter:

    =AVERAGE(A2:A64)

  2. Drag the formula down to calculate the 63-day SMA for the rest of the rows.