RSI Mean Reversion - Swing Trading Backtester

This is a ready-to-use backtesting engine for a counter-trend mean-reversion strategy: buy when RSI shows a stock is oversold, sell when RSI shows it's overbought. Drop in your own daily price data and every result (trade log, win rate, drawdown, equity curve) updates automatically.No VBA, no macros, just formulas you can see and audit in a file that opens in Excel, Google Sheets, or LibreOffice.What you get A fully automated backtest engine. signals, entries, exits, and trade P&L calculated row by row A live Dashboard with editable inputs (RSI period, oversold/overbought thresholds, starting capital) Instant performance stats: total return, number of trades, win rate, average win/loss, profit factor, and max drawdown A benchmark comparison against simple Buy & Hold A built-in equity curve chart, strategy vs. Buy & Hold One year of realistic sample data pre-loaded, so it works the moment you open it A plain-English Read Me tab explaining exactly how the strategy works and how to use the file Who this is forSwing traders, hobbyist quants, and finance students who want to test a real trading idea on real data without writing code or manually calculating indicators in a blank spreadsheet.How it works Open the Price Data tab and paste your own Date/Open/High/Low/Close/Volume history (any stock, ETF, or index daily bars). Open the Dashboard tab and set your parameters in the highlighted input cells. Instantly see your results: return, win rate, drawdown, and the equity curve. Curious how a number was calculated? Every formula in the Backtest Engine tab is visible and editable. Nothing is hidden or locked. File details Format: .xlsx (works in Excel 2016+, Google Sheets, and LibreOffice Calc) Instant digital download, no login or software required beyond a spreadsheet program Fully formula-driven. Recalculates live as you change inputs or paste new data What this template does NOT do It does not pull live or real-time market data. You provide your own historical price data It tests one position at a time (fully in or fully out). It does not model position sizing, stop-loss, or take-profit It is not financial advice, and backtested results do not guarantee future performance FAQDo I need Excel? No. It opens and calculates correctly in Google Sheets and LibreOffice Calc as well.Will this slow down my computer? No, it's a lightweight formula-based file, not a macro or add-in.How is this different from Template #1?Template #1 follows trends (buy strength, ride momentum). This one fades extremes (buy weakness, sell strength). They're built to be compared side by side on the same data.Can I change the strategy rules?The RSI period and oversold/overbought thresholds are all editable inputs. The underlying strategy logic is fixed in this template, but every formula is visible if you want to adapt it.

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing