The $100,000 Rule for Stock Options (ISOs)
What $100,000 of grant-date value covered, by grant year (MSFT)ranking ·
2026-11-07 · 11×3
Form 4 lines coded M (derivative exercise), by monthseries ·
2026-11-07 · 24×3
Shares that $100,000 of grant-date value covers, by share priceranking ·
2026-11-07 · 6×4
What $100,000 of grant-date value covered, by grant year (MSFT)
What $100,000 of grant-date value covered, by grant year (MSFT)
| grant_year | grant_price | shares_under_cap_count |
|---|---|---|
| 2016 | 54.8 | 1824 |
| 2017 | 62.58 | 1597 |
| 2018 | 85.95 | 1163 |
| 2019 | 101.12 | 988 |
| 2020 | 160.62 | 622 |
| 2021 | 217.69 | 459 |
| 2022 | 334.75 | 298 |
| 2023 | 239.58 | 417 |
| 2024 | 370.87 | 269 |
| 2025 | 418.58 | 238 |
| 2026 | 472.94 | 211 |
the exact SQL behind every number
SELECT
toString(toYear(date)) AS grant_year,
round(toFloat64(argMin(close, date)), 2) AS grant_price,
toUInt32(floor(100000 / toFloat64(argMin(close, date)))) AS shares_under_cap_count
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'MSFT'
AND date >= '2016-01-01'
GROUP BY grant_year
ORDER BY grant_year
More from this analysisThe $100,000 Rule for Stock Options (ISOs)
Shares that $100,000 of grant-date value covers, by share price
ranking 6×4
→
Form 4 lines coded M (derivative exercise), by month
series 24×3
→
When the US session lands on the Korean clock: June against January 2026
ranking 16×3
→
Time value left in deep in-the-money SPY calls, against the dividend at stake
ranking 15×4
→
See all 3,293 queries →