Chaikin Money Flow (CMF)
Chaikin Money Flow (CMF) is a volume-weighted average of accumulation and distribution over a specified period. It measures buying and selling pressure. A CMF above zero indicates buying pressure (accumulation), while a CMF below zero indicates selling pressure (distribution).
CMF
=CMF(data, period) Example Usage
=CMF(A2:F500, 20)
Parameters
| Parameter | Type | Description | Status |
|---|---|---|---|
data | Range | The input range of columns containing the Date, Open, High, Low, Close, and Volume data. | Required |
period | Number | The number of periods (e.g., 20 or 21) for the lookback window. | Required |
Returns
A two-column array of dates and their corresponding CMF values.