Mutual Fund Portfolio Tracker


Excel-based Mutual Fund Portfolio Tracker (Version 1)


Download the Mutual Fund Excel Tracker

Statutory Warning: Refreshing NAV everyday and staring at MF holdings can be injurious to your fiscal health 

Register for the Hyderabad DIY Investor Workshop Nov 27th 2016

Check out the latest mutual fund returns listing


Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam ( & M Pattabiraman. Hard bound. Price: Rs. 399/- (Rs. 359/- at Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Do more with freefincal!

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

6 thoughts on “Mutual Fund Portfolio Tracker

    1. pattu

      Please wait for my automated tracker. You can use separate sheets for direct and regular investments and consolidate them for portfolio return calculation. If you want a beta version, let me know and I will send it to you.

  1. Grandad

    Many thanks for what you are doing. I learnt about you from These are comments / requests from an "Excel challenged" reader. I periodically make lump sum investments (not SIPs) in 4 mutual funds (all large cap equity funds, all in dividend payout option). Is there a "program" that will give me: amount invested -- dividend returns -- NAV appreciation -- "real return" over a period of time? I downloaded your "excel-tracker-v2-sip1" but was floored by its complexity. It takes for granted a reasonable knowledge of Excel which I do not possess. I tried the portfolio manager in but it is not helpful. I would value your comments and advice.

    Is there a similar program to look at a portfolio of equity shares running on a "buy and hold for decades" policy?

    1. pattu

      Thank you. I would like to think the present tracker is more user friendly. Please do give it a spin. This calculates CAGR by assuming dividends are reinvested.
      Can you point me to a div return or div yield calculation for mutual funds? I am unable to find one.
      Also can you define what you mean by real return? Do you mean absoluter return?


Do let us know what you think about the article