step_up

Name: step_up
Creator: Strasmore
Published: 2026-09-17
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-17, from the-7-5-3-1-rule-mutual-funds.

as of 2026-09-17 table 10×5read in context →

step_up — 10 rows by 5 columns, computed 2026-09-17 from US exchange, SIP and OPRA data.
year	step_up_instalment	flat_invested_k	step_up_invested_k	extra_invested_pct
1	500 a month	6	6	0
2	550 a month	12	12.6	5
3	605 a month	18	19.9	10.3
4	666 a month	24	27.8	16
5	732 a month	30	36.6	22.1
6	805 a month	36	46.3	28.6
7	886 a month	42	56.9	35.5
8	974 a month	48	68.6	42.9
9	1072 a month	54	81.5	50.9
10	1179 a month	60	95.6	59.4

Rows × columns: 10 × 5
Computed: 2026-09-17
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 step_up, derived from the stored result.
Column	Type	Range	Notes
`year`	number	1 to 10
`step_up_instalment`	text	10 distinct values (1072 a month, 1179 a month, 500 a month…)
`flat_invested_k`	number	6 to 60
`step_up_invested_k`	number	6 to 95.6
`extra_invested_pct`	number	0 to 59.4	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-09-17, and the query below is what returned them.

the exact SQL behind every number

SELECT
    year,
    concat(toString(toUInt32(round(500 * pow(1.10, year - 1)))), ' a month') AS step_up_instalment,
    round(6000 * year / 1000, 1)                                               AS flat_invested_k,
    round(6000 * (pow(1.10, year) - 1) / 0.10 / 1000, 1)                       AS step_up_invested_k,
    round(((pow(1.10, year) - 1) / 0.10 / year - 1) * 100, 1)                  AS extra_invested_pct
FROM
(
    SELECT arrayJoin(range(1, 11)) AS year
)
ORDER BY year

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 analysisthe-7-5-3-1-rule-mutual-funds

worst_windows table 8×6 → rolling_7y series 193×5 → return_buckets ranking 5×3 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → See all 2,309 queries →