Methodology
Every number on this site is a deterministic, reconciled transform of AMFI’s Monthly Composite Report. No inference, no smoothing unless defined.
Data & reconciliation guarantee
Why you can trust the numbers.
Source: AMFI Monthly Composite Report (MCR) and quarterly AAUM disclosures. Coverage: 86 monthly periods (Apr-2019–May-2026), 28 quarters, 12 legacy months.
- Hard reconciliation gate. For every ingested month, the sum of the leaf + group-leaf categories must equal that file’s Grand Total for schemes, folios (exact) and net AUM (±₹1 cr). A month that fails is rejected — never partially loaded.
- Period is stamped from the filename (there is no in-cell date). Units are INR crore end-to-end; ticket size converts to ₹ lakh at display only.
- Fund-of-Funds (Domestic) is held as a memo and never summed into any total (it would double-count).
- Lag-based metrics emit NULL (never 0) for the earliest period; the cumulative decomposition reconciles exactly to month-end AUM.
Metric dictionary
Exact definitions for every computed field.
| Metric | Formula | What it measures |
|---|---|---|
| Net flow | gross sales − redemptions | Core money-movement; direct from AMFI. |
| Redemption ratio | redemption[t] / net AUM[t-1] | Selling pressure relative to prior asset base. |
| Subscription ratio | gross sales[t] / net AUM[t-1] | Buying intensity relative to prior base. |
| Organic growth % | net flow[t] / net AUM[t-1] | Flow-driven growth, ex-market. |
| AUM change | net AUM[t] − net AUM[t-1] | Total capital movement (control total). |
| Implied market move | AUM change − net flow | Valuation/MTM residual (pure arithmetic, not inference). |
| Implied return % | implied market[t] / net AUM[t-1] | A true return only for Equity/Hybrid/Passive; an MTM artifact for Debt. |
| Rolling 3M net flow | Σ net flow over t-2…t | Trailing 3-month flow. |
| Flow momentum | net flow[t] − mean(net flow[t-3…t-1]) | Acceleration vs recent trend. |
| Share of net inflow | net flow[i] / Σ net flow | A category’s share of the month’s total (can be negative). |
| Net new folios | folios[t] − folios[t-1] | Investor accounts added/lost. |
| Folio growth % | net new folios / folios[t-1] | Participation velocity. |
| Ticket size (₹ lakh) | net AUM / folios | Average capital per folio (retail vs HNI proxy). |
| Passive share | Σ passive net AUM / Σ net AUM | Index/ETF/FoF-overseas share of assets. |
| Churn (turnover) | (gross in + gross out) / avg AUM | Activity vs size — stickiness inverse (Liquid high, Equity low). |
| Flow streak | consecutive same-sign net-flow months | Durability of a trend (+ = inflows, − = outflows). |
| Cumulative flow vs market | running Σ net flow & Σ implied market | Decomposes AUM growth since inception into money-in vs market-made. |
| Trailing-12M net flow | Σ net flow over the last 12 months | Smoothed annual flow (≥12 months). |
| Annualized organic growth | trailing-12M net flow / net AUM[t-12] | Flow-driven growth over a year. |
| Flow breadth (HHI) | Σ (|net flow_i| / Σ|net flow|)² | Concentration of the month’s flow; effective_n = 1/HHI. |
| Debt risk appetite | (duration/credit − cash-like net flow) / Σ|·| | Reaching-for-yield vs parking, within Open-Ended debt. |
| NFO metrics | count, raised, share, avg ticket | New launches from the NSR sheet, per month & class. |
| Side-pocket signal | segregated count & AUM, Δcount>0 | Credit-event stress (segregated portfolios). |
What this data cannot tell you
The honest ceiling.
The MCR feed is category-level only. It has no AMC-level, scheme-level, SIP, or NAV/returns data. So market-share-by-AMC, a SIP dashboard, and true returns are out of scope without additional AMFI feeds — the “implied return” here is a mark-to-market residual, not a yield. The quarterly files are also category-level; only the NFO scheme names carry any AMC-identifying detail.