Market activity: sources, measures and checks
The market-activity section (/activity/ and its four chapter pages) answers one question: how much is India’s market trading, and where? This note says where every number comes from, how it is measured, what was checked, and what the figures cannot tell you.
Code: pipeline/tipsheet/compute/activity.py, compute/activity_who.py, publish/activity.py, step steps/activity_market.py. Bundles: activity/*. The source audit behind the section is docs/NSE_DATA_AUDIT.md.
Sources
| What | Source (dataset) | From |
|---|---|---|
| Every NSE segment: turnover, trades, contracts, premium, trading days, market value | NSE business growth (nse_business_growth_history), monthly | Cash Apr 1999; F&O Apr 2009; currency Aug 2008; rate futures Aug 2009; corporate bonds Sep 2007; wholesale debt Apr 2009; commodity Oct 2018; tri-party repo Jul 2023; T+0 Mar 2024; gold receipts May 2026 |
| BSE equity derivatives: premium, notional, contracts, open interest | BSE key statistics (bse_derivatives_business, report T) | Jan 2004 (premium from Sep 2015) |
| BSE month-end open interest from 2024; NSE month-end open interest after the Bulletin’s latest month | BSE derivatives bhavcopy; NSE F&O bhavcopy (UDiFF) | Jan 2024; Jul 2024 |
| BSE cash turnover | BSE key statistics (bse_equity_business) | Apr 1999 |
| NSE open interest; NSE, BSE and MSEI cash statistics; demat accounts | SEBI Bulletin (sebi_bulletin_series) | Apr 2014 (accounts Jul 2014; active accounts Mar 2025) |
| Commodity derivatives on MCX, NCDEX, BSE, ICEX and NMCE | SEBI Bulletin (sebi_bulletin_series, family commodity_derivatives), monthly | MCX and NCDEX Apr 2015; BSE Oct 2018 (no trading from 2025-26); ICEX Aug 2017 to Mar 2022; NMCE to Sep 2018 |
| Delivery | NSE security-wise delivery files (nse_delivery eras) with the bhavcopy | Feb 2002 |
| ETFs, REITs, InvITs, gold bonds, SME shares | NSE bhavcopy (nse_bhavcopy eras) | ETFs Jun 2011; SME Nov 2012; SGB Jun 2016; InvITs May 2017; REITs Apr 2019 |
| Who trades: turnover by client category | NSE category-wise turnover, cash (nse_cm_category_turnover) and F&O (nse_fo_category_turnover), daily, new in wave 2 | Cash Apr 2005; F&O Mar 2011 |
| How orders reach the market | NSE mode of trading (nse_mode_of_trading), monthly PDFs, new in wave 2 | Dec 2019 |
| F&O contracts by participant type | NSE participant-wise trading volumes (nse_participant_vol) | Jan 2012 |
Every monthly series ends at the last complete month. NSE’s current month is month-to-date in business growth; showing it would read as a collapse.
Measures
Money that changes hands leads. Shares are measured by cash turnover. Futures are measured at traded value (price × quantity), as exchanges report them. Options are measured by premium, the money the buyer pays the seller. Notional option turnover (strike × quantity, the figure exchanges lead with) values each option at the full size of its underlying; on NSE in 2025-26 it was about 450 times the premium. Notional is kept, labelled, for context.
Currency and commodity derivatives. NSE’s segment total (TOTAL_TRADED_VAL) is already futures turnover plus option premium. The pipeline checks this every month (currency 219 months, commodity 97: the parts equal the total to floating-point precision). The option notional value is published separately (cd_opt_notional_cr, comder_opt_notional_cr). The old activity page labelled these totals “notional”; that was wrong.
Commodity derivatives on every exchange. MCX trades almost all of India’s commodity derivatives (98% of the money in August 2026); NSE’s segment, the only one in NSE’s own statistics, is under 1%. The other exchanges come from the SEBI Bulletin’s monthly trend table for each exchange; NSE stays on its own business-growth figures, and the Bulletin’s NSE rows are a check (futures turnover equal in all 95 months from October 2018, option premium in all 17 months the Bulletin prints it). Money traded is futures at traded value plus option premium. Where a table prints a total it is used; older tables print only commodity groups (agriculture, bullion, metals, energy, index futures), which are summed. The monthly MCX figures add up to SEBI’s own financial-year rows to the crore in every year checked (for 2025-26, futures 1,64,88,278 crore and option premium 16,72,788 crore).
- Option premium on MCX and NCDEX is counted only from April 2025. Before that the Bulletin prints commodity options at notional value only (its note: “Options Turnover is based on Notional value”), so those options are left out rather than estimated. Commodity’s share of the mix is understated before April 2025; MCX options ran to ₹495 lakh crore notional in 2024-25. Part of the step up in April 2025 is this, not more trading; futures alone were 2.4 times the previous year’s in 2025-26.
- A month counts only when MCX reports it, so commodity figures, and the mix, end at the Bulletin’s latest month, about six weeks behind NSE’s own statistics. BSE, ICEX and NMCE stop reporting when their segments stop trading; a missing row counts as no trading.
- Contract counts are not used: the Bulletin’s MCX option-contract totals run about 1% above their printed parts in December 2025 to March 2026, while turnover adds up.
Where the money goes (the mix). Each month’s money traded is summed over: shares (NSE + BSE cash), equity futures (NSE + BSE), equity option premium (NSE + BSE), currency derivatives, commodity derivatives (MCX, NCDEX, NSE, BSE and the smaller exchanges, above), interest-rate futures, corporate bonds reported on CBRICS, the wholesale debt market and tri-party repo (currency and the last four NSE only; BSE’s are not in the data). Shares are each segment’s part of that sum. The mix starts in April 2015, when NSE first published premium. A month is kept when the four large groups and MCX report; a small segment missing that month is named in missing_segments (NSE serves no wholesale-debt figures for May–December 2019, and wholesale debt is published about a month late). On the site, nine segments are folded into five groups, because a stacked chart with more than six bands stops reading.
Every segment against its record. For each segment, the trailing 12-month money traded divided by the highest trailing 12-month total up to that month. No later data enters any month, so a reading of 100 means a record at the time. This puts segments that differ in size by a factor of a thousand on one 0–100 scale.
Turnover against market value. Average daily cash turnover × 250 sessions ÷ month-end market value, NSE.
Delivery share. For every security-day in both NSE’s delivery file and the bhavcopy, deliverable quantity (capped at traded quantity) is valued at that day’s average traded price (turnover ÷ quantity). The share is the month’s sum of delivered value over the month’s traded value for the same security-days, so a missing delivery file never dilutes the share. In the median month the matched security-days carry 99.9% of NSE’s published cash turnover; the lowest is 61% (February 2002, the first month).
Delivery value. The cash-market page also charts that numerator, delivery_value_cr, in ₹ lakh crore per month, from February 2002. It is an estimate: the price is the average across all trades in that security that day, not a delivery-only execution price. NSE’s MTO file labels the deliverable quantity gross across client level. Missing security-days are not extrapolated; the level can therefore be understated when coverage is incomplete, particularly early in the series. All matched bhavcopy series count, including instruments other than ordinary shares. Only completed calendar months are shown.
Clearing-level delivery and retail. NSE separately publishes monthly settlement statistics, including value of shares deliverable and funds pay-in. The page says its deliverable percentage is computed at clearing-corporation level. The checked-in historical seed (docs/reference/nse-settlement/history.json) preserves its published amounts and retrieval time; this source requires an explicit refresh and is not yet scheduled. Published percentages that disagree with the amounts are preserved and flagged in the seed, including June 2019 (reported 23.48%, amounts imply 23.67%). Keep that measure separate from the client-gross MTO estimate; funds pay-in is a cash obligation, not delivery value. The security-wise archive has no investor category. The cash category-turnover workbook supplies retail buys and sells, from which net buying can be calculated, but includes intraday trades and does not identify retail delivery value. No public retail delivery-only breakdown was found in the reports inspected on 15 October 2026; do not multiply retail turnover share by aggregate delivery value.
ETFs. Exchange-traded funds are mutual-fund units, so their ISINs start INF; they trade in series EQ. The bhavcopy carries ISINs from June 2011, so the ETF series starts then (ETFs have listed since 2002). A few listed closed-ended fund units also carry INF ISINs; their turnover is negligible. The adjusted price panel’s is_etf flag used to match ICICI Bank and Kotak Mahindra Bank through a symbol rule; since 2026-10-07 it is set by ISIN alone (any INF ISIN in the security’s history), but this series keeps its own ISIN test.
REITs, InvITs, sovereign gold bonds, SME shares. Bhavcopy series RR, IV, GB, and SM plus ST.
How spread out trading is. From the adjusted price panel: main-board shares (series EQ, BE and BZ; SME shares and ETFs left out). Each stock’s turnover is summed over the calendar month and stocks are ranked by it. stocks_for_half is the fewest stocks whose turnover adds up to half the month’s total; top10_share_pct and top50_share_pct are the ten and fifty most-traded stocks’ shares; half_share_pct is stocks_for_half over the stocks that traded that month. Months with fewer than 10 sessions are left out. The count grows with the number of listed companies, which is why the share of traded stocks is published beside it. ETFs listed before 2011 that never carried an ISIN would count as shares; none was found.
Open interest. Notional value of equity futures and options open at month end, contracts expiring on the last day left out (they settle that evening). Divided by NSE’s month-end market value. Month-end readings move with the expiry calendar.
- NSE: the SEBI Bulletin, which runs about two months behind (on 28 Oct 2026 its latest month was August). Later complete months come from NSE’s F&O bhavcopy (
fo_analytics.month_end_open_interest), which matches the Bulletin exactly in contracts in every month since 2020 and within 0.2% in value since July 2024.eqd_nse_oi_from_bhavcopy= 1 marks those months; the Bulletin replaces them when it arrives. - BSE: its own statistics to 2023, its bhavcopy from 2024 (
eqd_bse_oi_from_bhavcopy). BSE’s month-end figure keeps contracts expiring that day; that differs only in a month that ends on a Sensex expiry (April 2026: BSE’s figure ₹8.99 lakh crore, ₹0.66 lakh crore open after the close, so BSE’s share of OI is 3.4%, not 32%). Elsewhere the two match to 0.01%. - A month is filled from a bhavcopy only when the file holds at least as many sessions as the exchange reports for it and a later session exists.
- BSE’s share of OI swings with the weekly cycle: Sensex OI builds to each Thursday expiry, so a month ending on a Wednesday (September 2026, 22%) reads far higher than one ending just after an expiry.
Exchange shares. Cash: NSE, BSE and MSEI turnover from the SEBI Bulletin. Option premium and open interest: NSE and BSE. The Bulletin’s NSE cash turnover equals NSE’s own business-growth figure in all 149 months checked (median difference 0.00002%).
Who trades
NSE publishes buy and sell value by client category every session, in two tables over time.
- The client table (cash and F&O from 2023): Bank, Insurance, Mutual funds, AIF, PMS, FPI, Retail, Others. Its buy side and its sell side each equal NSE’s total for the day: cash turnover, or F&O futures turnover plus option premium. This holds to the crore on every session sampled from 2023 to 2026. A category’s share is its buy plus sell over twice the table’s total. In cash, from 2025 NSE moves FPI out of the exchange table into a separate NSDL line and folds FPI trades into Others, so the site combines FPI and Others in cash for a consistent series. “Retail” is NSE’s definition: individuals, HUFs, NRIs, proprietorships and partnership firms. “Others” includes companies, trusts and proprietary (own-account) trading by brokers.
- The legacy table (cash 2005 to 2023, F&O March 2011 to 2023): cash BNK, DFI, PRO-TRADES, OTHERS; F&O mutual funds, proprietary, others, at notional value. It leaves out FIIs (and, in cash, mutual funds and insurers), so it does not add up to the market. Its shares are taken against NSE’s own daily total for the same sessions (cash turnover; F&O notional turnover), using business-growth daily totals from March 2011 and the monthly total, for months where every session has a file, before that. The part the table leaves out is published as a remainder named for what it holds. For F&O that remainder is the FIIs’ share of notional turnover, and it agrees with NSE’s separate participant-wise contract data, a different file and a different measure: by calendar-year average, 16.8% against 16.2% in 2012, 18.9% against 18.7% in 2019 and 6.2% against 5.9% in 2023.
- Cash files up to March 2011 say their figures are “settlement wise, inclusive of securities in In-Delivery and exclusive of securities in No-Delivery”, while the denominator (NSE’s turnover) counts every trade. For those years the remainder also holds that difference, so it is an upper bound on the FII, mutual-fund and insurer share.
- Transition files in 2023 carry both tables for the same session; both are stored and neither is spliced into the other. Legacy and client shares are different measures and are never drawn as one line.
- A month’s shares are summed rupees over the month, and a month counts when at least 90% of NSE’s trading days have a file; the session count is published. NSE sometimes serves another session’s workbook under a dated name (four F&O files among 1,176 sessions in 2022-2026, for example the file named 17 February 2022 holds 17 February 2023); my data archive skips these, never re-dates them, and records a warning. On 8 September 2025 the F&O client table is ₹25 crore (buy) and ₹4 crore (sell) short of NSE’s total of ₹1,33,775.63 crore, consistent with a small row missing from the file; it is kept as published and listed as a reviewed audit exception.
Participant contracts. NSE’s participant-wise trading volumes give contracts traded by clients, DIIs, FIIs and proprietary traders (long plus short). They are contracts, not value: a cheap option counts the same as a large future.
Demat accounts. Accounts at NSDL and CDSL at month end (SEBI Bulletin). One investor can hold several accounts, so this is not a count of people.
How orders reach the market
NSE’s monthly mode-of-trading reports give each terminal type’s share of turnover, by what the broker declared at order entry: non-algo (a person at a dealer terminal), algo, direct market access, colocation (servers in NSE’s data centre), internet, mobile and smart order routing. F&O shares are of turnover with options at premium. The site groups algo, DMA and smart order routing as “other automated” and calls colocation plus other automated “machine-sent”.
Served from December 2019. Not served (HTTP 404): January–June 2020, October 2021 and August 2024. NSE’s files for August 2025 (both segments) are damaged PDFs and its F&O file for July 2026 has a blank table; these are excluded by a reviewed exact-file manifest in my data archive, so a corrected file would be picked up automatically.
Source quirks shown as published
- Corporate bonds (CBRICS): NSE’s figures fall almost to nothing from January 2012 to March 2014, trades and value together.
- Interest-rate futures: dormant from late 2011 until the relaunch in January 2014.
- Wholesale debt: no figures for May–December 2019.
- BSE cash turnover: a spike in March 2017, as published.
- Currency derivatives: the segment shrank from April 2024. The RBI’s directions of 5 January 2024 require exchange-traded currency derivatives to be backed by an underlying exposure; they were due on 5 April and came into force on 3 May 2024 (RBI deferral of 4 April 2024), and brokers began asking for proof in early April.
What the figures cannot tell you
They describe activity; they do not forecast. A high reading is not a signal by itself. The section does not attribute changes to causes beyond rule changes with known dates (SEBI’s F&O measures from 20 November 2024, the RBI’s currency rule in force from 3 May 2024, BSE’s Sensex options relaunch in May 2023). Currency, rate and debt figures are NSE only; commodity figures cover every exchange.