STRASMORE/EXPLORE 2,170 QUERIES

Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yield

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 series 12×8read in context →
Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yield — 12 rows by 8 columns, computed from US exchange, SIP and OPRA data.
tickerex_dateex_date_labelper_share_usdpay_datepay_date_labelmcap_bnindicated_yield_pct
GOOGL2026-09-04Sep 40.222026-09-14Sep 1442570.25
GOOG2026-09-04Sep 40.222026-09-14Sep 1442140.26
BAC2026-09-04Sep 40.322026-09-25Sep 254362.05
HD2026-09-03Sep 32.332026-09-17Sep 173362.76
GS2026-09-01Sep 152026-09-29Sep 293021.93
LIN2026-09-03Sep 31.62026-09-17Sep 172261.31
PEP2026-09-04Sep 41.482026-09-30Sep 301974.09
TMUS2026-08-28Aug 281.022026-09-10Sep 101962.23
MCD2026-09-01Sep 11.862026-09-16Sep 161932.73
UNP2026-08-31Aug 311.422026-09-30Sep 301841.83
BLK2026-09-08Sep 85.732026-09-22Sep 221821.95
ADI2026-09-01Sep 11.12026-09-15Sep 151801.19
Rows × columns
12 × 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 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yield, derived from the stored result.
ColumnTypeRangeNotes
ticker text 12 distinct values (ADI, BAC, BLK…)
ex_date date 2026-08-28 to 2026-09-08
ex_date_label text 6 distinct values (Aug 28, Aug 31, Sep 1…)
per_share_usd number 0.22 to 5.73 US dollars
pay_date date 2026-09-10 to 2026-09-30
pay_date_label text 9 distinct values (Sep 10, Sep 14, Sep 15…)
mcap_bn number 180 to 4,257
indicated_yield_pct number 0.25 to 4.09 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 , and the query below is what returned them.

the exact SQL behind every number 
WITH latest AS (
    SELECT ticker, argMax(market_cap, date) AS mcap, argMax(price, date) AS px
    FROM global_markets.stocks_ratios
    WHERE date >= today() - 10
    GROUP BY ticker
)
SELECT d.ticker AS ticker,
       toString(d.ex_dividend_date) AS ex_date,
       formatDateTime(d.ex_dividend_date, '%b %e') AS ex_date_label,
       round(max(d.cash_amount), 4) AS per_share_usd,
       toString(any(d.pay_date)) AS pay_date,
       formatDateTime(any(d.pay_date), '%b %e') AS pay_date_label,
       round(any(l.mcap) / 1e9, 0) AS mcap_bn,
       round(100 * max(d.cash_amount) * max(d.frequency) / any(l.px), 2) AS indicated_yield_pct
FROM global_markets.stocks_dividends d
JOIN latest l ON d.ticker = l.ticker
WHERE d.ex_dividend_date > today()
  AND d.ex_dividend_date <= today() + 14
  AND d.cash_amount > 0
  AND d.distribution_type = 'recurring'
  AND d.frequency > 0
  AND l.mcap >= 10000000000
  AND d.ticker NOT IN ('SPCX')
GROUP BY d.ticker, d.ex_dividend_date
ORDER BY any(l.mcap) DESC
LIMIT 12

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 → 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,170 queries →