STRASMORE/EXPLORE 2,749 QUERIES

Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-date

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

as of series 13×8read in context →
Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-date — 13 rows by 8 columns, computed from US exchange, SIP and OPRA data.
tickerpayments_per_yearlast_ex_datelast_ex_labellast_per_share_usdtypical_gap_daysimplied_next_eximplied_next_label
JEPI122026-09-01Sep 10.3714302026-10-01Oct 1
JEPQ122026-09-01Sep 10.6826302026-10-01Oct 1
QYLD122026-09-21Sep 210.1767282026-10-19Oct 19
SPHD122026-09-21Sep 210.2016282026-10-19Oct 19
DGRO42026-09-15Sep 150.385912026-12-15Dec 15
DVY42026-09-15Sep 151.3291912026-12-15Dec 15
HDV42026-09-16Sep 160.056902026-12-15Dec 15
SPY42026-09-18Sep 181.8888912026-12-18Dec 18
VYM42026-09-18Sep 180.8869912026-12-18Dec 18
SPYD42026-09-21Sep 210.5178912026-12-21Dec 21
NOBL42026-09-23Sep 230.2825912026-12-23Dec 23
SCHD42026-09-23Sep 230.2665912026-12-23Dec 23
VIG42026-09-28Sep 280.9295922026-12-29Dec 29
Rows × columns
13 × 8
Period covered
to
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 Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-date, derived from the stored result.
ColumnTypeRangeNotes
ticker text 13 distinct values (DGRO, DVY, HDV…)
payments_per_year number 4 to 12
last_ex_date date 2026-09-01 to 2026-09-28
last_ex_label text 7 distinct values (Sep 1, Sep 15, Sep 16…)
last_per_share_usd number 0.056 to 1.8888 US dollars
typical_gap_days number 28 to 92
implied_next_ex date 2026-10-01 to 2026-12-29
implied_next_label text 7 distinct values (Dec 15, Dec 18, Dec 21…)

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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH hist AS (
    SELECT ticker, ex_dividend_date, cash_amount, frequency,
           dateDiff('day', lagInFrame(ex_dividend_date) OVER (PARTITION BY ticker ORDER BY ex_dividend_date), ex_dividend_date) AS gap_days
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('SCHD', 'VYM', 'VIG', 'DVY', 'SPYD', 'JEPI', 'JEPQ', 'QYLD', 'SPHD', 'NOBL', 'DGRO', 'HDV', 'SPY')
      AND cash_amount > 0
      AND ex_dividend_date >= today() - 800
)
SELECT ticker,
       any(frequency) AS payments_per_year,
       toString(max(ex_dividend_date)) AS last_ex_date,
       formatDateTime(max(ex_dividend_date), '%b %e') AS last_ex_label,
       round(argMax(cash_amount, ex_dividend_date), 4) AS last_per_share_usd,
       round(quantileDeterministicIf(0.5)(gap_days, cityHash64(ticker, ex_dividend_date), gap_days BETWEEN 5 AND 200)) AS typical_gap_days,
       toString(max(ex_dividend_date) + toIntervalDay(round(quantileDeterministicIf(0.5)(gap_days, cityHash64(ticker, ex_dividend_date), gap_days BETWEEN 5 AND 200)))) AS implied_next_ex,
       formatDateTime(max(ex_dividend_date) + toIntervalDay(round(quantileDeterministicIf(0.5)(gap_days, cityHash64(ticker, ex_dividend_date), gap_days BETWEEN 5 AND 200))), '%b %e') AS implied_next_label
FROM hist
GROUP BY ticker
HAVING countIf(gap_days BETWEEN 5 AND 200) > 0
ORDER BY implied_next_ex, ticker
⌘/Ctrl + Enter

Arbeiten Sie mit diesen Daten in Ihrem KI-Assistenten

Öffnet sich abfragebereit, mit den Daten dieser Seite. Kostenlos, ohne Konto.

Claude ChatGPT Gemini Muse Ihr eigener Agent
More from this analysisUpcoming Ex-Dividend Dates: Stocks This Week
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 → Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scale series 3×8 → 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,749 queries →