How to Backtest Trading Strategies in Google Sheets
With Zero Coding Skills
This tutorial video shows you how to do rigorous stock backtesting directly within Google Sheets without needing to know how to code. The free Stock Backtester for Google Sheets add-on allows you to run historical stock backtesting simulations using a backtesting engine that has been calibrated on leading Python backtesting libraries (e.g. backtesting.py).
The free version includes 5 technical indicator and pattern strategies, including SMA Crossover, RSI Bands, Bollinger Bands Reversion, MACD Crossover, Donchian Channels Breakout. The Google Sheets add-on lets you choose trade direction strategy as well, including Long only, Short only, and Long and Short Reversing.
Public Beta Release
You can learn more about the Stock Backtester here: https://stockbacktester.com/
And install the add-on directly from the Google Workspace Marketplace.
Read more about the add-on’s backtesting methodology here: https://stockbacktester.com/documentation
Subscribe to the Deep Charts YouTube Channel for more informative AI and Machine Learning Tutorials.