STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Two Decades of Rising Dividends
How a two-decade streak compounds: Microsoft's annual dividend, year by yearranking · 2026-08-22 · 22×2Preview: 16 ranked values, smallest first. Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grewranking · 2026-08-22 · 20×3Preview: 16 ranked values, largest first.
Dividend Reinvestment Plans (DRIPs) Explained
Days from ex-dividend date to cash: six household dividend payersranking · 2026-08-11 · 6×4Preview: 6 ranked values, largest first. KO: ex-dividend close against the pay date close, 2021 to 2026series · 2026-08-11 · 22×5Preview: a 16-point series, ending lower. Reinvestment events a year: a monthly payer against a quarterly payerranking · 2026-08-11 · 10×3Preview: 10 ranked values, smallest first. How often listed payers distribute, trailing yearranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first.
The 8-4-3 Rule for Mutual Funds, Explained
An illustrative $10,000 SPY stake from year end 2005, marked at each year endranking · 2026-07-31 · 21×3Preview: 16 ranked values, smallest first. Annualized SPY price growth over rolling eight-year windows, by starting year endranking · 2026-07-31 · 14×3Preview: 14 ranked values, smallest first. SPY calendar-year price change vs the 12% assumption, 2006-2025ranking · 2026-07-31 · 20×3Preview: 16 ranked values, smallest first.
How a two-decade streak compounds: Microsoft's annual dividend, year by year

How a two-decade streak compounds: Microsoft's annual dividend, year by year

most recentas of ranking 22×2read in context →
How a two-decade streak compounds: Microsoft's annual dividend, year by year — 22 rows by 2 columns, computed from US exchange, SIP and OPRA data.
yearannual_dividend
20040.08
20050.32
20060.37
20070.41
20080.46
20090.52
20100.55
20110.68
20120.83
20130.97
20141.15
20151.29
20161.47
20171.59
20181.72
20191.89
20202.09
20212.3
20222.54
20232.79
20243.08
20253.4
the exact SQL behind every number 
SELECT toYear(ex_dividend_date) AS year,
       round(sum(cash_amount), 4) AS annual_dividend
FROM global_markets.stocks_dividends
WHERE ticker = 'MSFT'
  AND frequency IN (1, 2, 4, 12)
  AND ex_dividend_date >= '2004-01-01'
  AND ex_dividend_date < toStartOfYear(today())
GROUP BY year
ORDER BY year
More from this analysisTwo Decades of Rising Dividends
Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grew ranking 20×3 → Monthly payers in the dividend record, by completed calendar year ranking 21×3 → Verizon (VZ) dividends per share by calendar year, 2005 to 2025 ranking 21×4 → Verizon (VZ): annual dividend increase in cents and in percent, 2010 to 2025 ranking 16×3 → See all 2,173 queries →
$