A Tool to Compare Equity Mutual Fund Portfolios

Use this excel tool to compare mutual fund stock holdings and determine the extent of portfolio overlap among your mutual fund holdings.  The tool can help you build a well-diversified equity portfolio. An investment portfolio should be diversified in two ways

  • Across asset classes like equity/stocks, bonds, gold, cash etc.  The allocation to each asset class depends on the duration available for investment and to a certain extent the risk profile of the individual. For effective allocation, we should have a realistic net rate of post-tax rate of return in mind.
  • Within each asset class.  The equity component of a portfolio should ideally consist of a basket of stocks that differ in market capitalization and countries.  Similarly, the debt component should consist of bonds of differing risk.

The main aim of diversifying within an asset class is to reduce the volatility (fluctuating returns) of the portfolio. Here is an example of how diversification across asset classes works. A portfolio of 25% stocks, 25% long term bonds, 25% gold and 25% cash/liquid(short-term) debt is known as the permanent portfolio. I had earlier reviewed its suitability as a low-volatility option by considering Sensex, fixed deposits, gold and a savings bank account  returns. Here is the plot of the historical returns of the individual assets: Sensex (left axes), FD/Gold/SB account  (right axes),  along with a portfolio (green) which consists of 25% of each asset class rebalanced each year.

An example of diversification across asset classes

pp-returns1

An example of diversification across asset classes

Notice that although the individual asset classes (stocks and gold and FDs) are volatile to varying extents, the volatility of the portfolio is much lower. Observe also the consistency of the (pre-tax) returns. Diversification within an asset class also works on the same idea but perhaps a little less dramatic. Adding small-cap and mid-cap stocks to an equity basket of large-cap stocks will decrease the volatility of the portfolio! This may seem counter-intuitive, as we are adding stocks of higher risk.  However, it should be kept in mind that large-cap stocks and mid-cap/small-cap stocks are not well correlated.  That is, mid-cap/small-cap stock prices do not depend heavily on large-cap stock prices. Therefore adding riskier stocks (or bonds) poorly correlated with existing stocks (or bonds) reduces the volatility of the portfolio. As an example, imagine two investors 'A' and 'B'. Investor A has an equity portfolio consisting only of Indian stocks. The equity portfolio of investor B has US, Indian, European, and Asian stocks. Who do you think made more returns in the last 5-6 years? If you would like to understand this concept better, I recommend you read, Think, Act and Invest like Warren Buffet by Larry E. Swedroe  (affiliate link) Mutual Funds The best and easiest way to diversify within and across asset classes is via mutual funds. While diversifying within an asset class it is important to buy mutual funds with very little overlap in their portfolios.  The number of mutual funds held does not matter. Holding 2-3 large-cap mutual funds alone is not diversification at all, as the portfolio of the funds would be largely identical. Therefore, the idea is to hold 2-3 mutual funds with little or no overall in portfolio holdings. The simplest way to do this would be invest in funds with different objectives. For example, a large-cap fund and a mid-/small-cap fund will have little or no portfolio overlap For example, IDFC Premier Equity and Franklin India Blue Chip have only 8% overlap between their stock holdings. Unfortunately, very few investors have mutual funds with little or no portfolio overlap. If there is an easy way to check the overlap in mutual fund stock holdings, we can all build ourselves a well diversified equity portfolio.

Equity Mutual Fund Portfolio Comparison Tool

Use this stock comparison tool to check the overlap in portfolios of three equity mutual funds. The excel file extracts the portfolio holdings from Value Research Online’s fund portfolio page and

  • determines the percentage of stock portfolio overlap.  This will indicate how diversified an investors equity portfolio is. Investors can then make suitable changes to improve diversification.
  • lists common stocks among three equity mutual funds.
  • displays the sector-wise allocation. This also an indication of diversification.

Here are some random results using this tool

mutual-fund-portfolio-stocks-comparisonUpdate:

Aug 2016: Download the Equity Mutual Fund Portfolio Comparison Tool

Moneycontrol edition: Equity Mutual Fund Portfolio Comparison Tool (Aug 2015)

Mutual Fund Portfolio Comparison Tool (May 2014)

 All opened-ended funds have now been included for comparing portfolio composition. Equity oriented balanced funds are also included.

Download the Equity Mutual Fund Portfolio Comparison Tool (Nov 2013) If you have tested this tool, please spare a moment to let me know your comments and suggestions.

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. 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.

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.

