c_chaikin_money_flow_21d_split_adjusted#

c_chaikin_money_flow_21d_split_adjusted(m_high_split_adjusted, m_low_split_adjusted, m_close_split_adjusted, m_volume_split_adjusted)[source]

Calculate the 21-day Chaikin Money Flow (CMF) using split-adjusted prices.

Parameters:

  • m_high_split_adjusted (DataColumn) – The adjusted high prices.

  • m_low_split_adjusted (DataColumn) – The adjusted low prices.

  • m_close_split_adjusted (DataColumn) – The adjusted close prices.

  • m_volume_split_adjusted (DataColumn) – The market volume.

Returns:

The 21-day Chaikin Money Flow.

Return type:

DataColumn

Notes

Money flow volume (MFV) for each period is:

\[\mathrm{MFV}_t = \frac{ (\mathrm{Close}_t - \mathrm{Low}_t) - (\mathrm{High}_t - \mathrm{Close}_t) }{ \mathrm{High}_t - \mathrm{Low}_t } \times \mathrm{Volume}_t\]

Chaikin Money Flow over 21 days is:

\[\mathrm{CMF}_{21} = \frac{ \sum_{i=1}^{21} \mathrm{MFV}_i }{ \sum_{i=1}^{21} \mathrm{Volume}_i }\]

In Excel, assuming adjusted high in column A, adjusted low in column B, adjusted close in column C, and volume in column D (starting at row 2):

  1. In cell E2, enter:

    =(((C2 - B2) - (A2 - C2)) / (A2 - B2)) * D2

  2. Drag the formula down through cell E22.

  3. In cell F22, enter:

    =SUM(E2:E22) / SUM(D2:D22)

  4. Drag the formula down through column F.