- This is an update to the Excel Mutual Fund NAV History Downloader posted a few days ago.
- I have now included the possibility of retrieving NAV history from the AMFI website in addition to Yahoo! Finance.
- Can retrieve NAV history of all mutual funds from AMFI up to April 3rd 2006
- If you need NAV history from fund inception then you could try Yahoo! Finance.
- Unfortunately, as pointed out by Raghav in the above post, Yahoo! Finance does not use the AMFI code for all mutual funds. So NAV history of funds like HDFC Top 200 cannot be retrieved. Will have to use AMFI for such funds.
- In the future if an NFO is available the fund name as listed in AMFI and AMFI fund code will need to be added to this tool if you wish to retrieve NAV history.
Wake of a Ferry Boat. Photo Credit: Andrew Farquhar (Flickr)
Update: AMFI changed their web address from http://www.amfiindia.com to http://portal.amfiindia.com
Here is updated calculator incorporating this change
Excel 2007 with macros. If you need .xls files, leave a comment.
Coming Soon: Mutual Fund SIP Returns Analyzer
Have you checked out the other mutual fund and equity calculators/resources available?
- Equity Mutual Fund Analyzer -Lite
- Excel-based Mutual Fund Portfolio Tracker (Version 1)
- Comprehensive MF Investment Mode Comparator
- Rolling Returns Calculator
- Direct vs. Regular MF-Returns Comparison
- Step-by-step Guide to Choosing a Mutual Fund
- Daily vs. Monthly vs. Quarterly SIP
- Mutual Fund SIP Returns
- Sensex Rolling Returns with dividends
- SIP vs. VIP Comparator
- SIP vs. VIP Comparator – FundsIndia Report
- Direct vs. Regular Mutual Fund Comparator
- MF Expense Ratio Calculator
- DIY Mutual Fund Analysis
- Generating Mutual Fund SIP Account Statements and Calculating Returns With NAV History
- Excel Mutual Fund NAV History Downloader (Yahoo! Finance)
Subscribe to get posts via email
|You Can Be Rich Too With Goal-based Investing A book that can help you ask the right questions about money and find simple solutions. Comes with nine online calculator modules. Read more about the book and order now!|
GameChanger - Forget Startups, Join Corporate & Still Live The Rich Live You want Take that international trip at 50% lower costs! Optimise credit card usage! Set money management on auto-pilot! Read more about the book and order now!