Portfolio review · NAV data to

Which funds earn their volatility?

Return vs volatility, 3 years

Axes
Plan

What the flags say

Groups are set from the direct plan, which shows the fund manager's skill. The regular plan returns about 0.7–1.4% a year less, and in several funds that cost turns a winner into a laggard. The table shows both.

Consolidation plan

This pulls the flags, the overlap check, the fund screen and the tax room together. Switching a regular plan to direct is a sale anyway, so the money can go to the best fund in the screen rather than the same fund's direct plan. It is a rules-based screen to weigh, not advice.

Funds to hold

What to sell and when, fund by fund, plus your monthly SIPs, are in Full plan: every holding at the end.

Where to invest next

Every open-ended direct-growth fund in these categories from AMFI's list, put through the same tests as your funds. Each gets a score out of 100 against the other funds in its category: 75% for the last 3 years, 25% for its record against the category median since June 2018.

3Y score = 35% return vs benchmark + 25% share of rolling 3-year windows ahead of it + 20% downside capture + 10% worst fall vs benchmark + 10% result across the four market falls since 2019. Long-run score (funds with 5+ years) compares the fund with the median fund in its category every week since June 2018, when SEBI's current categories began: 35% yearly lead over the median + 25% share of rolling 3Y windows ahead + 15% rolling 5Y windows ahead + 15% downside capture + 10% worst fall. Overall = 75% 3Y score + 25% long-run score, or the 3Y score alone when there is no long record. The median is of funds alive today, so it slightly flatters the category. "Short record": under 2 years of rolling windows. Large caps use the Nifty 50 as benchmark, multi caps a 50/25/25 blend. Fund managers change; a long record under a past manager says less about the future.

Replacement candidates

For each fund the plan sells or switches: the best funds in the same category that beat their benchmark and take no more than 100% of falls, ranked by overall score. Long-record funds first; the best newer fund is shown last.

Tax calendar

Regular-to-direct switches spread over four financial years so equity gains stay within the ₹1.25L yearly exemption. Each full year of room saves up to ₹16,250 of tax (12.5% + 4% cess).

Figures use today's gains, which will grow, so later years will hold slightly fewer units; recheck the gain on the day. Every lot is checked against its purchase date: it is sold or switched only once it is long-term and past any ELSS lock-in, on that date if it falls inside the year. Losses from funds held under the long-term period are short-term and can offset any gain. Your other stock sales share the same ₹1.25L. India has no wash-sale rule, so a loss can be booked and the fund bought back.

Peer check

The top-scored funds in the whole-market screen for each of your categories, put through the same 3-year test against the same benchmark (direct plans). Your funds are marked.

Beats % comes from fewer windows for funds with a short record, so read those with care.

Falls and recoveries

Every 10%+ fall in the Nifty 500 since 2019, the recovery back to the old high, and the rising stretches in between. The table compares each fund with its own benchmark in each phase.

Episode cells: fund return / benchmark return over that stretch. Phase columns: how much better (green) or worse (red) the fund ended up than its benchmark over all weeks of that phase put together. The latest recovery has not yet regained the Sep 2024 high. Hybrid and multi-asset funds use my blended benchmarks, so their figures are rough.

Where your money sits

All your scored funds combined, weighted by what you hold, compared with the Nifty 500. From each fund's latest sector and market-cap split (needs INDmoney data).

Company size

Sectors

Scorecard

Plan

3Y = the last 3 years of weekly returns to the data date. Excess = fund 3Y CAGR − benchmark 3Y CAGR. Vol ratio = fund volatility ÷ benchmark volatility. Up/Down = upside and downside capture. Beats % = share of rolling 3-year windows (since 2022) in which the fund beat its benchmark. Long run = excess CAGR over the longest period both fund and benchmark have data (5.6–10 yrs). Invested, value and profit are your own holding in that plan. Your profit depends on when you bought, so a fund can beat its benchmark and still show little profit if most of it was bought recently. Sector, international, debt and liquid funds are listed in the full plan, not here.

One fund in detail

Growth of ₹1 vs benchmark

Rolling 3-year return, ahead of benchmark by

How this was worked out

Data

  • Daily NAVs for each fund's direct and regular plan from mfapi.in (AMFI data), sampled every Friday.
  • Benchmarks use index fund and ETF NAVs (Nifty 100, Nifty 500, Midcap 150, Smallcap 250, Nifty 50, a corporate bond fund and gold for blends). These carry a small cost (0.1–0.3% a year), so benchmarks look slightly worse than the true index.
  • Index fund history starts in 2019; the long-run score compares each fund with its category median instead.

The regression

  • Weekly fund return = α + β × weekly benchmark return + error.
  • β: how much the fund moves for a 1% benchmark move. α: yearly return beyond that, the manager's edge. R²: how much of the fund's movement the benchmark explains. Tracking error: spread of the error term.
  • Capture: average fund return in benchmark-up weeks ÷ the benchmark's (upside), and the same for down weeks (downside).

Flag rules (direct plan, 3Y)

  • Exit candidate: behind the benchmark and bumpier (vol ratio > 1.05, downside capture > 1, or a drawdown 3+ points worse).
  • Lagging: more than 1% a year behind the benchmark and ahead in under 40% of rolling 3Y windows.
  • Volatile, but ahead: beating the benchmark, but vol ratio > 1.10, downside capture > 1.05, or a drawdown 3+ points worse.
  • Steady compounder: ahead, beats in ≥ 60% of windows, downside capture < 0.95, vol ratio ≤ 1.05.

Limits

  • Past returns don't predict future ones. 3 years is one market cycle at most.
  • Hybrid and multi-asset benchmarks are blends (65/35 and 65/20/15), so those funds are only roughly placed.
  • This is an educational, rules-based screen, not investment, tax or legal advice. The author is not a SEBI-registered adviser.

Full plan: every holding

Values and gains are from your holdings file and will move. Holding periods and lock-ins are checked lot by lot: a lot is sold only once it is long-term (more than 12 months for equity funds) and past any ELSS lock-in. Your other equity sales share the same ₹1.25L. Case = share of tests the replacement wins against the fund being sold (3Y return vs benchmark, 3Y consistency, share of falls taken, worst fall, long-run lead over the category median, long-run 3Y and 5Y windows ahead; ties ignored): Clear ≥ 80 with a break-even under 2 years, Lean 55–79, Close call below 55. Close calls are left out of the plan. Duplicate index funds and regular-to-direct switches of the same fund are always Clear. Held since = first purchase still held, from your statement (Jan 2023 onwards; "before 2023" means older units). XIRR = annual return on your actual purchase dates and amounts; CAGR = (value ÷ invested) from the first purchase, so it reads lower than XIRR for SIPs. "≤" marks funds with units bought before 2023: they are counted from 1 Jan 2023, so the true figure is somewhat lower. Holdings under a year show the plain return so far instead. "If it had all been in …" replays each purchase you still hold, on its date and for its amount, into the suggested fund's direct plan, and compares the result with what you hold today (NAVs of 20 Nov 2026). For same-fund switches it shows what the direct plan would have earned. Units bought before 2023 are compared from 1 Jan 2023 only. It looks backwards: a fund that would have earned less over this stretch can still be the better pick on the full record, and the reverse.