How To Backtest ETF Trading Strategies In Excel (FULL Tutorial w/ Best Practices + Examples)

Build your own trading strategy in Excel! Backtesting tutorial using relative strength index (RSI) and volatility risk premium as indicators. Learn backtesting best practices, what to look for + how to use Excel.

Don't forget to subscribe to the channel if you like quants-investing content!

Come see how we trade and claim your 30 day free trial: https://tactiletrade.com/

Intro: (00:00)
Why ETF Rotation: (01:55)
Getting Started - What You'll Need: (02:47)
Excel's IF Statement & Conditional Logic Review: (04:10)
Accuracy Of Backtesting Method - Comparison To Live Trading: (05:36)
Excel Tutorial - Building Your Backtesting Engine: (06:09)
Excel Tutorial - Building Your Dashboard & Results: (17:20)
Excel Tutorial - Building Relative Strength Index: (35:35)
Excel Tutorial - Building 3 Month VRP Indicator: (38:32)
Excel Tutorial - Running The Test: (41:13)
Useful Tips & What To Look For In A Test: (49:40)
IMPORTANT Best Practices You MUST Follow: (50:42)
Join The Tactile Trade Community: (55:08)

Risk-Adjusted Return Playlist:
   • Risk Adjusted Return  

#backtest #backtesting #excel #exceltutorial #excelfinance #finance #investing #quantitative #investment #portfolio #portfoliomanagement #howtotrade #etf #stocks #stockmarket #trading