hello dear collegues, is there someone who could explain me how to get the MFI curve from excel? I have on first column the seconds I filtered and on the other is the Volume of water. I really need help :)
There are a several steps involved in the Money Flow Index calculation. The example below is based on a 14-period Money Flow Index, which is the default setting in SharpCharts and the setting recommended by the creators.
First notice that Raw Money Flow is essentially dollar volume because the formula is volume multiplied by the typical price. Raw Money Flow is positive when the typical price advances from one period to the next and negative when the typical price declines. The Raw Money Flow values are not used when the typical price is unchanged. The Money Flow Ratio in step 3 forms the basis for the Money Flow Index (MFI). Positive and Negative Money Flow are summed for the look-back period (14) and the Positive Money Flow sum is divided by the Negative Money Flow sum to create the ratio. The RSI formula is then applied to create a volume-weighted indicator. The table below shows a calculation example taken from an excel spreadsheet.