STRASMORE/EXPLORE 2,170 QUERIES

Forward-declared ex-dividend records on file: the receipt behind this calendar

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-25, from Upcoming Ex-Dividend Dates: Stocks This Week.

as of scalar 1×5read in context →
future ex dates declared
4,344
in the next 7 days
769
fund records declared ahead
0
furthest declared date
2027-11-12
furthest declared label
Nov 12, 2027
Rows × columns
1 × 5
Period covered
Computed
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 Forward-declared ex-dividend records on file: the receipt behind this calendar, derived from the stored result.
ColumnTypeRangeNotes
future_ex_dates_declared number every row is 4,344
in_the_next_7_days number every row is 769
fund_records_declared_ahead number every row is 0
furthest_declared_date date 2027-11-12
furthest_declared_label text 1 distinct value (Nov 12, 2027)

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 , and the query below is what returned them.

the exact SQL behind every number 
SELECT countIf(ex_dividend_date > today()) AS future_ex_dates_declared,
       countIf(ex_dividend_date > today() AND ex_dividend_date <= today() + 7) AS in_the_next_7_days,
       countIf(ex_dividend_date > today() AND ticker IN ('SCHD', 'VYM', 'VIG', 'DVY', 'SPYD', 'JEPI', 'JEPQ', 'QYLD', 'SPHD', 'NOBL', 'DGRO', 'HDV', 'SPY')) AS fund_records_declared_ahead,
       toString(max(ex_dividend_date)) AS furthest_declared_date,
       formatDateTime(max(ex_dividend_date), '%b %e, %Y') AS furthest_declared_label
FROM global_markets.stocks_dividends
WHERE ex_dividend_date > today() - 1
  AND cash_amount > 0

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 analysisUpcoming Ex-Dividend Dates: Stocks This Week
Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-date series 13×8 → Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payers series 12×4 → Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yield series 12×8 → Names going ex-dividend, day by day: the next seven days of declared records series 5×5 → Every mega-cap ex-dividend event of the past six months: price path from the pre-ex close table 5×6 → Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size band table 4×5 → See all 2,170 queries →