Mutual Fund Tracker in Excel

This Mutual Fund Tracker can track your Lumpsum Mutual Fund investments in excel. You can open this sheet anytime and see how much is your mutual funds worth and your current profit or loss. It will also should you the IRR% return you get on each of your mutual fund. Incase you want to track your SIP investments, you can update the total units of your mutual funds and it will update everything else on its own. Its fetching the mutual fund units from AMFI website and everytime you open this excel sheet, or refresh it , it will fetch the fresh data on its own. You should be connected to internet to fetch the fresh data. Note that the excel sheet requires MACRO’s to be enabled.


{ 5 comments… read them below or add one }

Rashmi January 21, 2013 at 12:46 pm


Why don’t we had with & without dividend column, with and without gain and also XIRR & IRR return with & without in %.



Jagoinvestor Wealth Club Support January 23, 2013 at 8:43 am


You can choose the mutual funds with dividend or without dividend option . Also this is a simple tracker with basic things to track , We can also come up with advanced tracker in future.


Jagmohan Puri January 21, 2013 at 12:51 pm

this is a nice tool,BUT HOW DO WE TRACK THE SIP’S THEN


Jagoinvestor Wealth Club Support January 23, 2013 at 8:42 am

Can you check the video . This tool is mainly for tracking the lumpsum investments , for SIP you will have to keep updating the NAV


Prasad February 2, 2013 at 12:27 pm

Hi Manish,

It is very nice excel. I used to track all my MF investments in excel and used to take latest NAV by going thro respective MF sites.
Due to your excel now i am able to get my investments in MFs latest value immediately.
thank you very much.


Cancel reply

Leave a Comment

{ 1 trackback }