---
title: "Method: ETF desk"
url: https://tipsheet.markets/methods/etf/
description: "How tipsheet.markets computes etf desk: sources, start dates, checks and caveats."
updated: 2026-10-29
publisher: tipsheet (https://tipsheet.markets/)
cite: "tipsheet, “Method: ETF desk”, 29 October 2026, https://tipsheet.markets/methods/etf/"
---

[Methods](https://tipsheet.markets/methods/)

# ETF desk: method

Code: `pipeline/tipsheet/compute/etf.py` (build) and `publish/etf.py` (bundles). Shared AMFI readers: `compute/amfi.py`. Tests: `pipeline/tests/test_etf.py`.

## What is measured

For every exchange-traded fund listed on NSE, day by day, as far back as both the exchange price and the AMFI NAV exist:

- **Premium or discount:** the exchange close divided by the same day’s NAV, minus one. Measured only on days the ETF traded. This is an end-of-day measure against AMFI’s NAV, not an intraday premium to iNAV, for which no source with history or bulk access was found (see below).
- **Premium at the day’s average price:** the day’s traded value divided by units traded (the volume-weighted average price), over the same NAV, minus one. The close is NSE’s 30-minute weighted average at the end of the day; the average price is closer to what a typical buyer paid.
- **Liquidity:** traded value in rupees crore, and its median over the last 20 and 60 sessions; the share of the last 60 sessions with a trade; and turnover, the last 60 sessions’ traded value annualised and divided by AUM. A session with no trade counts as zero: the bhavcopy prints no row for a security that did not trade, so each ETF is laid on the exchange’s session calendar from its first trade (to the last session if it traded in the last 30 days, else to its last trade).
- **Tracking difference:** the ETF’s annualised NAV total return minus its benchmark’s annualised total return, over 1 and 3 years, in percentage points. A negative number means the ETF lagged.
- **Costs and size:** the latest total expense ratio (TER) and the latest quarterly average AUM.

## Sources

| What | Dataset (dataset) | From |
| --- | --- | --- |
| Closes, traded value, ISIN | `nse_bhavcopy` and its eras, series EQ | 2002 for the oldest ETFs; ISINs printed from 2011-06-22 |
| NAV | `amfi_nav_history` and its eras, `amfi_nav_latest` | 2006-04-03 |
| Benchmarks | `nifty_index_total_returns` via `compute/indices.load_tri` (bad prints repaired) | index launch dates |
| Gold benchmark (rough) | domestic gold price in rupees from `asset_tri_daily.parquet` | 2005 |
| Distributions and splits | `stocks_events_corporate_actions` (ETF ISINs) | 2001 |
| TER | `amfi_ter_daily*` | 2018-04 |
| AUM | `amfi_aum_schemewise` (quarterly average, rupees lakh) | 2006 |
| AMFI’s own tracking difference | `amfi_tracking_difference` | 2022-05 |
| Order book (best bid and offer, five levels), intraday | `kite_etf_quotes` (Kite Connect, laptop, internal only) | 2026-10-09 |

## How ETFs are matched to AMFI schemes

1. **The universe.** Every NSE security in series EQ with a mutual-fund ISIN (`INF…`). Before NSE printed ISINs, a symbol’s earlier rows take the symbol’s first ISIN, if that ISIN was already trading in the first month ISINs were printed.
2. **By ISIN.** The ISIN appears in AMFI NAV history or NAVAll.
3. **By symbol chain.** The same NSE symbol continues under a later ISIN that did match. ISINs change at unit splits and AMC mergers.
4. **By NAV fit.** The close tracks one AMFI ETF scheme at a constant unit factor on at least 90% of 20 or more overlapping days, within ±3%.
   
   - Candidates from the same AMC are tried first. The AMC is identified from the ISIN’s issuer prefix.
   - If two schemes fit about equally well (for example, gold ETFs from different AMCs priced per gram), the ISIN is left unmatched rather than guessed.
5. **One ETF can span several AMFI codes.** ISINs that share an AMFI code, or follow each other on one symbol, form one ETF. Its NAV is assembled from all those codes in time order.
   
   - AMCs re-code schemes when they merge. The BeES funds went from Benchmark to Goldman Sachs to Reliance to Nippon, and each step brought a new AMFI code.
   - Remaining traded days without a NAV are filled the same way, by NAV fit against AMFI ETF codes no other ETF has claimed. The 2006–2011 Benchmark codes carry no ISIN at all.

**Result (2026-09-30):**

- **Matched:** 438 of 444 NSE `INF` ISINs (98.6%), covering 99.85% of all ETF traded value since 2011.
- **Unmatched (6):**
  
  - four Franklin close-ended capital-protection funds from 2007–2012, which are not ETFs
  - the pre-2015 Kotak Gold ETF ISIN and the pre-2016 ICICI Gold ETF ISIN, where the fit was ambiguous between several gold ETFs
- **ETFs:** 368 in all, 351 live.
  
  - 260 equity, 40 debt (20 of them liquid), 26 gold, 19 silver and 6 international.
  - 98.5% of traded days have a same-day NAV.

## Unit splits

ETFs split their units, and Nippon’s in particular have. AMFI and the exchange do not always apply a split on the same day.

- **NAV split.** A step in NAV equal to a clean factor (2, 4, 5, 10, 20, 25, 50, 100, 1000, or their inverses), within 10%, is treated as a split.
- **Checked against price.** The close is checked for the same step within seven days.
- **Price-to-NAV unit factor.** Constant between detected steps (NAV steps, price steps and AMFI code switches), set from each stretch’s median close-to-NAV ratio. A genuine 20% premium that lasts a few weeks is therefore never mistaken for a unit change.
- **Result:** 70 NAV splits found, 64 confirmed by price. Of the 91 splits recorded in the corporate-action table for matched ETFs, 87 are found in NAV.

## Tracking difference

- **NAV total return:** splits undone, and distributions from the corporate-action table added back on the first NAV date on or after the ex-date. Most ETFs are growth schemes and never distribute; the old BeES funds did.
- **Benchmark mapping:**
  
  - Equity ETFs are matched to an NSE total-return index by name. The longest index name contained in the scheme name wins, so a Nifty 500 ETF maps to Nifty 500, not Nifty 50.
  - 212 of the 260 live equity ETFs have a benchmark. The rest track BSE or MSCI indices, which are not in the warehouse.
- **Gold ETFs** are compared with the domestic gold price in rupees, including import duty. This is a rough check: it is not the LBMA-based benchmark AMFI uses, and the series updates with a lag.
- **Windows:** calendar 1 and 3 years ending at each month-end. Start and end must each lie within seven days of a common NAV and benchmark date.

**Agreement with AMFI’s own disclosure.**

When equivalent AMFI scheme-name spellings exist, the spelling with the most recent reporting period is used; equal-period ties use a stable name order. This prevents a historical spelling from replacing a current disclosure merely because database rows arrive in a different order. The figures below are the recorded validation sample, rather than a live count of every subsequent refresh.

- AMFI’s `period_date` (the 1st of a month) refers to the end of that same month. Mine agree far better on that reading (median absolute difference 0.003 points) than on the previous month-end (0.026).
- **Equity ETFs,** 4,678 ETF-months, 156 ETFs, 2022-05 to 2026-08:
  
  - median absolute difference 0.0025 percentage points
  - 97.5% within 0.10 points; 98.5% within 0.25 points
  - The rest are mostly months around distributions or splits, where a one-day placement difference moves a 1-year return.
- **Latest month, per ETF:** 88% within 0.10 points and 98% within 0.25 points (n = 170).
- **Gold:** my rough check sits a median 0.10 points from AMFI’s, and only half the months fall within 0.10. It is labelled rough everywhere.

## Caveats

- **Timing.** The close is at 15:30 and NAV is struck on end-of-day prices, so they are not simultaneous. For domestic equity ETFs the gap is minutes and the premium is meaningful.
  
  - For ETFs that hold foreign shares, the gap is hours of foreign trading, so the premium mixes mispricing with timing.
  - Those six ETFs are tagged `international` and kept out of the domestic aggregates.
  - Separately, overseas investment limits have stopped creations at times. Their premiums of about 20% in the last 60 sessions (Motilal Oswal Nasdaq 100, Nasdaq Q50, FANG+ and S&P Top 50; Mirae Hang Seng TECH) are real and persistent, not timing.
- **The close of an illiquid ETF** can be a stale last trade, so its premium is noisy. Single-day premiums above 60% in absolute terms are dropped as bad prints.
- **Liquid ETFs** keep NAV near Rs 1,000 and pay a daily dividend, so their premium is zero by construction. They have their own aggregate and no detail pages.
- **Fee identity and conflicts.** An ETF remains distinct from its fund of funds when names are normalised. If equally recent disclosures for the same ETF and date disagree, that date is omitted from the optional fee history; omitted dates are disclosed in the profile data and its fee-history note. The monthly curve keeps the last unambiguous observation and its actual date, without filling a missing month.
- **TER** is matched by scheme name: 98.9% of live ETFs. From April 2026 AMFI’s printed total includes month-to-date brokerage, so the base expense ratio is shown where it is printed.
- **AUM** is the quarterly average, not month-end.

## Bundles

| Logical name | What it is |
| --- | --- |
| `etf/universe` | One row per live ETF: category, benchmark, AUM, TER, 1- and 3-year tracking difference (mine and AMFI’s), median premium over the last 60 sessions, latest premium, median traded value (20 and 60 sessions), first date with both price and NAV, whether a detail page exists. Compact table (`columns` + `rows`) |
| `etf/premium/<group>_daily` | `equity`, `gold`, `silver`, `debt`, `liquid`, `international`. Each session: the cross-sectional median premium across the group’s ETFs that traded with a same-day NAV, with quartiles and the number of ETFs (weekly until 2026-10-09) |
| `etf/detail/<symbol>` | Top 40 non-liquid ETFs by traded value. Daily: premium at the close and at the day’s average price (traded sessions only), traded value and its 20-session median, 1-year tracking difference at month-ends. `meta.splits` lists detected splits (weekly until 2026-10-09) |
| `etf/liquidity/by_group` | Traded value a session by kind (equity, gold, silver, other debt, liquid, international), 20-session average, from 2011-06-22 |
| `etf/liquidity/concentration` | Monthly: the share of ETF traded value in the most traded one, five and ten ETFs; ETFs that traded; the share that traded on fewer than half the month’s sessions |
| `etf/density/same_index` | Indices tracked by three or more live domestic ETFs (gold and silver by metal): the most traded ETF’s share of trading and of assets and its TER, against the cheapest ETF’s |
| `etf/density/liquidity_premium` | Equity ETFs: median traded value against the 5th-to-95th percentile range of the daily premium over 250 sessions |
| `etf/intraday/spreads` | Once five sessions are captured: per ETF, median quoted spread, two-sided share and five-level depth |
| `etf/stats/premium_median_{equity,gold,silver,international}` | Stat bundles of the daily median premium |
| `etf/stats/traded_value_all_etfs_20d` | Total ETF traded value, 20-session average, Rs crore a session |
| `etf/stats/td_1y_median_equity` | Monthly median 1-year tracking difference across equity ETFs |

**Derived tables in `.cache/derived`:**

- `etf_universe.parquet`
- `etf_daily.parquet`
- `etf_td_monthly.parquet` (with AMFI’s figures joined)
- `etf_splits.parquet`
- `etf_isin_match.parquet`
- `etf_premium_by_category_daily.parquet`
- `etf_checks.json`, which holds all the numbers above

## What the data says (2026-09-30)

- **Domestic equity ETFs trade close to NAV.** The median premium over the last 60 sessions is +0.03%. The share of traded equity-ETF days more than 1% away from NAV fell from 40–55% in 2008–2014 to 1–2% in 2025–26.
- **Tracking difference.** The median 1-year figure for equity ETFs is −0.23 points, and the middle half sits between −0.43 and −0.10. Across equity ETFs it moves closely with TER (correlation −0.71), so cost explains most of it. Factor ETFs (alpha, momentum) lag their indices most, by 1 to 1.6 points.
- **Gold ETFs traded at sustained discounts in 2015–2017** (a median of −1.9%, −2.9% and −1.0% a year across all of them). They have been at small premiums since 2024.
- **ETF trading has exploded.** Average daily traded value across all ETFs was about Rs 60 crore in 2011, Rs 470 crore in 2022, Rs 2,510 crore in 2025 and Rs 5,840 crore so far in 2026.
  
  - Silver, gold and liquid ETFs now lead.
  - Nippon Silver ETF has the highest median traded value over the last 60 sessions, about Rs 405 crore a session.

## What holders got: price against the index (added 2026-10-02)

- **Why:** a holder buys and sells at the exchange price, not at NAV (only authorised participants create or redeem units at NAV). The cost that counts is the gap between the price’s total return and the index’s.
- **Price total return** = NAV total return × (1 + premium), on days the ETF traded. NAV total return already undoes splits and adds back distributions, so this is the return of buying and selling at the close with distributions reinvested. NAV cancels out: the result is the exchange price’s total return.
- **Price tracking difference:** annualised price total return minus the benchmark’s total return, over 1 and 3 years (end points within 7 days of a traded close). It equals the NAV tracking difference plus the annualised change in the premium. Median for equity ETFs on 1 Oct 2026: 0.12 points a year better than the NAV figure.
- **Tracking error:** the annualised standard deviation of the weekly gap between the ETF’s return and the benchmark’s, on price and on NAV, over the last year, using each week’s last traded day. Weekly, because the daily closing premium jitters by a few tenths of a per cent and reverses (NIFTYBEES: 2.6% measured daily on price, 1.2% weekly).
- **Premium record:** over the last 250 sessions, on traded days: median, 5th and 95th percentiles, the share of days more than 1% from NAV, the largest premium and discount, and the latest.
- **Limits:** gold ETFs are measured against a daily domestic gold price struck at a different time from the ETF close, which overstates their tracking error; silver ETFs have no benchmark series yet; iNAV history is not available (Kite does not carry it, and NSE’s ETF page shows the last declared NAV, not iNAV; see 2026-10-09 below).
- Code: `compute/density_etf.py`, bundle `etf/density/holders`.

## AMFI’s tracking error for index funds and ETFs (`etf/tracking_error/*`, added 2026-10-08)

AMFI publishes each index fund’s and ETF’s tracking error every day: the annualised spread of the daily gap between the fund’s return and its index’s, over the past year. SEBI caps it at 2%. These charts use AMFI’s figures as published (Data bank `amfi_tracking_error`, from June 2022), unlike the ETF measures above, which are computed here from prices and NAVs. Code: `pipeline/tipsheet/compute/tracking_error.py`; tests: `pipeline/tests/test_tracking_error.py`.

**How the figures are prepared:**

- Each scheme uses its direct plan’s figure where it has one, else the single published figure (ETFs have one plan).
- Vehicle is ETF if the name says ETF, BeES or exchange traded; otherwise index fund.
- Asset comes from the benchmark’s and scheme’s names, with the passive-fund rules (gold, silver, debt, overseas, else Indian equity).
- Index names are joined across AMFI’s spellings: “NIFTY 50 Total Return Index” = “Nifty 50 TRI”; “S&P BSE Sensex” = “BSE Sensex” (renamed in 2024); “NIFTY200” = “Nifty 200”.
- The monthly series uses each month’s last disclosure day. It starts in the first month with at least half the latest count of equity trackers.

**What it shows (30 September 2026, 644 schemes):**

- Median equity index fund 0.10% a year, median equity ETF 0.06%.
- On the Nifty 50: index funds 0.06%, ETFs 0.03%. On the Sensex: 0.11% against 0.03%. An index fund handles daily cash flows and holds cash for them; an ETF’s units are created and redeemed in blocks, so it stays nearer fully invested.
- Debt index funds are the widest (median 0.42%), mostly target-maturity state-loan funds whose bonds trade rarely.
- Gold and silver ETFs are measured against a domestic price struck at a different time of day.
- Three schemes were above the 2% cap.

## Daily cadence, Kite and NSE’s ETF page (2026-10-09)

**What was weekly.** The data never was. AMFI NAVs (`amfi_nav_history`, `amfi_nav_latest`) are fetched every evening and the bhavcopy every session; `etf_daily.parquet` holds one row per ETF per session with a same-day NAV on 98.5% of traded days. The published bundles were downsampled: `etf/premium/*_weekly` took the median of each week’s daily medians, and `etf/detail/*` took weekly medians, so the page’s charts were weekly. They are daily now. (`etf_issuer_nav_history` is unrelated: US ETF issuers’ NAVs for the global page.)

**Kite’s daily ETF prices add nothing to the bhavcopy** (audit `audits/kite/a8_etf_daily.py`, 2024-10-09 to 2026-10-08, 129,571 ETF-days):

- On the 96% of days Kite has not split-adjusted, its close equals NSE’s official close on every day and its volume equals the bhavcopy’s on 99.999%.
- On the other 4%, Kite back-adjusts price and volume for unit splits by a clean factor (10, 100); after undoing it, no day differs by more than 0.07%.
- Kite lacks 30 ETFs that traded in the window (delisted or renamed; its instrument list is current only), and files a renamed ETF’s whole history under its new symbol.
- So the bhavcopy stays the system of record for closes and volumes, with no licence restriction. A Kite close-based premium would be the same number as the one already published.

**What Kite does add is the live order book**, which no public source keeps. `kite_etf_quotes` captures the best bid and offer and the five visible levels for every ETF at 10:00, 12:00, 14:00 and 15:20 IST on sessions (laptop timer `tipsheet-etf-intraday`, `scripts/etf_intraday.sh`). Only derived figures are published: quoted spread in basis points, the share of snapshots with both sides quoted, and five-level depth in rupees lakh.

**NSE’s ETF page** (`/api/etf`) has no history to scrape: it is a live table that freezes on a 16:00 copy after the close. The historical record of ETF trading is the bhavcopy, already used here; it agrees with the page’s 8 October total of Rs 3,666 crore to 0.004%.

- **It carries no iNAV.** Its column is labelled NAV and means it: on 9 October the payload’s `navDate` was 08-Oct-2026, and the column matched AMFI’s 8 October NAV for 97% of ETFs at 09:18.
- So price against it mixes the premium with the day’s market move, and it was not adopted. (`docs/NSE_DATA_AUDIT.md` had listed it as live iNAV; corrected.)
- NSE’s per-security quote API refused an unprimed session (HTTP 403). At NSE’s rate limit it would take over an hour to cover 350 ETFs once, so it was not pursued.
- iNAV is published by each AMC on its own site.

**Intraday measures** (`compute/etf_intraday.py`, published once five sessions are captured):

- Quoted spread = (best offer - best bid) / midpoint, basis points, when both sides are quoted.
- Two-sided share: the share of snapshots with a bid and an offer both on the book.
- Depth: the rupee value on the five visible levels, bid and offer averaged.
- Medians per ETF over every captured snapshot. Four snapshots a session is a sample of the day, not a full record.
- First capture, 09:16 on 9 October, minutes after the open:
  
  - NIFTYBEES 3.5 bps, GOLDBEES 0.8 bps, SILVERBEES 3.4 bps
  - median across all 352 ETFs 28 bps
  - every ETF had both sides quoted

## Audit findings (2026-10-09)

1. **Untraded sessions were not counted as zero**, though this note said they were. The bhavcopy has no row for an ETF that did not trade, so the 20- and 60-session medians spanned more than 20 or 60 sessions. Fixed by laying each ETF on the session calendar. Today it changes 6 live ETFs’ medians (the 60-session median falls by 1.1 to 9 times); historically, when many ETFs traded rarely, much more.
2. **Three wrong “AMFI’s figure” matches and one wrong TER.** The name matcher’s fuzzy step crossed funds: HDFC Nifty Bank ETF took the HDFC Nifty PSU Bank ETF’s tracking difference (-0.48), and SBI’s Midcap 150 and Smallcap 250 ETFs were matched to DSP’s. HDFC Nifty Private Bank ETF took DSP Nifty Private Bank ETF’s TER, because the HDFC name appears in two spellings in AMFI’s file. A close spelling is now accepted only when the names differ in spacing and filler words; duplicate spellings take the latest.
3. **Checked and correct:**
   
   - NAV dates: every equity, gold and silver ETF’s close fits the same day’s NAV better than the day before or after (2024-10 to 2026-10).
   - Bhavcopy volumes and values against NSE’s ETF page: equal volumes for all 351 traded ETFs on 8 October.
   - Benchmark names against AMFI’s own benchmark field: the 4 mismatches out of 203 are spellings (”&” against “and”).
4. **Bharat Bond and gilt ETFs** fit the previous day’s NAV marginally better than the same day’s (standard deviation 0.15 against 0.16 points). The difference is within noise; it reflects bond valuation timing, not misdated NAVs. Left as is.

## Liquidity findings (2026-10-08)

- **Gold and silver ETFs** were 12% of ETF trading in 2024 and 66% in 2026 so far (silver 44%).
- **Concentration.** The ten most traded ETFs did 97% of ETF trading in 2011 and 57% in the latest month. The single most traded did 81% in mid-2016 and 13% now.
- **The cheapest ETF on an index is rarely the traded one.**
  
  - On the Nifty 50, NIFTYBEES takes 73% of the trading across 22 ETFs, at a TER of 0.03%. The cheapest (0.02%) takes 8%.
  - On gold, the cheapest takes 0.02%.
- **Liquidity and premium noise.** Among equity ETFs, the 5th-to-95th percentile range of the daily premium falls with trading:
  
  - 0.95 points for those trading under Rs 10 lakh a day
  - 0.44 points for those trading over Rs 10 crore
  - Spearman correlation -0.63
  - Gold and silver ETFs do not follow this: their premium moves with the metal market, and the busiest silver ETFs have the widest ranges.
- **Average price against the close.** For the 66 equity ETFs trading Rs 1 crore a day or more, the median premium at the day’s average price is 0.03%, against 0.05% at the close. Only 15 of them cost more over NAV through the day than at the close.

## ETFs on BSE and other non-NSE indices: checked, not built (2026-10-09)

49 of the 261 live equity ETFs have no tracking difference here. They track BSE indices (Sensex, BSE 500, Bharat 22, PSU Bank, Power, India Defence…), MSCI India, or NSE indices missing from the total-return data. Two ways to cover them were tested and rejected.

- **NSE’s ETF page underlying-index label** (`/api/etf`, field `assets`).
  
  - It agrees with our name-based benchmark for 209 of 212 benchmarked ETFs. The 3 misses are NSE’s vague labels (“CPSE ETF”, “Equity Index”), not mapping errors.
  - It adds almost nothing: AMFI’s tracking-difference disclosure, already loaded, names the index for 47 of the 49.
  - It is sometimes wrong itself: MOLOWVOL is labelled “Nifty Midcap 100 TRI”.
  - Not ingested.
- **A total-return index rebuilt from BSE price indices and their daily dividend yield** (`bse_index_archive` has both; BSE’s own total-return series were not reachable: its API returns 403 to plain requests and Asia Index’s site drops the connection).
  
  - Tested on 22 NSE indices where the official total-return index exists (3,400 index-months, 2013–2026), accruing each day’s trailing yield over the calendar days elapsed.
  - The rebuilt 1-year return was off by a median 0.22 points and by 0.86 points or more one month in ten, with a +0.24 point bias. Price alone is off by 1.17 points.
  - Equity ETFs’ tracking differences are around -0.2 points, so the error is as large as the thing measured. Not used.
- **For these ETFs the page shows AMFI’s own published tracking difference** where AMFI prints one (29 of the 49).
- **Revisit** if BSE’s total-return series become fetchable (the Data bank’s BSE adapters use a primed session; a `bse_index_total_returns` dataset would be the route).

## Turnover periods and concentration (clarified 16 October 2026)

Monthly concentration ranks ETFs afresh within each calendar month by the sum of NSE traded value. The top-one share is that month’s largest ETF total divided by **all** ETF turnover in that same month, including liquid and international ETFs. The leader can change between months. The latest point is month to date through its printed session date; it is not a completed-month forecast or an arithmetic mean of daily shares. Historical leader identities are retained in `etf/liquidity/concentration` metadata; the numeric series also carry the leader’s turnover, total turnover and session count.

`etf/liquidity/latest` publishes every ETF observed in the latest month with its latest-session turnover and share, month-to-date turnover and share, and average turnover per observed market session. Funds that stopped trading during the month remain in the denominator. A missing latest-session row counts as zero turnover; a zero-turnover session has no defined share. The metadata prints the first/last dates, number of sessions, and both denominators. This reconciles the monthly concentration plot with a same-period ranked comparison.

The category turnover chart and the total-turnover reading use a **20-session mean**. Per-fund comparison tables use **20- or 60-session medians**, labelled by window. These medians cannot be added to obtain market turnover or divided by the market mean to recover a monthly share. Turnover is exchange activity, not subscriptions, redemptions or net money entering ETFs.

Read-only source reconciliation: `audits/etf/check_turnover.py`. It uses the local derived cutoff, independently reads current-month NSE source rows, checks every turnover cell, and reconciles total shares and top-one/five/ten shares.

## ETF comparison and individual histories (16 October 2026)

`compute/etf_insights.py` and `publish/etf_insights.py` add `etf/insights/comparison` and one on-demand profile per active ETF, keyed by its stable entity ISIN. The density step refreshes these with the existing ETF inputs. Profiles contain only premiums, return gaps, fees and asset statistics, not licensed raw price or index levels.

**Same benchmark.** Domestic fund benchmarks use the computed match, falling back to AMFI’s disclosed benchmark. Spelling normalisation follows the existing tracking-error matcher; gold and silver are grouped by metal. Funds without a matched benchmark remain browsable but are not ranked as peers. Missing return comparisons stay absent; the page prints the number available for each metric. There is no aggregate score or implied recommendation. Gold’s computed return gap retains its approximate-benchmark caveat; overseas premiums retain the foreign-market timing caveat.

**Premium reference.** The latest valid traded closing premium is compared with valid observations from the preceding 250 **market sessions**, excluding that latest observation. At least 60 earlier valid premiums are needed for the 5th to 95th percentile reference range. The percentile uses half weight for ties. A reference is descriptive, not a forecast of fair value or an entry signal. Each fund prints its last premium date and age in market sessions. A streak counts consecutive traded sessions above +1% or below −1%; missing NAVs, missing trades and a change of side break it. A stale fund’s streak ends on its printed observation date and is not extended to today.

**Tracking consistency.** The window is the 36 calendar months ending before the latest data month. Even if the latest session is a month-end, its calendar month is conservatively excluded. The median, middle half, worst observed one-year gap and fraction of observations below zero require at least twelve valid trailing-one-year observations. Overlapping annual returns are not independent trials. A fund with short or missing benchmark history is not given zero tracking difference. The chart preserves missing monthly observations and shows both trailing one-year and annualised three-year NAV gaps. The current active-fund universe is for today’s comparison, not a historical strategy test.

**Fees.** Strict plan-free scheme-name matches retrieve five years of AMFI observations. Each month keeps its last available observation. Reported total TER before April 2026 and base expenses from April 2026 are separate series; they are never silently joined across the reporting-definition change. Name changes can shorten matched history. An illustrative annual fee is holding amount × expense ratio / 100, assuming the holding amount stays constant. Fees already enter NAV returns and are not added again to tracking difference.

**Assets.** The available five-year history uses quarterly average AUM for the current AMFI scheme code, rather than summing overlapping old/new scheme codes. This can shorten history around renamings. Quarter-end labels denote the quarter over which assets were averaged. Changes include market-price effects and must not be described as subscriptions or net flows.

**Order sizes.** The quote table now requires at least five captured sessions for each individual fund. Actual per-fund first/last dates and sample counts are retained. For ₹1 lakh and ₹10 lakh notionals, the published buy/sell capacity is the fraction of all snapshots with valid two-sided quotes and sufficient quantity at the **best** offer/bid. It does not include lower book levels. The cost illustration is order notional × median quoted spread in bps / 10,000, a buy-and-sell round trip at unchanged quotes, before brokerage and taxes. There is no prediction of exact fills, market impact or slippage; stored five-level aggregate quantities do not contain the price at every level.

**Same-index turnover correction.** The older same-index table now uses each fund’s summed turnover over the same 60 market sessions, divided by summed group turnover. Its group daily value is the 60-session mean. Ratios of fund medians are no longer presented as trading market shares.

Checks: `pipeline/tests/test_etf_insights.py`, `audits/etf/check_insights.py` and `audits/etf/check_explorer.mjs`. Each profile has a JSON link; chart table/CSV controls follow the selected measure and fund.

This note is the repository file `docs/methods/etf.md`, rendered as-is.

---

Historical research, not investment advice. This page in HTML: https://tipsheet.markets/methods/etf/. Every published dataset: https://tipsheet.markets/data/v1/manifest.json. A map of the site: https://tipsheet.markets/llms.txt
