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
Two Decades of Rising Dividends
How a two-decade streak compounds: Microsoft's annual dividend, year by yearranking · 2026-09-26 · 22×2Preview: 16 ranked values, smallest first. Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grewranking · 2026-09-26 · 20×3Preview: 16 ranked values, largest first.
Dividend Reinvestment Plans (DRIPs) Explained
Days from ex-dividend date to cash: six household dividend payersranking · 2026-08-11 · 6×4Preview: 6 ranked values, largest first. KO: ex-dividend close against the pay date close, 2021 to 2026series · 2026-08-11 · 22×5Preview: a 16-point series, ending lower. Reinvestment events a year: a monthly payer against a quarterly payerranking · 2026-08-11 · 10×3Preview: 10 ranked values, smallest first. How often listed payers distribute, trailing yearranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first.
The 8-4-3 Rule for Mutual Funds, Explained
An illustrative $10,000 SPY stake from year end 2005, marked at each year endranking · 2026-07-31 · 21×3Preview: 16 ranked values, smallest first. Annualized SPY price growth over rolling eight-year windows, by starting year endranking · 2026-07-31 · 14×3Preview: 14 ranked values, smallest first. SPY calendar-year price change vs the 12% assumption, 2006-2025ranking · 2026-07-31 · 20×3Preview: 16 ranked values, smallest first.
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
More from this analysisThe Rule of 72 (and Where It Breaks)
Rule of 72 against the exact doubling time, by annual return ranking 11×4 → Average return against compound return, five price histories, 2015 through 2024 ranking 5×4 → Ten-year US inflation rate and the time to halve a dollar's purchasing power table 26×4 → Years to double: the Rule of 72 on the average against the compounded path table 5×5 → See all 3,256 queries →
$