Friday, December 22, 2017

Excel Import Mutaul Fund NAV from www.amfiindia.com


I have develop VBA Macro to import India mutual fund NAV from http://www.amfiindia.com into Excel.

NAV Site : http://www.amfiindia.com/spages/NAV0.txt 
New NAV Site : https://www.amfiindia.com/spages/NAVAll.txt

1.Download Zip & extract Excel file Import MF NAV.xlsm
2.Open Excel file go to Tab MF
3.Get "Scheme code" of MF scheme from amfiindia.com

4.Enter Scheme code in column named "scheme code" who's nav you want to download.
 
5.Right click anywhere in sheet and hit MFnav or select ribbon Add-ins->MFnav

6.NAV imported from www.amfiindia.com