Requirements
1) Monthly Microsoft subscription to get market data
2) Internet connection to get market data from Microsoft
How to use the template?
In the MACD Backtester sheet, please enter these 5 inputs.
1. Symbol
a. Enter your stock symbol. For example, for Tesla in NASDAQ, we enter XNAS:TSLA. Please see this article for detailed instructions on how to enter symbol in Excel.
2. Backtesting period/window
a. Choose the start and end dates of your backtesting period
3. 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.
4. MACD settings
a. The moving averages’ parameters can be customized. For more on MACD technical indicator, please see this article.
5. 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
Overall metrics, whether the trading strategy is better than “buy and hold” approach, latest signal for this symbol
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
Chart Analysis
MACD Chart
Candlestick Chart
