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-10-17, from Upcoming Ex-Dividend Dates: Stocks This Week.
| ticker | ex_date | ex_date_label | per_share_usd | pay_date | pay_date_label | mcap_bn | indicated_yield_pct |
|---|---|---|---|---|---|---|---|
| COST | 2026-10-30 | Oct 30 | 1.47 | 2026-11-13 | Nov 13 | 433 | 0.6 |
| PG | 2026-10-23 | Oct 23 | 1.0885 | 2026-11-16 | Nov 16 | 365 | 2.77 |
| CAT | 2026-10-26 | Oct 26 | 1.63 | 2026-11-19 | Nov 19 | 338 | 0.89 |
| DELL | 2026-10-20 | Oct 20 | 0.63 | 2026-10-30 | Oct 30 | 301 | 0.53 |
| MS | 2026-10-30 | Oct 30 | 1.15 | 2026-11-13 | Nov 13 | 286 | 2.53 |
| TXN | 2026-10-30 | Oct 30 | 1.52 | 2026-11-10 | Nov 10 | 255 | 2.18 |
| GEV | 2026-10-27 | Oct 27 | 0.5 | 2026-11-24 | Nov 24 | 247 | 0.22 |
| CVS | 2026-10-22 | Oct 22 | 0.665 | 2026-11-02 | Nov 2 | 118 | 2.87 |
| LOW | 2026-10-21 | Oct 21 | 1.25 | 2026-11-04 | Nov 4 | 110 | 2.55 |
| BNY | 2026-10-26 | Oct 26 | 0.63 | 2026-11-09 | Nov 9 | 96 | 1.77 |
| EPD | 2026-10-30 | Oct 30 | 0.56 | 2026-11-13 | Nov 13 | 77 | 6.3 |
| CL | 2026-10-20 | Oct 20 | 0.53 | 2026-11-13 | Nov 13 | 74 | 2.29 |
- 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
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 12 distinct values (BNY, CAT, CL…) | |
ex_date |
date | 2026-10-20 to 2026-10-30 | |
ex_date_label |
text | 7 distinct values (Oct 20, Oct 21, Oct 22…) | |
per_share_usd |
number | 0.5 to 1.63 | US dollars |
pay_date |
date | 2026-10-30 to 2026-11-24 | |
pay_date_label |
text | 9 distinct values (Nov 10, Nov 13, Nov 16…) | |
mcap_bn |
number | 74 to 433 | |
indicated_yield_pct |
number | 0.22 to 6.3 | 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.
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 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
اعمل على هذه البيانات في مساعد الذكاء الاصطناعي الخاص بك
يُفتح جاهزًا للاستعلام، مع بيانات هذه الصفحة. مجانًا، دون حساب.