Microsoft dividend dates, from the T+2 era into T+1

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 How Stock Settlement Works Under T+1.

Rows × columns

13 × 6

Period covered

2023-08-16 to 2026-08-20

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

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.

SELECT
    toString(ex_d)                        AS ex_date,
    formatDateTime(ex_d, '%b %e, %Y')     AS ex_date_label,
    formatDateTime(rec_d, '%b %e, %Y')    AS record_date_label,
    formatDateTime(pay_d, '%b %e, %Y')    AS pay_date_label,
    round(toFloat64(amount), 2)           AS dividend_usd,
    dateDiff('day', ex_d, rec_d)          AS ex_to_record_days
FROM
(
    SELECT
        ex_dividend_date  AS ex_d,
        max(record_date)  AS rec_d,
        max(pay_date)     AS pay_d,
        max(cash_amount)  AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'MSFT'
      AND ex_dividend_date >= '2023-08-01'
      AND record_date >= ex_dividend_date
      AND pay_date > ex_dividend_date
    GROUP BY ex_dividend_date
)
ORDER BY ex_d