freefincal

Simple how-to articles and free tools for financing your goals, managing your money, mutual fund and stock investments

Mutual Fund Portfolio Comparison Tool

This is an update to the popular Equity Mutual Fund Portfolio Overlap Checker

In this edition I have included all open-ended mutual funds from Value Research Online.

The tool extracts data from the portfolio page of VR Online for 3 mutual funds and determines

  • the composition of equity and debt portfolios and plots a bar chart
  • the overlap in portfolio among equity and equity oriented balanced funds (a suggestion by Ms. C K Aparna)
  • common stocks among equity and equity oriented balanced funds and gives the combined value of each stock holding if the user inputs value of investment (a suggestion by Mr. V Muthu Krishnan)

There are some issues with portfolio comparison with debt and debt oriented balanced funds. If you are interested in such comparisons let me know. I will sort them out and post an updated version.

Here are some screenshots:

comparison-0

The main data entry page

comparison-0B

Comparing portfolios of PPFAS LTVF, Franklin India Blue Chip and HDFC Balanced 

comparison-1

Portfolio composition of Reliance MIP, HDFC Income Fund & Templeton India Govt Securities fund

Moneycontrol edition: Equity Mutual Fund Portfolio Comparison Tool (Oct 2016) Thanks to Prakash Warty for pointing out a bug (now corrected).

Download the Updated Equity Mutual Fund Portfolio Comparison Tool (old version)

Subscribe and join the freefincal Youtube community!

 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media


Do check out my books


You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create customg solutions for your lifestye!Get it now.  It is also available in Kindle format.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you want My second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a youngearner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

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


Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
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.
Updated: October 11, 2016 — 2:58 pm

