CA. Akhilesh Kumarcaakhilesh.in
Investing Intelligence · methodology

How every figure is computed — and what this product does not claim

Engine v1.0.0 · NAV dataset 2026-09-17 (69 scheme codes, history from 01-Jan-2015) · NAV through 17 Sept 2026

1. Data sources and the hierarchy

Every important data point is stored with its value, source, source URL, observation date, collection date, frequency, method, confidence and version. Sources are ranked; a lower tier never overrides a higher one for the same fact.

TierSourceUsed forStatus
1AMFI (Association of Mutual Funds in India)scheme identity (name, plan, option, ISIN); AMFI category heading; daily NAV; NAV historyingested
1SEBIscheme categorisation circular (2017) and riskometer levels (2021)terminology only; no scheme-level data ingested
1AMC monthly factsheets and scheme documentsexpense ratio; AUM; portfolio holdings; sector and market-cap exposure; fund manager and tenure; riskometer; benchmark name; exit loadnot yet ingested — every field they would fill shows Insufficient data
2NSE Indices (Nifty family)benchmark total-return index historynot yet ingested — the public endpoint refused automated download on 2026-09-18; benchmark-relative metrics show Insufficient data
1Reserve Bank of Indiainflation contextnot ingested; inflation is a user-set assumption with a labelled default
1MoSPI (CPI)CPI series for inflation contextnot ingested

Today only AMFI is ingested: scheme identity, the AMFI category heading, the daily NAV and the NAV history for 69 scheme codes across 34 funds (1,95,407 dated observations). Fields that depend on factsheets or index data are shown as Insufficient data. Nothing is estimated in their place.

2. Returns

3. Rolling returns and consistency

For each window length (1, 3, 5 years) every start date stepping one week from the first NAV is taken; the annualised return to the date one window later is recorded. The page shows the number of windows, the worst, the 25th percentile, the median, the 75th percentile, the best, and the share of windows that were negative. At least 12 windows are required; otherwise Insufficient.

4. Risk

5. Benchmark and the reference fund

The scheme's official benchmark and its total-return series are not on file (the index provider's public endpoint refused automated download when this was built), so no benchmark-relative figure is shown and the field says Insufficient data. For equity, index and hybrid schemes a reference fund — the Direct plan of a Nifty 50 index fund in the set — is compared on shared dates over three years: CAGR difference and the share of rolling one-year windows in which the fund was ahead. It is labelled a proxy for the broad market every time it appears and is never called the benchmark. When the official series is ingested it feeds the same function.

6. Direct vs Regular

Both plans of a scheme hold the same portfolio; the Regular plan's NAV grows more slowly by roughly the distributor commission. The gap is measured directly from the two NAV series as the three-year CAGR difference on shared dates. It is the observed gap, not the published expense-ratio difference, which is not on file.

7. Data freshness

Every dated observation is classed against a window for its kind — NAV: fresh ≤ 3 days, recent ≤ 10; portfolio: fresh ≤ 45, recent ≤ 75 — as FRESH, RECENT, STALE or INSUFFICIENT. Stale data is labelled as older than the preferred window; it is never shown as current.

8. Versioning

NAV snapshots are immutable: a re-run of the ingestion writes a new snapshot only when AMFI's latest date has moved on, and the previous file is kept under historical/. The engine has a version (1.0.0); the dataset has a version (2026-09-17); both are printed on every page.

9. Goal and retirement arithmetic

10. Riskometer and categories

Categories are AMFI's own headings, which follow SEBI's categorisation circular; the engine never reassigns a scheme. The riskometer uses SEBI's six levels — Low, Low to Moderate, Moderate, Moderately High, High, Very High — and is shown only when a scheme's own label has been ingested from its factsheet or SID. No level is assigned by this site.

11. What "best" means here

A question like "best midcap fund" is treated as a research question. The answer is "it depends on what you are optimising for", followed by a transparent shortlist: each fund in the category is listed with the dimensions on which it stands in the top third of the set — rolling 3-year median, share of positive 3-year windows, shallower drawdown, lower volatility, faster recovery, larger Direct-plan advantage — with the value beside each. Nothing is combined into a score, no fund is ranked first, and the dimensions with insufficient data are named.

12. What this product does not claim

Investment research and financial education: historical analysis and scenario arithmetic from published data, not investment advice and not a recommendation to buy, sell or hold any scheme. Past performance does not indicate future returns. Mutual fund investments are subject to market risk; read the scheme documents. Nothing you type is stored or sent anywhere.