Create Spreadsheet for Backtesting Trading Strategy in Excel

In this step-by-step tutorial, I’ll show you how to create a backtesting spreadsheet in Excel for a simple trend-following strategy. We’ll combine a moving average with the Average Directional Index (ADX) to improve performance by filtering out false signals during flat markets.

0:00 Intro
0:13 Trading Strategy Description
1:03 Creating Backtesting Spreadsheet - Start From Template
3:09 How to Add Technical Indicator into The Spreadsheet
7:12 How to Add Entry and Exit Conditions of Your Trading Strategy into The Spreadsheet
12:00 Final Adjustments
13:24 Testing The New Spreadsheet
15:15 Where to Get Historical Data for Backtesting

Here’s what you’ll learn in this video:

Setting up a backtesting spreadsheet with templates.
Adding and customizing indicators like ADX and moving averages.
Defining entry and exit conditions for trades.
Splitting historical data into in-sample and out-of-sample periods for proper backtesting and validation.
Running an optimization with thousands of parameter combinations.
Evaluating the strategy’s performance and discussing next steps for improvement.
I’ll also share useful tricks for working with Excel formulas, adding indicators, and editing macros to save time and avoid mistakes. By the end of this video, you’ll have a fully functional backtesting spreadsheet tailored to your trading strategy.

📈 Resources Mentioned in the Video:
Free Excel templates for popular indicators: https://www.traderarchive.com/list-of-excel-templates-for-technical-indicators/
Backtesting Spreadsheet Packs: https://www.traderarchive.com/
Historical data guide: https://youtu.be/0Qy4p34pf48
#Backtesting #TradingStrategy #ExcelForTraders #TrendFollowing #ADXIndicator

Видео Create Spreadsheet for Backtesting Trading Strategy in Excel канала TraderArchive