Requirements
1) Indzara's MACD Strategy Backtester Google Sheets Template
2) Internet connection to get market data from Google services
How to use the template?
In the MACD Backtester sheet, please enter these 6 inputs.
1. Exchange Code
a. Enter your Exchange Code. For example, NASDAQ.
2. Symbol
a. Enter your Stock symbol , we enter AAPL.
3. Backtesting period/window
a. Choose the start and end dates of your backtesting period.
4. Investment Amount/Capital
a. Enter an amount as trading capital that will be used by the template to invest in trading during the backtesting period.
5. MACD settings
a. The moving averages’ parameters can be customized. For more on MACD technical indicator, please see this article.
6. Trading Strategy Actions
a. For the four signal events, choose your strategy (entry/exit). Please leave it blank if you do not want to take any trading action.
Overview of the Template Output
Report Card
The report card shows the overall summary and whether the trading strategy is better than “buy and hold” approach.
You can also see the latest signal (Bullish Signal Line Crossover, Bearish Signal Line Crossover, Bullish Zero Line Crossover, Bearish Zero Line Crossover) if any on the specific stock. This will help decide if you want to take any trading action in the market right now.
Trades – Trends
Timeline view of when the trades are made as part of the strategy
Equity change over time
Cumulative Profit/Loss
Summary of Metrics
List of Trades
You can see the complete list of trades with all the details.
Chart Analysis
MACD Chart
You can use the checkboxes on the top of the chart to enable/disable specific lines on the chart.
Candlestick Chart
The standard candlestick chart with volume bars are displayed as well.