expiratiedagen

Name: expiratiedagen
Creator: Strasmore
Published: 2026-09-27
License: https://www.strasmore.com/terms/

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-09-27, from aex-index-options-expiry-and-settlement.

as of 2026-09-27 series 11×4read in context →

expiratiedagen — 11 rows by 4 columns, computed 2026-09-27 from US exchange, SIP and OPRA data.
date	expiratie_label	dagen_te_gaan	ook_us_beurs_gesloten
2026-10-16	16 oktober 2026	19	nee
2026-11-20	20 november 2026	54	nee
2026-12-18	18 december 2026	82	nee
2027-01-15	15 januari 2027	110	nee
2027-02-19	19 februari 2027	145	nee
2027-03-19	19 maart 2027	173	nee
2027-04-16	16 april 2027	201	nee
2027-05-21	21 mei 2027	236	nee
2027-06-18	18 juni 2027	264	ja
2027-07-16	16 juli 2027	292	nee
2027-08-20	20 augustus 2027	327	nee

Rows × columns: 11 × 4
Period covered: 2026-10-16 to 2027-08-20
Computed: 2026-09-27
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

Column definitions for expiratiedagen, derived from the stored result.
Column	Type	Range
`date`	date	2026-10-16 to 2027-08-20
`expiratie_label`	text	11 distinct values
`dagen_te_gaan`	number	19 to 327
`ook_us_beurs_gesloten`	text	2 distinct values (ja, nee)

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-09-27, 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(e.expiratie)                 AS date,
    concat(
        toString(toDayOfMonth(e.expiratie)), ' ',
        arrayElement(['januari', 'februari', 'maart', 'april', 'mei', 'juni',
                      'juli', 'augustus', 'september', 'oktober', 'november', 'december'],
                     toMonth(e.expiratie)),
        ' ', toString(toYear(e.expiratie))
    )                                     AS expiratie_label,
    dateDiff('day', today(), e.expiratie) AS dagen_te_gaan,
    if(h.sluitingsdagen > 0, 'ja', 'nee') AS ook_us_beurs_gesloten
FROM
(
    SELECT
        toStartOfMonth(addMonths(today(), arrayJoin(range(12)))) AS maand_start,
        addDays(maand_start, modulo(5 - toDayOfWeek(maand_start) + 7, 7) + 14) AS expiratie
) AS e
LEFT JOIN
(
    SELECT
        date                AS dag,
        countDistinct(name) AS sluitingsdagen
    FROM global_markets.stocks_market_holidays
    WHERE status = 'closed'
    GROUP BY dag
) AS h ON h.dag = e.expiratie
WHERE e.expiratie >= today()
ORDER BY e.expiratie

SQL to run

SELECT
    toString(e.expiratie)                 AS date,
    concat(
        toString(toDayOfMonth(e.expiratie)), ' ',
        arrayElement(['januari', 'februari', 'maart', 'april', 'mei', 'juni',
                      'juli', 'augustus', 'september', 'oktober', 'november', 'december'],
                     toMonth(e.expiratie)),
        ' ', toString(toYear(e.expiratie))
    )                                     AS expiratie_label,
    dateDiff('day', today(), e.expiratie) AS dagen_te_gaan,
    if(h.sluitingsdagen > 0, 'ja', 'nee') AS ook_us_beurs_gesloten
FROM
(
    SELECT
        toStartOfMonth(addMonths(today(), arrayJoin(range(12)))) AS maand_start,
        addDays(maand_start, modulo(5 - toDayOfWeek(maand_start) + 7, 7) + 14) AS expiratie
) AS e
LEFT JOIN
(
    SELECT
        date                AS dag,
        countDistinct(name) AS sluitingsdagen
    FROM global_markets.stocks_market_holidays
    WHERE status = 'closed'
    GROUP BY dag
) AS h ON h.dag = e.expiratie
WHERE e.expiratie >= today()
ORDER BY e.expiratie

⌘/Ctrl + Enter

Werk met deze data in je AI-assistent

Opent klaar om te bevragen, met de data van deze pagina. Gratis, zonder account.

Claude ChatGPT Gemini Muse Je eigen agent