Money Flow Index (MFI)
The Money Flow Index (MFI) is a momentum indicator that incorporates both price and volume data to measure buying and selling pressure. Often referred to as the “volume-weighted RSI,” the MFI is used to identify overbought or oversold conditions by analyzing the intensity of money flowing into and out of a security.
MFI
=MFI(data, period) Example Usage
=MFI(A2:F500, 14)
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 to calculate the MFI. Default is 14. | Optional |
Returns
A two-column array of dates and their corresponding MFI values.