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 

Get GameChanger (my second book) + Pranav's Travel Training Kit  GameChanger (hardcopy is now available for ₹279 (249 +30 for shipping) and the Travel Training Kit is available for immediate download for ₹150.

Register for the Kolkata DIY Investor meet:  May 28th2017

Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email

Your subscription is successful if you are directed to the "Welcome Page"

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

Find out if you have enough to say "FU" to your employer (Google Play Store)


Buy our New Book!

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

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.

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.

8 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