I have develop VBA Macro to import India mutual fund NAV from http://www.amfiindia.com into Excel.
New NAV Site : https://www.amfiindia.com/spages/NAVAll.txt
Excel File Link : Import mutual fund NAV into Excel
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



It doesn't work any more due to url change from amfi site
ReplyDelete