c_daily_traded_value_sma_5d#

c_daily_traded_value_sma_5d(c_daily_traded_value)[source]

Calculate the 5-day simple moving average of the daily traded value.

Parameters:

c_daily_traded_value (DataColumn) – The daily traded value.

Returns:

The 5-day moving average of the daily traded value.

Return type:

DataColumn

Notes

The 5-day moving average is computed as:

\[\mathrm{MA}_{5} = \frac{1}{5} \sum_{i=1}^{5} \mathrm{Daily\ Traded\ Value}_{i}\]

In Excel, assuming your daily traded values are in column A starting at cell A2:

  1. In cell B6, enter:

    =AVERAGE(A2:A6)

  2. Drag the formula from cell B6 down to calculate the 5-day moving average for the rest of the rows.