SPY calendar-year price return against a 15% cap and 9% buffer

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-12, from How Buffer ETFs Work: Caps and Resets.

Rows × columns

12 × 3

Computed

2026-08-12

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-12, and the query below is what returned them.

SELECT
    outcome_year,
    index_return_pct,
    multiIf(index_return_pct >  15.0, 15.0,
            index_return_pct >=  0.0, index_return_pct,
            index_return_pct >= -9.0, 0.0,
            index_return_pct + 9.0) AS fund_return_pct
FROM
(
    SELECT
        toString(toYear(date)) AS outcome_year,
        round((toFloat64(argMax(close, date)) / toFloat64(argMin(close, date)) - 1) * 100, 1) AS index_return_pct
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2014-01-01'
      AND date <  '2026-01-01'
    GROUP BY toYear(date)
)
ORDER BY outcome_year