Bollinger Bands Breakout - Swing Trading Backtester
This is a ready-to-use backtesting engine for a volatility breakout strategy built on Bollinger Bands: buy when price pushes above its own band, sell once it settles back to the average. 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 (Bollinger Band period, standard deviation multiplier, 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 Bollinger Band period and multiplier in the highlighted 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 Templates 1 and 2? Template 1 follows trends. Template 2 fades extremes. This one trades breakouts in volatility. Different market conditions favor different ones, which is why they're built to be compared side by side.Can I change the strategy rules?Can I change the strategy rules? The band period and standard deviation multiplier are editable inputs. The underlying entry and exit rules are fixed in this template, but every formula is visible if you want to adapt it.
Get it → seetoassets.gumroad.com