As readers may know, five mutual fund portfolios can be compared with the Google Sheets-based freefincal mutual fund portfolio overlap tool.
Mr Sundararajan Srinivasan has updated the tool by replacing the existing (incomplete) Stock Sector listing with the standard SEBI classification.
Features
- It allows you to compare the portfolio of five mutual funds. These can be a mix of equity, hybrid, and debt mutual funds (excluding overnight funds).
- Suppose mf1, mf2,mf3,mf4 and mf5 are the funds chosen; we find the no of common stocks and percentage overlap in equity between mf1 and mf2; mf1 and mf3; …. mf2 vs m4 … mf4 vs mf5 (all ten combinations).
- We can compare the sectoral distributions. For example, mf1 has 10% of pains while mf2 has 5% of banks, and mf4 has 25% of foreign equity.
- We can compare the credit rating distribution in the case of hybrid funds and debt funds. For, e.g. mf1 has 15% of SOV bonds, mf2 has 5% of treasury bills, mf3 has 7% of AA bonds rated by CRISIL while mf4 has 9% of AA bonds rated by CARE, etc.
- The portfolios are downloaded from Moneycontrol. The sheet is blazing fast on Google Sheets.
- What is the price of the sheet? The sheet is free but available only to those who purchase the freefincal mutual fund (and stock) portfolio tracker on Google Sheets.
- Please add pattu@freefincal.com to your contacts list to receive free updates and bug fixes.
- Existing users: Please use the same original link and make a copy to use the updated sheet. Email us if you need assistance.
Walkthrough video
Screenshots of Freefincal Mutual Fund Portfolio Overlap Tool (Google Sheets edition)
The tool is simple to use. All you need to do is choose fund names, and the results will be updated within a few seconds.
If any fund is missing (say an NFO released after the publication of this tool), you can easily add its information following the instructions on the notes page.
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
This is the summary of results.
One fund vs another (10 combinations) screenshot.
Equity sector allocation for equity funds and hybrid funds. Mr Srinivasan’s updated list is featured here.
Bond credit rating allocation page.
How do you get the Freefincal Mutual Fund Portfolio Overlap Tool (Google Sheets edition) for free?!
- Head over to our Google Sheets portfolio tracker main page. See its features (there are video guides, too): Track your mutual fund and stock investments with this Google Sheet!
- Purchase one of our mutual fund trackers. For instance: MF & Stock Portfolio Tracker + Portfolio Visualization Module
- You will also get the link for the Freefincal Mutual Fund Portfolio Overlap Tool (Google Sheets edition) and the purchase.
- Please add pattu@freefincal.com to your contacts list to receive free updates and bug fixes. You can also use this email to send feedback on these tools.