STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

The Rule of 72 (and Where It Breaks)
An 8% average return at rising volatility: compound rate and doubling timeranking · 2026-10-09 · 8×3Preview: 8 ranked values, largest first. Rule of 72 against the exact doubling time, by annual returnranking · 2026-10-09 · 11×4Preview: 11 ranked values, largest first. Average return against compound return, five price histories, 2015 through 2024ranking · 2026-10-09 · 5×4Preview: 5 ranked values, smallest first. Ten-year US inflation rate and the time to halve a dollar's purchasing powertable · 2026-10-09 · 26×4 Years to double: the Rule of 72 on the average against the compounded pathtable · 2026-10-09 · 5×5
An 8% average return at rising volatility: compound rate and doubling time

An 8% average return at rising volatility: compound rate and doubling time

most recentas of ranking 8×3read in context →
An 8% average return at rising volatility: compound rate and doubling time — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
annual_volatilitycompound_return_pctdoubling_years
0%89
5%7.889.1
10%7.59.6
15%6.8810.4
20%611.9
25%4.8814.6
30%3.520.1
35%1.8837.3
the exact SQL behind every number
SELECT
    concat(toString(vol_pct), '%')       AS annual_volatility,
    round(compound * 100, 2)             AS compound_return_pct,
    round(log(2) / log(1 + compound), 1) AS doubling_years
FROM
(
    SELECT
        vol_pct,
        0.08 - 0.5 * pow(vol_pct / 100.0, 2) AS compound
    FROM
    (
        SELECT arrayJoin([0, 5, 10, 15, 20, 25, 30, 35]) AS vol_pct
    )
)
ORDER BY vol_pct ASC
$