Skip to content

Mutual Fund Portfolio Tracker

Article:

Excel-based Mutual Fund Portfolio Tracker (Version 1)

Tracker:

Download the Mutual Fund Excel Tracker

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

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)


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!

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.

      Reply
  1. Grandad

    Many thanks for what you are doing. I learnt about you from subramoney.com. 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 moneycontrol.com 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?

    Reply
    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?

      Reply
  2. SUMIT

    SIR PLEASE POST ME LINK FOR AUTOMATED TRACKER FOR MUTUAL FUNDS..UNABLE TO SEE THE LINK..THANKS AND REGARDS

    Reply

Do let us know what you think about the article

%d bloggers like this: