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

Saturday, October 7, 2017

SAP GUI 740 : save password in shortcut

Run : regedit.ext

Path : HKEY_CURRENT_USER\Software\SAP\SAPShortcut\Security\
EnablePassword = 1