Moving Average Crossover - Swing Trading Backtester

This is a ready-to-use backtesting engine for a classic trend-following swing trading strategy: a moving-average crossover, filtered by RSI momentum. 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 (moving average lengths, RSI settings, 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, so you know if the strategy actually adds value 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.Can I change the strategy rules? The moving average lengths, RSI period, and RSI threshold are all editable inputs. The underlying strategy logic (crossover + RSI filter) 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