How to track mutual funds and stocks together
To see stocks and mutual funds as one portfolio, record the same few facts for every holding (what you own, how much, what you paid and when), value everything on the same date, and compare returns using one measure such as XIRR. You can do this in a spreadsheet or with a portfolio tracker. The method matters more than the tool.
Why this is harder than it should be
Most investors in India end up with their holdings spread across places. Stocks sit in a demat account with a broker. Mutual funds may sit with the fund houses, on a fund platform, or inside the same broker's app. Each one shows its own numbers in its own format, and none of them shows you the whole picture.
The result is that simple questions are hard to answer. How much do I own in total? How much of it is in equity? Am I too heavily invested in one sector? Which of my holdings is actually pulling its weight?
Step 1: List every holding in one place
Start with a single list. For each holding, record:
| Stocks | Mutual funds | |
|---|---|---|
| What you own | Company name and ticker | Fund name and plan (Direct or Regular, Growth or IDCW) |
| How much | Number of shares | Number of units |
| What you paid | Average buy price | Average NAV, or total amount invested |
| When | Buy date | Date of each purchase or SIP instalment |
Do not skip the dates. Without them you cannot measure returns properly later, and they are the first thing people forget to write down.
Step 2: Value everything on the same day
Stock prices change every second during market hours, while mutual fund NAVs are published once a day. If you pull your stock values at 2 pm and your fund values from yesterday's NAV, the total is a mix of two different moments. For a quick check this is fine. For comparing holdings against each other, use the same cut-off, such as the previous market close.
Step 3: Compare returns on one measure
Stocks are often bought in a single go, while mutual funds are often bought through SIPs spread over months or years. Comparing a stock's simple gain with a SIP fund's simple gain is not a fair match, because the SIP money was invested for much shorter on average.
Use XIRR for both. It measures an annualised return that accounts for the date of every purchase. We explain how it works, with examples, in What is XIRR?
Step 4: Look at the whole portfolio, not just each holding
Once everything is in one place, three views are worth checking regularly:
- Asset split. How much is in direct stocks and how much is in mutual funds? Does the split match what you intended?
- Sector spread. If one sector, such as banking or IT, makes up a large share of your stocks, a single bad year for that sector affects you more than you may realise.
- Biggest positions. A few large holdings usually drive most of your result, up or down. Knowing which ones they are helps you decide where to pay attention.
Mistakes to watch for
- Hidden overlap. Many equity mutual funds already hold the large companies you may also own directly. If you hold a popular large-cap stock and also several large-cap funds, your real exposure to that company is higher than it looks. Checking a fund's top holdings on the fund house's factsheet will show you.
- Ignoring corporate actions. Stock splits, bonus issues and demergers change your share count and buy price. If you do not update them, your numbers drift away from reality.
- Mixing up plans. The Direct and Regular plans of the same fund have different NAVs and different costs. Record the right one.
- Treating dividends as invisible. If you hold IDCW (dividend) options, the payouts are part of your return. Leaving them out understates it.
- Checking too often. Daily swings are noise. Reviewing monthly or quarterly is usually enough to see what is happening.
Spreadsheet or tracker?
A spreadsheet gives you full control and costs nothing, but you have to type in every holding, refresh prices, and build your own return and allocation formulas. It also needs regular upkeep. A portfolio tracker takes the holdings you enter once and handles the valuation, returns and allocation for you. Either approach works. Pick the one you will actually keep up to date, because a tracker you stop updating is no better than no tracker.
Track stocks and mutual funds together in WealthLenz
Add your holdings once and see live valuations, gains and losses, XIRR and sector allocation for your stocks and mutual funds in one dashboard. Free for up to 10 stocks and 3 mutual funds.
Get started freeThis article is for general education only and is not investment advice. See our Disclaimer.
