STRASMORE/EXPLORE 2,272 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,272 answered market questions

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

How to Backtest a Trading Strategy in Python
Three runs of backtest.py on the illustrative 60-bar fileranking · 2026-09-16 · 3×4Preview: 3 ranked values, smallest first.
Three runs of backtest.py on the illustrative 60-bar file

Three runs of backtest.py on the illustrative 60-bar file

most recentas of ranking 3×4read in context →
Three runs of backtest.py on the illustrative 60-bar file — 3 rows by 4 columns, computed from US exchange, SIP and OPRA data.
runtotal_return_pctmax_drawdown_pctround_trips
raw tape-49.84-50.012
split-adjusted1.19-3.912
split-adjusted, 0.1% slippage0.69-3.92
the exact SQL behind every number 
SELECT
    run,
    total_return_pct,
    max_drawdown_pct,
    round_trips
FROM
(
    SELECT 1 AS step, 'raw tape' AS run, -49.84 AS total_return_pct, -50.01 AS max_drawdown_pct, 2 AS round_trips
    UNION ALL
    SELECT 2, 'split-adjusted', 1.19, -3.91, 2
    UNION ALL
    SELECT 3, 'split-adjusted, 0.1% slippage', 0.69, -3.90, 2
)
ORDER BY step
Related queries
When market headlines publish, by New York clock hour ranking 24×2 → Growth of one dollar: holding all year vs holding only November through April ranking 21×3 → S&P 500 tracker: May to October vs November to April, season by season ranking 21×3 → SPY distributions by ex-dividend month: inside the May to October window vs outside it ranking 19×3 → See all 2,272 queries →
$