Upcoming VIX settlement dates and the SPX expiry each one uses
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-11-07, from How VIX Settlement Works: the SOQ.
| settlement_date | weekday | settlement_label | strip_expiry_label | days_away |
|---|---|---|---|---|
| 2026-11-18 | Wed | Nov 18, 2026 | Dec 18, 2026 | 11 |
| 2026-12-16 | Wed | Dec 16, 2026 | Jan 15, 2027 | 39 |
| 2027-01-20 | Wed | Jan 20, 2027 | Feb 19, 2027 | 74 |
| 2027-02-17 | Wed | Feb 17, 2027 | Mar 19, 2027 | 102 |
| 2027-03-17 | Wed | Mar 17, 2027 | Apr 16, 2027 | 130 |
| 2027-04-21 | Wed | Apr 21, 2027 | May 21, 2027 | 165 |
| 2027-05-19 | Wed | May 19, 2027 | Jun 18, 2027 | 193 |
| 2027-06-16 | Wed | Jun 16, 2027 | Jul 16, 2027 | 221 |
| 2027-07-21 | Wed | Jul 21, 2027 | Aug 20, 2027 | 256 |
| 2027-08-18 | Wed | Aug 18, 2027 | Sep 17, 2027 | 284 |
| 2027-09-15 | Wed | Sep 15, 2027 | Oct 15, 2027 | 312 |
| 2027-10-20 | Wed | Oct 20, 2027 | Nov 19, 2027 | 347 |
| 2027-11-17 | Wed | Nov 17, 2027 | Dec 17, 2027 | 375 |
- Rows × columns
- 13 × 5
- 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 |
|---|---|---|---|
settlement_date |
date | 2026-11-18 to 2027-11-17 | |
weekday |
text | 1 distinct value (Wed) | |
settlement_label |
text | 13 distinct values (Apr 21, 2027, Aug 18, 2027, Dec 16, 2026…) | |
strip_expiry_label |
text | 13 distinct values (Apr 16, 2027, Aug 20, 2027, Dec 17, 2027…) | |
days_away |
number | 11 to 375 |
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.
SELECT
toString(settle_date) AS settlement_date,
formatDateTime(settle_date, '%a') AS weekday,
formatDateTime(settle_date, '%b %e, %Y') AS settlement_label,
formatDateTime(strip_expiry, '%b %e, %Y') AS strip_expiry_label,
dateDiff('day', today(), settle_date) AS days_away
FROM
(
SELECT
third_friday - 30 AS settle_date,
third_friday AS strip_expiry
FROM
(
SELECT
addMonths(toStartOfMonth(today()), n) AS month_start,
month_start + (((12 - toInt32(toDayOfWeek(month_start))) % 7) + 14) AS third_friday
FROM
(
SELECT arrayJoin(range(14)) AS n
)
)
)
WHERE settle_date >= today()
ORDER BY settle_date
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.