93 Comments

  1. thank you for better version. i tried my funds. i think, there is a little error in ‘results-advanced sheet’ for value of common stock. perhaps requires to divide by 100.
    my understanding is: ‘results-simple’ gives % of no. of common shares among two funds , and not of values. am i correct?

    1. Thank you. I have added the /100 and corrected it. The % overlap refer to no of common stocks and not of values as you state.

  2. thank you for better version. i tried my funds. i think, there is a little error in ‘results-advanced sheet’ for value of common stock. perhaps requires to divide by 100.
    my understanding is: ‘results-simple’ gives % of no. of common shares among two funds , and not of values. am i correct?

    1. Thank you. I have added the /100 and corrected it. The % overlap refer to no of common stocks and not of values as you state.

  3. further to my above comment , i think , ‘result simple’ seems showing %of value of two funds’ common shares’ values combined.
    i could not find ‘icici prudential discovery -direct fund in drop down list.

    1. Result simple is not showing % value. It is the % of common shares. Please type ‘discovery’ to get ICICI pru discovery. Thank you.

  4. further to my above comment , i think , ‘result simple’ seems showing %of value of two funds’ common shares’ values combined.
    i could not find ‘icici prudential discovery -direct fund in drop down list.

    1. Result simple is not showing % value. It is the % of common shares. Please type ‘discovery’ to get ICICI pru discovery. Thank you.

  5. thank you for your reply. just for understanding ,i like to know how you derive % of common shares in two concerned funds :1. the common shares no. as % of bigger no. of fund,2. the common shares no .as % of smaller no . of fund 3. the common no.of shares as % of average no. of two funds or 4. something different, as i could not derive matching with the result in ‘result-simple’ for my 3 funds:hdfc equity direct, templeton india equity income and qlte.

    1. I compare portfolios in VRO and determine common stocks as simple as that. VRO lists about 25 stocks in each fund. Among these I check the overlap and display returns as percentage wrt 25.

  6. thank you for your reply. just for understanding ,i like to know how you derive % of common shares in two concerned funds :1. the common shares no. as % of bigger no. of fund,2. the common shares no .as % of smaller no . of fund 3. the common no.of shares as % of average no. of two funds or 4. something different, as i could not derive matching with the result in ‘result-simple’ for my 3 funds:hdfc equity direct, templeton india equity income and qlte.

    1. I compare portfolios in VRO and determine common stocks as simple as that. VRO lists about 25 stocks in each fund. Among these I check the overlap and display returns as percentage wrt 25.

  7. Why limit the tool for 3 funds?

    1. list the number of permutations and combinations needed for 3 funds, 4 funds and 5 funds. The answer will be clear to you.

  8. Why limit the tool for 3 funds?

    1. list the number of permutations and combinations needed for 3 funds, 4 funds and 5 funds. The answer will be clear to you.

  9. Simply Excellent

    1. Thank you! Do keep visiting and try out the other tools.

  10. Simply Excellent

    1. Thank you! Do keep visiting and try out the other tools.

  11. I landed with this excel after reading your post on whether Rupeer cost averaging works or not. This calculator gave better insights to my funds , it surprised to me the amount of exposure on some stocks I never expected because of the overlaps. Great work sir.

    1. Thank you. Keep visiting.

  12. I landed with this excel after reading your post on whether Rupeer cost averaging works or not. This calculator gave better insights to my funds , it surprised to me the amount of exposure on some stocks I never expected because of the overlaps. Great work sir.

    1. Thank you. Keep visiting.

  13. I installed MS office 2010 in linux just to use this excel tool. To my knowledge morning star X-ray is the only other tool offering this analysis.

    Many thanks for your time and effort in creating this. It will be good to have the risk & return measure also included in this to have a one stop portfolio analysis tool.

    HDFC Top200 and Quantum long term equity have 40% overlap in portfolio which is surprising.

    1. Thank you. I will try and add risk and return measures asap.

  14. I installed MS office 2010 in linux just to use this excel tool. To my knowledge morning star X-ray is the only other tool offering this analysis.

    Many thanks for your time and effort in creating this. It will be good to have the risk & return measure also included in this to have a one stop portfolio analysis tool.

    HDFC Top200 and Quantum long term equity have 40% overlap in portfolio which is surprising.

    1. Thank you. I will try and add risk and return measures asap.

  15. my computer is not reading this tool ??

  16. my computer is not reading this tool ??

  17. I am trying to use this to compare Franklin Bluechip, ICICI Focused Bluechip and UTI opportunity. In result-simple sheet, %equity portfolio are not coming correct. Its showing 79.62, 78.43 and 83.2 for these 3 funds whereas VR online shows 97.1, 96.61 and 97.2 respectively. Am I missing something?

    1. Hi Brijesh, Although Franklin Blue Chip has 97.1% equity, VR online lists only 79.62% and the sheet uses only these.

  18. I am trying to use this to compare Franklin Bluechip, ICICI Focused Bluechip and UTI opportunity. In result-simple sheet, %equity portfolio are not coming correct. Its showing 79.62, 78.43 and 83.2 for these 3 funds whereas VR online shows 97.1, 96.61 and 97.2 respectively. Am I missing something?

    1. Hi Brijesh, Although Franklin Blue Chip has 97.1% equity, VR online lists only 79.62% and the sheet uses only these.

  19. Hi Pattu,

    Their has been recent article in ET Wealth on how to select MF schemes (http://economictimes.indiatimes.com/mf/analysis/how-to-pick-the-best-performing-mutual-fund-schemes/articleshow/40314626.cms)

    Just wanted your expert views on the Consistent Performer MF Schemes and their selection process

    regards,

    karthik

    1. Disagree with “A better way to gauge performance would be to look at yearly returns and opt for funds that consistently feature in the top-quartile of performance every year. What should one do if they fall (and they will) from the top quartile? I would prefer to short-list some funds with the step-by-step guide, then use my risk and return analyse to check for consistency over 8Y. The rolling returns calculator can also be used.

  20. Hi Pattu,

    Their has been recent article in ET Wealth on how to select MF schemes (http://economictimes.indiatimes.com/mf/analysis/how-to-pick-the-best-performing-mutual-fund-schemes/articleshow/40314626.cms)

    Just wanted your expert views on the Consistent Performer MF Schemes and their selection process

    regards,

    karthik

    1. Disagree with “A better way to gauge performance would be to look at yearly returns and opt for funds that consistently feature in the top-quartile of performance every year. What should one do if they fall (and they will) from the top quartile? I would prefer to short-list some funds with the step-by-step guide, then use my risk and return analyse to check for consistency over 8Y. The rolling returns calculator can also be used.

  21. Its amazing to see such wonderful stuff.

    1. Thank you very much. Please do use the tools and let me know your feedback. I would appreciate if you share the links with your social contacts.

  22. Its amazing to see such wonderful stuff.

    1. Thank you very much. Please do use the tools and let me know your feedback. I would appreciate if you share the links with your social contacts.

  23. Dear Pattu,

    This is an wonderful tool. It works like a breeze and very handy one to have.

    Just following up on one of the requests in the comments section about adding risk measures. Is it something you have already done and available elsewhere in the site? If not, is it possible for you to do that?

    Second question is about the addition of more number of units to compare. Again it was discussed in the comments section but didn’t understand what you were trying to say. Can you please explain that a bit more for my understanding? Thanks!

    1. Thank you. See my latest post on risk-return measures and how one can use them.
      http://freefincal.com/herding-icici-pru-focused-blue-chip-vs-icici-pru-top-100/

      If you add more funds, the permutations and combinations will become too high for Excel to handle. It will become a mess.

  24. Dear Pattu,

    This is an wonderful tool. It works like a breeze and very handy one to have.

    Just following up on one of the requests in the comments section about adding risk measures. Is it something you have already done and available elsewhere in the site? If not, is it possible for you to do that?

    Second question is about the addition of more number of units to compare. Again it was discussed in the comments section but didn’t understand what you were trying to say. Can you please explain that a bit more for my understanding? Thanks!

    1. Thank you. See my latest post on risk-return measures and how one can use them.
      http://freefincal.com/herding-icici-pru-focused-blue-chip-vs-icici-pru-top-100/

      If you add more funds, the permutations and combinations will become too high for Excel to handle. It will become a mess.

  25. I find this calculator very useful. Here you have took the reference from VRonline details. I appreciate, if you can update the existing calulator with following :
    1) Use Data from moneycontrol.com- link between bracket for example.(http://www.moneycontrol.com/india/mutualfunds/mfinfo/portfolio_holdings/MTE182)They have provided complete(100 %) portfolio holdings.
    2) Instead of 3 scheme comparision option provide for more number of scheme e.g. 20 MF schemes, objective is that I would like to analyze equitywise % holdings from total 20 MF schemes.
    3) Use moneycontrol.com(http://www.moneycontrol.com/india/mutualfunds/mfinfo/portfolio_holdings/MTE182)to fetch the currently selected 3 schemes and provide Total equity holdings(%) of total 3 schemes.

    Thanks and hoping for your positive response at your ease time.

    1. Hi Dilip, will check Moneyconrol. Trouble is how the url is formed. Comparing 20 schemes will be cumbersome. Even 4 is trouble. Thank you.

    2. Thanks Dilip. Trouble is with how the moneycontorl forms the url. In any case 20 will be cumbersome. Will have a look. Thank you.

  26. I find this calculator very useful. Here you have took the reference from VRonline details. I appreciate, if you can update the existing calulator with following :
    1) Use Data from moneycontrol.com- link between bracket for example.(http://www.moneycontrol.com/india/mutualfunds/mfinfo/portfolio_holdings/MTE182)They have provided complete(100 %) portfolio holdings.
    2) Instead of 3 scheme comparision option provide for more number of scheme e.g. 20 MF schemes, objective is that I would like to analyze equitywise % holdings from total 20 MF schemes.
    3) Use moneycontrol.com(http://www.moneycontrol.com/india/mutualfunds/mfinfo/portfolio_holdings/MTE182)to fetch the currently selected 3 schemes and provide Total equity holdings(%) of total 3 schemes.

    Thanks and hoping for your positive response at your ease time.

    1. Hi Dilip, will check Moneyconrol. Trouble is how the url is formed. Comparing 20 schemes will be cumbersome. Even 4 is trouble. Thank you.

    2. Thanks Dilip. Trouble is with how the moneycontorl forms the url. In any case 20 will be cumbersome. Will have a look. Thank you.

  27. % overlap among hdfc balanced & hdfc mid-cap is 52% , so do I need to re-allocate to other fund. what would you suggest.

    1. Dont do this immediatly. Also, you can tag them to different goals.

  28. % overlap among hdfc balanced & hdfc mid-cap is 52% , so do I need to re-allocate to other fund. what would you suggest.

    1. Dont do this immediatly. Also, you can tag them to different goals.

  29. Simply superb Pattusir…

  30. Simply superb Pattusir…

  31. Hi Pattu Sir, This helped me to identify overlap among my SIP mutual funds. I have 40% overlap of Franklin blue chip and Quantum LTE with ICICI pru discovery…I would like to to stop Frnk Blue chip & Quantum LTE and go with Franklin India Smaller Companies Fund…My other SIPs are IDFC premier Equity & Frank High growth fund…Any comments?

    1. Have about 50-60% large cap exposure at any point in time. Do not go overboard on mid and small cap. Too risky.

  32. Hi Pattu Sir, This helped me to identify overlap among my SIP mutual funds. I have 40% overlap of Franklin blue chip and Quantum LTE with ICICI pru discovery…I would like to to stop Frnk Blue chip & Quantum LTE and go with Franklin India Smaller Companies Fund…My other SIPs are IDFC premier Equity & Frank High growth fund…Any comments?

    1. Have about 50-60% large cap exposure at any point in time. Do not go overboard on mid and small cap. Too risky.

  33. Hi, this is a fantastic looking tool , like all others …but i keep getting error 436. I am using mac office 2010… is that the reason?

    1. Thank you. Unfortunately yes. That is the reason.

  34. Hi, this is a fantastic looking tool , like all others …but i keep getting error 436. I am using mac office 2010… is that the reason?

    1. Thank you. Unfortunately yes. That is the reason.

  35. Hi,

    Recently came across your site when I was trying to get some research on L&T Equity fund. Would you have a view on it? Pl do share. I started a SIP 3 months back and see it VR rating has gone down from 5 to 3 stars and its performance is dipping MoM.

    Also, I am trying to use this MF Portfolio comparison tool. The excel I downloaded does have the option to select the funds from a drop down menu as suggested in the screen shots above. Do I need to link the MF I want to compare in these cells?

    1. I have plenty of tools to analyze funds yourself. I have also reviewed a few funds as an illustration. In the portfolio comparison tool, please follow instructions in the sheet to select your fund. Will only work in Windows Excel.

  36. Hi,

    Recently came across your site when I was trying to get some research on L&T Equity fund. Would you have a view on it? Pl do share. I started a SIP 3 months back and see it VR rating has gone down from 5 to 3 stars and its performance is dipping MoM.

    Also, I am trying to use this MF Portfolio comparison tool. The excel I downloaded does have the option to select the funds from a drop down menu as suggested in the screen shots above. Do I need to link the MF I want to compare in these cells?

    1. I have plenty of tools to analyze funds yourself. I have also reviewed a few funds as an illustration. In the portfolio comparison tool, please follow instructions in the sheet to select your fund. Will only work in Windows Excel.

  37. Hi… I am not able to use this sheet. When i click on “Click to Compare”, one visual studio error window is coming ” Runtime error 1004 . Unable to open ….. “. Please suggest how to rectify this issue.

    1. I am getting same error, Look like Value research changes something causing web query to fail. R has analysis tab that does some of this (not everything, this tool is very thoughtful).

      On another note, VR publishes oly top 25 holdings. This most of the time make up for less than 50 % of portfolio. Moneycontrol has everything in it, but it is more difficult to grab data from there. I wish AMFI had api where all thi information was stored.

      Also there is big time need of having something like epersonalcapital.com in india.

      1. Hi, I just checked the sheet and it works fine. Yes the full portfolio is a limitation. Will check if I get it from Money Control

        1. Looks like you have worked on this, Spreadsheet looks awesome.

          1. Thanks. Yes, I forgot to tell you about it. Inspired by your comment.

  38. Hi… I am not able to use this sheet. When i click on “Click to Compare”, one visual studio error window is coming ” Runtime error 1004 . Unable to open ….. “. Please suggest how to rectify this issue.

    1. I am getting same error, Look like Value research changes something causing web query to fail. R has analysis tab that does some of this (not everything, this tool is very thoughtful).

      On another note, VR publishes oly top 25 holdings. This most of the time make up for less than 50 % of portfolio. Moneycontrol has everything in it, but it is more difficult to grab data from there. I wish AMFI had api where all thi information was stored.

      Also there is big time need of having something like epersonalcapital.com in india.

      1. Hi, I just checked the sheet and it works fine. Yes the full portfolio is a limitation. Will check if I get it from Money Control

        1. Looks like you have worked on this, Spreadsheet looks awesome.

          1. Thanks. Yes, I forgot to tell you about it. Inspired by your comment.

  39. Sir I am getting run time error 438 on Excel for mac. Is there something which needs to be changed ? Has this been tested on mac ?

    1. Sorry Will not work on Mac. My Mac is on the way. So will try and convert this soon.

  40. The update to mutual fund portfolio comparison tool has made it even better. The tool saves lot of hard work by analyzing various factors for you. I liked the way it presents the data through clean bar charts rather than just show dry figures. It is very quick and interactive too.

  41. Pattu Sir,

    Thanks a lot for the tool.

    However, the percent overlap changes depending on the order in which the funds are entered.
    It computes the overlap with respect to the fund name entered at the top.

    I did the following changes to get the percentage of common shares for both the funds in the pair:
    Un-merged the cells in column B showing the overlap percentage.
    Copied the formula for overlap to the bottom cell and changed the cell reference for the denominator.
    Kept the same numerator which gives the number of common shares.

    This way, I get the percentage of shares for each fund which it has in common with the other.

    I was wondering why you were showing the overlap only for one of the funds, especially since the order of funds would lead to different answers.

  42. Thanks NIkhil. Can you please send your version to me? I will post it with a credit to you. This way everyone will benefit. Thank you.

  43. Dear Pattu Sir, seems the Aug2016 version somehow non-functional. It gives Microsoft Visual Basic error 1004. Points some issues copy/pasting due to size variation. Thanks.

  44. I found a problem with the Aug2016 version. I compared two Quantum funds, Long Term Equity and Tax Savings. The latter replicates the portfolio of the former. The Results-simple tab shows the number of stocks 18 & 25 for LTE & Tax Savings funds resp. As a result the overlap section shows 5% overlap between the two funds and 1 common stock. The stocks in the portfolio of the funds show in mf1 and mf2 are identical with 24 stocks in both the funds. There is a 100% overlap between the two funds. The histogram in the Results-simple showing the industry-wise holding of stocks for both the funds is correct. They are identical.
    The data in Sheet1 from where the stock count is derived may be the problem. I have not understood how the data is populated in this sheet.
    There is no data in the Results-advanced and common sheets.

    1. Hi Prakash, thanks for pointing this out. I have now fixed this and reuploaded the file. Please do give it a go with other funds and let me know if there are any issues.

  45. This is fixed. Thanks. I tested with a couple of other funds and it has worked. The Results-advanced sheet appears to be blank, but some data is populated with data from row 78.

  46. There is still a small bug when I try to run this on my Mac. I get the error

    Run Time error 1004

    Method Default of object ‘Range’ failed.

    When I hit the debug button. This is around the line where it fails.

    Range(Cells(startv,1), Cells(endv-1, 5)).Select.

    Let me know. If needed I can share screenshots. It is failing for old calculator as well.

  47. Failing on Mac

    1. Becuase it will not work there.

  48. WISH TO NOW OTHER AMC ARE INCLUDED OR NOT , SAY LOOKING FOR LT FUND

Comments are closed.

freefincal © 2019 Frontier Theme