Remaining buffer and remaining cap by entry point

Name: Remaining buffer and remaining cap by entry point
Creator: Strasmore
Published: 2026-08-12
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-08-12, from How Buffer ETFs Work: Caps and Resets.

as of 2026-08-12 ranking 11×3read in context →

Remaining buffer and remaining cap by entry point — 11 rows by 3 columns, computed 2026-08-12 from US exchange, SIP and OPRA data.
entry_index_move_pct	remaining_buffer_pct	remaining_cap_pct
-12	0	30.7
-9	0	26.4
-6	3.2	22.3
-3	6.2	18.6
0	9	15
3	11.7	11.7
6	14.2	8.5
9	16.5	5.5
12	18.8	2.7
15	20.9	0
18	22.9	0

Rows × columns: 11 × 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

Column definitions for Remaining buffer and remaining cap by entry point, derived from the stored result.
Column	Type	Range	Notes
`entry_index_move_pct`	number	-12 to 18	percent
`remaining_buffer_pct`	number	0 to 22.9	percent
`remaining_cap_pct`	number	0 to 30.7	percent

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.

the exact SQL behind every number

SELECT
    entry_index_move_pct,
    round(greatest((index_level - 91.0) / index_level, 0.0) * 100, 1)  AS remaining_buffer_pct,
    round(greatest((115.0 - index_level) / index_level, 0.0) * 100, 1) AS remaining_cap_pct
FROM
(
    SELECT
        entry_index_move_pct,
        100.0 + entry_index_move_pct AS index_level
    FROM
    (
        SELECT toFloat64(arrayJoin(range(11))) * 3 - 12 AS entry_index_move_pct
    )
)
ORDER BY entry_index_move_pct

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisHow Buffer ETFs Work: Caps and Resets

A 15% cap and 9% buffer, seen from three entry points ranking 21×4 → SPY calendar-year price return against a 15% cap and 9% buffer ranking 12×3 → Compounding the index against the buffered payoff, net of a 0.79% fee ranking 12×3 → Reg T minimum branches for one uncovered AAPL call, by strike (dollars per share) ranking 12×4 → Reg T minimum branches for one uncovered AAPL put, by strike (dollars per share) ranking 11×4 → How far the Friday close lands from the nearest whole dollar ranking 10×3 → See all 2,170 queries →