111 thoughts on “A Tool to Compare Equity Mutual Fund Portfolios

  1. Kamat

    Thank you so much. I was searching the Internet for the last few days without any luck for exactly this fund correlation calculator, so you post is very timely. I will test this for my portfolio.

    I started following your posts few months back and am loving it.

    Reply
      1. Kamat

        Pattu. It works like a charm and provides exactly what investors need.

        Your excel is unique in that it gives investors ability to compare overlap between a new fund they are considering and their existing portfolio, a feature, which many of even the paid utilities don't provide.

        Thanks to you, I have a much balanced portfolio now.

        If I could offer a small suggestion, it would be ability to compare less than or more than 3 funds depending on situation. Currently it seems it needs exactly 3 funds to compare.

        Reply
        1. pattu

          Thank you very much for trying it out. More than 3 funds would make it cumbersome for me to do the comparison.

          2 funds require 1 comparison
          3 funds 3 comp.
          4 funds req. 6 comparisons! and so on...

          So i cannot scale it like that. Yes the ability to turn off the 3rd fund will be useful. Easy enough to put this in. I had this in an earlier version. Some how decided against it.
          I will keep this in mind when I make future changes.

          Thank you so very much for trying it out and letting me know your views.

          Reply
  2. Kamat

    Thank you so much. I was searching the Internet for the last few days without any luck for exactly this fund correlation calculator, so you post is very timely. I will test this for my portfolio.

    I started following your posts few months back and am loving it.

    Reply
      1. Kamat

        Pattu. It works like a charm and provides exactly what investors need.

        Your excel is unique in that it gives investors ability to compare overlap between a new fund they are considering and their existing portfolio, a feature, which many of even the paid utilities don't provide.

        Thanks to you, I have a much balanced portfolio now.

        If I could offer a small suggestion, it would be ability to compare less than or more than 3 funds depending on situation. Currently it seems it needs exactly 3 funds to compare.

        Reply
        1. pattu

          Thank you very much for trying it out. More than 3 funds would make it cumbersome for me to do the comparison.

          2 funds require 1 comparison
          3 funds 3 comp.
          4 funds req. 6 comparisons! and so on...

          So i cannot scale it like that. Yes the ability to turn off the 3rd fund will be useful. Easy enough to put this in. I had this in an earlier version. Some how decided against it.
          I will keep this in mind when I make future changes.

          Thank you so very much for trying it out and letting me know your views.

          Reply
  3. Mohana Ganesh

    The following comment comes when I try to compare : Cannot compare the Macro Mutual FUnd Portfolio Comparison Tool.xlsm VR online. The macro n=may not be available n this workbook or all macros may be disabled.

    Reply
    1. pattu

      Please enable macros to get the sheet working. When you open the excel sheet, look for a warning/security bar just below the menu. The bar will appear if there are macros in the sheet and if macros are disabled.

      Reply
  4. Mohana Ganesh

    The following comment comes when I try to compare : Cannot compare the Macro Mutual FUnd Portfolio Comparison Tool.xlsm VR online. The macro n=may not be available n this workbook or all macros may be disabled.

    Reply
    1. pattu

      Please enable macros to get the sheet working. When you open the excel sheet, look for a warning/security bar just below the menu. The bar will appear if there are macros in the sheet and if macros are disabled.

      Reply
  5. Srikanth Meenakshi

    Pattabi, Thanks - useful tool! I have also found the Portfolio X-Ray from Morningstar useful in this regard - you can find out what percentage a stock is inside a fund and overall in your portfolio for the top holdings in your portfolio.

    <pitch>

    Of course, with a FundsIndia account, an MF investor can get Portfolio X-Ray for their portfolios with just a single click.
    🙂

    </pitch>

    Reply
  6. Srikanth Meenakshi

    Pattabi, Thanks - useful tool! I have also found the Portfolio X-Ray from Morningstar useful in this regard - you can find out what percentage a stock is inside a fund and overall in your portfolio for the top holdings in your portfolio.

    <pitch>

    Of course, with a FundsIndia account, an MF investor can get Portfolio X-Ray for their portfolios with just a single click.
    🙂

    </pitch>

    Reply
  7. Pattabiraman Murari

    Thanks. Yes I am aware of both tools. I just wanted a comparison tool with no requirement of getting an account. That said I sure the online tools are way more useful. I don't have the juice to match your tool or MorningStar's.

    Reply
  8. Pattabiraman Murari

    Thanks. Yes I am aware of both tools. I just wanted a comparison tool with no requirement of getting an account. That said I sure the online tools are way more useful. I don't have the juice to match your tool or MorningStar's.

    Reply
  9. Gnaneswara rao

    Thank you very much sir.It is really awesome tool.I have HDFC Equity,HDFC Top 200 and DSPBR Top 100 in my portfolio.I have checked the tool for above funds.I was shocked to see 84% over lap for HDFC Equity and HDFC Top 200,44% Over lap for HDFC Equity and DSPBR Top 100 Equity Reg and 56% Overlap for HDFC Top 200 and DSPBR Top 100 Equity Reg.Really i have to Review my PORTFOLIO.As said by Srikanth Meenakshi sir,this facility is available in Funds India account in X-ray Portfolio.
    Thank you sir...

    Reply
    1. pattu

      Thank you. If you have more than 1 long term financial goal, then assign Top 200 to one and HDFC Equity to another. As regards DSP BR Top 100, don't worry about the 40-50% overlap now. Just take this account when you make future purchases.

      As regards availability in other portals, my aim to create a tool which no financial obligation and necessity to create an account. I make no claim that the tool is unique or better than others. How readers use my tools is entirely up to them.

      What I would appreciate the most is, specific suggestions how to my Excel sheets better. This way all readers can benefit.

      Reply
  10. Gnaneswara rao

    Thank you very much sir.It is really awesome tool.I have HDFC Equity,HDFC Top 200 and DSPBR Top 100 in my portfolio.I have checked the tool for above funds.I was shocked to see 84% over lap for HDFC Equity and HDFC Top 200,44% Over lap for HDFC Equity and DSPBR Top 100 Equity Reg and 56% Overlap for HDFC Top 200 and DSPBR Top 100 Equity Reg.Really i have to Review my PORTFOLIO.As said by Srikanth Meenakshi sir,this facility is available in Funds India account in X-ray Portfolio.
    Thank you sir...

    Reply
    1. pattu

      Thank you. If you have more than 1 long term financial goal, then assign Top 200 to one and HDFC Equity to another. As regards DSP BR Top 100, don't worry about the 40-50% overlap now. Just take this account when you make future purchases.

      As regards availability in other portals, my aim to create a tool which no financial obligation and necessity to create an account. I make no claim that the tool is unique or better than others. How readers use my tools is entirely up to them.

      What I would appreciate the most is, specific suggestions how to my Excel sheets better. This way all readers can benefit.

      Reply
  11. Pushkar

    Hi,

    Very nice post and excel indeed.
    I was trying to use similar feature on morning star, but your seems way to simple to understand and use.

    Reply
  12. Pushkar

    Hi,

    Very nice post and excel indeed.
    I was trying to use similar feature on morning star, but your seems way to simple to understand and use.

    Reply
  13. Jatin Visaria

    Superb amazing fantastic tool 🙂

    One query...

    What is the criteria to categorize market cap ? I.e. threshold limits of giant cap, large cap, mid cap, small cap and tiny cap...

    Txs.

    Reply
  14. Jatin Visaria

    Superb amazing fantastic tool 🙂

    One query...

    What is the criteria to categorize market cap ? I.e. threshold limits of giant cap, large cap, mid cap, small cap and tiny cap...

    Txs.

    Reply
  15. bharat shah

    thank you for the new calculator. i found it is at least better than morningstar.in's.as this gives the overlapping % between the funds by number, whereas the former is just stating the overlapping shares names only. of course , one limitation is there : as VRO is not giving 100% portfolio for any/every fund , the result is approximate. i tried for 3 large cap funds (as per morningstar) and other set of 3 mid small cap funds. earlier i tried myself with VRO/ FUND site data, but it was cumbersome, and finally i left . now you designed the tool! Thank you.

    Reply
  16. bharat shah

    thank you for the new calculator. i found it is at least better than morningstar.in's.as this gives the overlapping % between the funds by number, whereas the former is just stating the overlapping shares names only. of course , one limitation is there : as VRO is not giving 100% portfolio for any/every fund , the result is approximate. i tried for 3 large cap funds (as per morningstar) and other set of 3 mid small cap funds. earlier i tried myself with VRO/ FUND site data, but it was cumbersome, and finally i left . now you designed the tool! Thank you.

    Reply
  17. Jatin Visaria

    Thank you for sharing the link.

    Problem is there is no standard threshold limit. Every one puts their own limits to categorize m-cap.

    If you read offer document, SID and SAI different AMCs have different definitions.

    In fact if you look closely, same AMC has different definition for their own different schemes.

    Due to this it is difficult to make apple to apple comparison of different funds.

    Reply
  18. Jatin Visaria

    Thank you for sharing the link.

    Problem is there is no standard threshold limit. Every one puts their own limits to categorize m-cap.

    If you read offer document, SID and SAI different AMCs have different definitions.

    In fact if you look closely, same AMC has different definition for their own different schemes.

    Due to this it is difficult to make apple to apple comparison of different funds.

    Reply
  19. Jay Cobb

    Hi Pattu, have a basic question - how is overlap calculated? Is it only the specific stock held by 2 funds or the amount invested by each fund in the same stock? Perhaps the same stock held will have some overlap but the amount invested by each fund also plays a part and the duration of it being held. Thanks.

    Reply
    1. pattu

      Hi Jay, I have only considered the name of the stock while calculating overlap. As regards duration, investors should check the overlap from time to time to check for changes.

      As regards the % invested, the advance results sheets gives the percentages. So if these numbers are not equal and large there is no need to worry. In any case, no one should take knee jerk reactions based on any tool. Even if there is 40% overlap, if the funds are good, I won't loose much sleep over it.

      Reply
  20. Jay Cobb

    Hi Pattu, have a basic question - how is overlap calculated? Is it only the specific stock held by 2 funds or the amount invested by each fund in the same stock? Perhaps the same stock held will have some overlap but the amount invested by each fund also plays a part and the duration of it being held. Thanks.

    Reply
    1. pattu

      Hi Jay, I have only considered the name of the stock while calculating overlap. As regards duration, investors should check the overlap from time to time to check for changes.

      As regards the % invested, the advance results sheets gives the percentages. So if these numbers are not equal and large there is no need to worry. In any case, no one should take knee jerk reactions based on any tool. Even if there is 40% overlap, if the funds are good, I won't loose much sleep over it.

      Reply
  21. Jatin Visaria

    Small suggestion...

    If you can compare overlap weight wise...will give more insight.

    E.g. it may happen that there are less number of stock overlapping in two schemes but out of common stocks there ismore weight given in portfolio...

    I.e. if you compare HDFC Top 200 with say Nifty Index...in that case weight wise there is more than 75% overlap. Now if you look at the expense ratio..genrally index funds or index ETF charge around 1% where as actively managed funds charge around 2.5%. It means to manage only 25% of your protfoli you are paying 150% more charges...

    I dont know if if its worth paying that much..

    Reply
  22. Jatin Visaria

    Small suggestion...

    If you can compare overlap weight wise...will give more insight.

    E.g. it may happen that there are less number of stock overlapping in two schemes but out of common stocks there ismore weight given in portfolio...

    I.e. if you compare HDFC Top 200 with say Nifty Index...in that case weight wise there is more than 75% overlap. Now if you look at the expense ratio..genrally index funds or index ETF charge around 1% where as actively managed funds charge around 2.5%. It means to manage only 25% of your protfoli you are paying 150% more charges...

    I dont know if if its worth paying that much..

    Reply
  23. Viren Phansalkar

    Good one, Pattu.... liked it....Mine correlation was 0%, 16% and 32%.... so i guess i need not do much and continue my SIPs 🙂

    Reply
    1. Aparna

      Hi Viren, just curious to know which are those 3 funds. Don't worry, I have mine in place and won't copy you. Just curious.

      Reply
  24. Viren Phansalkar

    Good one, Pattu.... liked it....Mine correlation was 0%, 16% and 32%.... so i guess i need not do much and continue my SIPs 🙂

    Reply
    1. Aparna

      Hi Viren, just curious to know which are those 3 funds. Don't worry, I have mine in place and won't copy you. Just curious.

      Reply
  25. Arun

    Thanks for this tool. Would it be possible to post a plain xl version of this calculator, if xl supports auto-data fetching. Openoffice doesn't seem to like xlsm.

    Reply
  26. Arun

    Thanks for this tool. Would it be possible to post a plain xl version of this calculator, if xl supports auto-data fetching. Openoffice doesn't seem to like xlsm.

    Reply
  27. Arun

    nstead of doing pair-wise comparisons, perhaps it might be useful to have a union of all the portfolios to find the number of unique stocks and their percentages ? While this may not give you insights into which two funds are “orthogonal”, it can give an overall portfolio diversification check. Thanks.

    Reply
    1. pattu

      Hi Arun, If you are referring to comparing all the 3 folios to find common stocks and percentages, this information is available in the advanced analysis section. If you want to check diversification, you will need the pair-wise information too.

      Reply
  28. Arun

    nstead of doing pair-wise comparisons, perhaps it might be useful to have a union of all the portfolios to find the number of unique stocks and their percentages ? While this may not give you insights into which two funds are “orthogonal”, it can give an overall portfolio diversification check. Thanks.

    Reply
    1. pattu

      Hi Arun, If you are referring to comparing all the 3 folios to find common stocks and percentages, this information is available in the advanced analysis section. If you want to check diversification, you will need the pair-wise information too.

      Reply
  29. Arun

    Oh ok, thanks for the clarification. That's a fantastic feature. I could not see that in openoffice. Will try and open this in 2007 soon.

    Thanks very much for this calculator and everything else. Have always enjoyed the mathematical rigor you bring to personal finance.

    Best regards, Arun

    Reply
  30. Arun

    Oh ok, thanks for the clarification. That's a fantastic feature. I could not see that in openoffice. Will try and open this in 2007 soon.

    Thanks very much for this calculator and everything else. Have always enjoyed the mathematical rigor you bring to personal finance.

    Best regards, Arun

    Reply
  31. Arun

    Hi again, I checked it out in 2007. Works beautifully!
    Here are some feature requests:

    0) Have a percentage allocation for each fund in the main tab. E.g., fund 1 takes 33%, fund 2 takes 40%, etc.

    1) What we have in the Results-Advanced sheet as stocks common to all three funds is the intersection of the underlying sets of stocks for the 3 funds. What I would request you to do is the union of the underlying sets of stocks for the 3 funds weighted by the percentage allocation to each fund as captured in the Main sheet. So now the user can see that the overall portfolio has 50 unique stocks and their percentages are 5%, 4%, ....

    2) In the sheet Results-simple, would it be possible to add up all large-caps percentages across funds into one portfolio level large-cap allocation.

    Thanks again !

    Reply
    1. pattu

      Thanks Arun. 0) and 1) are possible. Will have to see how to do 2). Have a long list of calculators to complete. Will get to this soon.

      Reply
  32. Arun

    Hi again, I checked it out in 2007. Works beautifully!
    Here are some feature requests:

    0) Have a percentage allocation for each fund in the main tab. E.g., fund 1 takes 33%, fund 2 takes 40%, etc.

    1) What we have in the Results-Advanced sheet as stocks common to all three funds is the intersection of the underlying sets of stocks for the 3 funds. What I would request you to do is the union of the underlying sets of stocks for the 3 funds weighted by the percentage allocation to each fund as captured in the Main sheet. So now the user can see that the overall portfolio has 50 unique stocks and their percentages are 5%, 4%, ....

    2) In the sheet Results-simple, would it be possible to add up all large-caps percentages across funds into one portfolio level large-cap allocation.

    Thanks again !

    Reply
    1. pattu

      Thanks Arun. 0) and 1) are possible. Will have to see how to do 2). Have a long list of calculators to complete. Will get to this soon.

      Reply
  33. Vidyasagar

    Hi Sir,

    Appreciate your efforts to develop the excel tool. Very useful. I have started using this tool to restructure sip funds. Thanks.

    Reply
    1. pattu

      Thank you very much for writing back. Good to know about this. Will do a post describing all the mf tools at freefincal.
      I would appreciate if you could share the links to these tools with your friends.

      Reply
  34. Vidyasagar

    Hi Sir,

    Appreciate your efforts to develop the excel tool. Very useful. I have started using this tool to restructure sip funds. Thanks.

    Reply
    1. pattu

      Thank you very much for writing back. Good to know about this. Will do a post describing all the mf tools at freefincal.
      I would appreciate if you could share the links to these tools with your friends.

      Reply
  35. VINAY MAITHANI

    WoW what a tool. Better than VRO & Morning star free versions. Comparison surprised me with facts that 30,40,38% overlap shown in large cap. By changing a fund the overlap vanished among two funds but 'bluechip' named funds had 48% overlap. Is there a method to find list of non overlapping funds in large cap category apart from trial & error method of comparing one by one ? Does any website helps with this ?
    This tool surely does help to compare 3 funds.

    Reply
    1. pattu

      Thanks Vinay,

      I am not aware of such a tool. Choosing funds from different categories will minimize the overlap.

      Reply
  36. VINAY MAITHANI

    WoW what a tool. Better than VRO & Morning star free versions. Comparison surprised me with facts that 30,40,38% overlap shown in large cap. By changing a fund the overlap vanished among two funds but 'bluechip' named funds had 48% overlap. Is there a method to find list of non overlapping funds in large cap category apart from trial & error method of comparing one by one ? Does any website helps with this ?
    This tool surely does help to compare 3 funds.

    Reply
    1. pattu

      Thanks Vinay,

      I am not aware of such a tool. Choosing funds from different categories will minimize the overlap.

      Reply
  37. Satya S Mishra

    Dear Pattu
    Thanks for the wonderful calculator just wanted to bring one small point to notice, in this report expense is as of September, Corpus is as of December but the portfolio seems to be updated till January as per VR online website but Excel gives an impression that the portfolio is also old and is only till December thus reducing the effect of your hard work, if we can modify the same it will become more effective.

    One more humble request if we can also add rolling return Snapshot for each Fund comparing it with its benchmark index here only ( the correct index being referred from VR online with its data imported from yahoo or BSE /NSE) rather than doing separately as being done in your automated Rolling return calculator, which is wonderful but does not compare apple to apple)
    I hope it will make your excel report complete.
    Thanks a lot for for working for the social cause.............your work will impact millions of lives in long term and generations will remember you........because many will have a future because of you only.
    Keep up the good work .........May God Bless You.

    Reply
    1. pattu

      Thank you for your kind words of appreciation and support. I have removed the wrong date output and have uploaded the new file.
      Yes a rolling returns chart will certainly make the report complete. However, it tough to it in one file if not in one sheet. Let me think about this.

      Reply
  38. Satya S Mishra

    Dear Pattu
    Thanks for the wonderful calculator just wanted to bring one small point to notice, in this report expense is as of September, Corpus is as of December but the portfolio seems to be updated till January as per VR online website but Excel gives an impression that the portfolio is also old and is only till December thus reducing the effect of your hard work, if we can modify the same it will become more effective.

    One more humble request if we can also add rolling return Snapshot for each Fund comparing it with its benchmark index here only ( the correct index being referred from VR online with its data imported from yahoo or BSE /NSE) rather than doing separately as being done in your automated Rolling return calculator, which is wonderful but does not compare apple to apple)
    I hope it will make your excel report complete.
    Thanks a lot for for working for the social cause.............your work will impact millions of lives in long term and generations will remember you........because many will have a future because of you only.
    Keep up the good work .........May God Bless You.

    Reply
    1. pattu

      Thank you for your kind words of appreciation and support. I have removed the wrong date output and have uploaded the new file.
      Yes a rolling returns chart will certainly make the report complete. However, it tough to it in one file if not in one sheet. Let me think about this.

      Reply
  39. Satya S Mishra

    Hello again rather than using VR online data can we not use Morningstar data.............just a suggestion.

    Reply
  40. Satya S Mishra

    Hello again rather than using VR online data can we not use Morningstar data.............just a suggestion.

    Reply
  41. Mohan

    Wonderful tool, Pattu. It gave me valuable insight to my porfolio that my existing SIPs in (HDFC Top 200, BSL FrontLine Eq and DBPBR Top 100) have considerably high overlap of (60%, 44% and 48%).

    This pretty much convinces me that it makes sense to combines the SIPs into 1 fund (most likely HDFC top 200) for large/giantcap and having PPFL Eq and ICICI Pru Discovery completes the portfolio.

    I guess 3 funds are most optimal.

    Regards,

    Mohan

    Reply
    1. pattu

      Thank you. Diversification is key. A low number is always good but how much is low enough depends on the person.

      Reply
  42. Mohan

    Wonderful tool, Pattu. It gave me valuable insight to my porfolio that my existing SIPs in (HDFC Top 200, BSL FrontLine Eq and DBPBR Top 100) have considerably high overlap of (60%, 44% and 48%).

    This pretty much convinces me that it makes sense to combines the SIPs into 1 fund (most likely HDFC top 200) for large/giantcap and having PPFL Eq and ICICI Pru Discovery completes the portfolio.

    I guess 3 funds are most optimal.

    Regards,

    Mohan

    Reply
    1. pattu

      Thank you. Diversification is key. A low number is always good but how much is low enough depends on the person.

      Reply
  43. Muthu Krishnan V

    Nice calculator: suggestion: one more tab could be added which will show the percentage of each stock in a combined portfolio. (say somebody invest 1000Rs in hdfc top 200 and 2000Rs. in qltef, what is the combined holdings and percentages).

    Reply
  44. Muthu Krishnan V

    Nice calculator: suggestion: one more tab could be added which will show the percentage of each stock in a combined portfolio. (say somebody invest 1000Rs in hdfc top 200 and 2000Rs. in qltef, what is the combined holdings and percentages).

    Reply
  45. Andy

    Dear Pattu,

    Thanks a lot for the Portfolio Comparison tool. I used it and found 2 set of Mid/Small cap funds with less overlap.

    FIRST:
    i. ICICI Prudential Value Discovery Fund - Direct Plan
    ii. Canara Robeco Emerging Equities Fund - Direct Plan
    iii. DSP BlackRock Micro Cap Fund - Direct Plan

    This has a overlap of 4%:4%:8%

    SECOND:

    i. ICICI Prudential Value Discovery Fund - Direct Plan
    ii. UTI Mid Cap Fund - Direct Plan
    ii. Reliance Small Cap Fund - Direct Plan

    This has a overlap of 8%:4%:12%

    I got the above fund names from moneycontrol with good rankings. I would like to know if they are good funds or not. Also, please suggest which set of funds (FIRST or SECOND) i can choose if you find them good.

    Reply
    1. pattu

      I don't track theses funds and cannot offer an opinion on them. Use my risk and return analyzer to check for performance.

      Reply
  46. Andy

    Dear Pattu,

    Thanks a lot for the Portfolio Comparison tool. I used it and found 2 set of Mid/Small cap funds with less overlap.

    FIRST:
    i. ICICI Prudential Value Discovery Fund - Direct Plan
    ii. Canara Robeco Emerging Equities Fund - Direct Plan
    iii. DSP BlackRock Micro Cap Fund - Direct Plan

    This has a overlap of 4%:4%:8%

    SECOND:

    i. ICICI Prudential Value Discovery Fund - Direct Plan
    ii. UTI Mid Cap Fund - Direct Plan
    ii. Reliance Small Cap Fund - Direct Plan

    This has a overlap of 8%:4%:12%

    I got the above fund names from moneycontrol with good rankings. I would like to know if they are good funds or not. Also, please suggest which set of funds (FIRST or SECOND) i can choose if you find them good.

    Reply
    1. pattu

      I don't track theses funds and cannot offer an opinion on them. Use my risk and return analyzer to check for performance.

      Reply
  47. Rajiv

    hi
    i like the blog but i was not able to find the tool with the link mentioned.
    Can you please tell me exactly which link will work to get the MF Comparison tool.?

    Thanks

    Reply
  48. Rajiv

    hi
    i like the blog but i was not able to find the tool with the link mentioned.
    Can you please tell me exactly which link will work to get the MF Comparison tool.?

    Thanks

    Reply
  49. Rajiv

    Also,

    I want to have this "risk and return analyzer" to check for performance.
    Sorry, i was not able to figure out this in this page.

    Thanks

    Reply
  50. Rajiv

    Also,

    I want to have this "risk and return analyzer" to check for performance.
    Sorry, i was not able to figure out this in this page.

    Thanks

    Reply
  51. Vinay

    Pattu ji....I was trying to compare Birla Sun Life Global Commodities Fund, Mirae Asset Global Commodity Stocks Fund and DSP BlackRock World Energy Fund - Regular Plan for considering commodities as an asset class.As you know they are in reds world over. In India the only commodity to be able to invest is Gold. Please correct me if I am wrong.
    I could not find the Birla fund so could not continue ahead however i found the other two. Which commodity MF you suggest which as they say are well diversified geographically as well as commodity wise such as energy/agriculture/mining etc. How to approach this apart from keeping it simple and neglecting it.

    Reply

Do let us know what you think about the article