📊Back after a few months. Still running the same systematic US small-cap strategy.
Live IBKR since Dec 2022: 2023: +39.7% | 2024: -2.1% | 2025: +8.3% | 2026 YTD: +4.7% | 25Y backtest: 32% CAGR, Sharpe 1.5, 1 negative year. Sharing rebalancing notes again. ⚠️Not financial advice
Build a moving-average crossover in Excel, calculate 20- and 50-day lines, flag crosses, simulate trades, then plot drawdowns.
Adjust stop-loss levels in your sheet to see how risk controls transform raw signals into tradable strategies.
Data beats intuition when you test ideas.
Pose a question, such as whether low-beta stocks outperform, then run a rolling 12-month backtest, record drawdowns, and tweak your entry and exit rules until your strategy proves reliable across bull and bear markets.
A simple two-step filter uncovers hidden winners: rank 500 large-caps by trailing six-month momentum, then remove the 20% most volatile.
Review quarterly results in a spreadsheet and adjust your volatility cutoff to keep your edge fresh and consistent.
Worksheet-driven backtests build real skills: calculate short and long moving averages, flag each crossover, then simulate trades in a sheet.
Chart cumulative returns and drawdowns side by side to see how stop-loss adjustments can transform raw signals into a live-ready strategy.
Worksheet-driven backtests build real skills: calculate short and long moving averages, flag each crossover, then simulate trades in a sheet.
Chart cumulative returns and drawdowns side by side to see how stop-loss adjustments can transform raw signals into a live-ready strategy.
Theory becomes actionable with worksheets. Calculate 10 and 50-day moving averages, flag each crossover, and simulate trades in Excel.
Chart cumulative returns alongside drawdowns, then adjust stop-loss levels to see how risk controls transform raw signals into live strategies.