Calendar days from ex-dividend date to record date (trailing 12 months)

Name: Calendar days from ex-dividend date to record date (trailing 12 months)
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Ex-Dividend Date vs. Record Date: Same Day?.

as of 2026-08-22 ranking 4×3read in context →

Calendar days from ex-dividend date to record date (trailing 12 months) — 4 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
calendar_days_ex_to_record	dividends	pct
0	45947	99
1	232	0.5
2	162	0.3
3	81	0.2

Rows × columns: 4 × 3
Computed: 2026-08-22
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Calendar days from ex-dividend date to record date (trailing 12 months), derived from the stored result.
Column	Type	Range	Notes
`calendar_days_ex_to_record`	number	0 to 3
`dividends`	number	81 to 45,947
`pct`	number	0.2 to 99	percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT dateDiff('day', ex_dividend_date, record_date) AS calendar_days_ex_to_record,
       count() AS dividends,
       round(100.0 * count() / sum(count()) OVER (), 1) AS pct
FROM global_markets.stocks_dividends
WHERE currency = 'USD'
  AND ex_dividend_date >= today() - INTERVAL 12 MONTH
  AND ex_dividend_date <= today()
  AND record_date IS NOT NULL
GROUP BY calendar_days_ex_to_record
HAVING dividends >= 20
ORDER BY dividends DESC

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisEx-Dividend Date vs. Record Date: Same Day?

The T+1 cutover, week by week: share of dividends with ex-date = record date, April–July 2024 ranking 18×3 → Ex-date vs. record date by year: share identical, and the median gap in calendar days ranking 12×4 → Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 months table 2×6 → One real dividend: AAPL's most recent completed payout, all four dates scalar 1×9 → Median waits along the dividend calendar (trailing 12 months, recurring US dividends) scalar 1×3 → Shares held short against average daily volume, large dividend payers ranking 8×4 → See all 2,170 queries →