Stock Backtester Pro Tier — Google Sheets™ Add-on

Run in-sheet historical simulations on up to 3 years of daily market data, explore an expanded library of technical strategies, and export every result for deeper analysis.

Stock Backtester Pro is built for investors, traders, and researchers who prefer the flexibility of Google Sheets™ without writing a line of code.

Try out the Google Sheets™ add-on for free here: https://workspace.google.com/marketplace/app/stock_backtester_for_google_sheets/142821145339

What you get

• 9 additional advanced strategies – ATR Bands, Stochastic Oscillator, CCI, Ichimoku Cloud, Parabolic SAR, Keltner Channels, VWAP Bands, Williams %R and Awesome Oscillator (plus the six core strategies in the Free tier).
• Longer look-back – simulate rule-sets on roughly 3 years of Google Finance™ price history (ticker-dependent).
• Realistic trade-cost engine – model percentage commissions and slippage on every entry and exit.
• Batch & grid testing – back-test multiple tickers or sweep parameter sets in one click.
• Detailed exports – download the daily equity curve, trade log and full JSON report for further crunching in Python/R.
• Unlimited runs – iterate as much as you like; no quota inside the add-on.
• All future Pro features – automatic updates via Google Workspace Marketplace™.

How it works

1. Install the add-on from Google Workspace Marketplace™.
2. Open the sidebar, pick a ticker (or list), select a strategy and set your parameters.
3. Click Run Back-test. The script fetches data from Google Finance™, executes trades at the next-bar open after a rule/condition has been met, applies your cost settings, and writes a full report to a new sheet and an overall log sheet.

No external servers, no coding, no CSV juggling.

Requirements

• A Google account with access to Google Sheets™.
• For best results use Chrome or Safari or another modern browser.

Disclaimer
Stock Backtester is an analytical tool for research and education only. It does not provide financial advice, and past performance does not guarantee future results. You are solely responsible for any trading decisions.

Start your first Pro back-test today – click Subscribe to add the add-on to your Sheets.