Mutual Fund Portfolio Tracker

Article:

|amp|

Excel-based Mutual Fund Portfolio Tracker (Version 1)

Tracker:

|amp|
|amp|

Download the Mutual Fund Excel Tracker

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

Create a "from start to finish" financial plan with this free robo advisory software template


Free Apps for your Android Phone

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)

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

    1. 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