Money Flow Index (MFI)

Combines price and volume data to identify overbought or oversold conditions.

Function Syntax

=MFI(data, period)  

• data (array):
  Range of columns containing the date, Open, high, Low, close, volume data.
• period (number):
  The number of periods (days) used to calculate the MFI. Typically 14 periods

Returns:
A two-column array of dates and their corresponding MFI values

Output Example

Below is an example of the resulting array when applying the custom =MFI() function.