Description
Ready to take your SMA (Simple Moving Average) trading strategy to the next level? Our powerful Excel template lets you backtest your strategy effortlessly! No coding, no complex software, just instant results right within Microsoft Excel. Start making data-driven decisions with confidence!
What is backtesting?
Backtesting is testing your trading strategy using historical data.
Using real historical data, you can simulate the trading results as if you had used the specific trading strategy with the specific stock.
You can not only identify if the strategy is a profitable one or not. You can also fine-tune your trading parameters and try to find a profitable strategy.
Though the past results are not guaranteed to happen in the future, your trading decisions will be based on past results and not just guesswork.
Let’s take an example.
-
- Stock: XNSE:JPPOWER
- Testing period: From Jan 1, 2024 to Dec 31, 2024
- Strategy: Whenever a day closes with Buy Signal, enter a long trade the next day and when a day closes with Sell Signal, exit a long trade the next day.
- SMA Length: 9
- Capital invested: ₹ 10,000
If I had used the above simple trading strategy using SMA(Simple Moving Average) indicator to drive my trading decisions, I would have made ₹ 2,775 profit. I would have closed 18 trades, with a win rate of 50% and Profit factor of 1.77
What if we bought and held the shares instead of trading?
If we had not done these 18 trades and we had just bought JPPOWER shares worth ₹ 10,000 we would have made only ₹ 29 profit. This would not have been as profitable as the trading strategy. In this specific example, trading would have been a better strategy.
This is just to illustrate the tool’s capability. This does not mean that trading is always the better strategy. Other examples might prove that buying and holding may be the better strategy. For example, if we had tried the same strategy with IDEA stock, the results would have been different.
Why backtesting?
- This is a risk-free method to test your strategies on real historical data as you are not using real money to trade.
- You can try many different strategies to find one that works for you.
- You can be more confident with your trading decisions in future.
Disclaimer
We do not offer financial or trading advice. Our template is another tool to help you make smarter data-driven trading decisions. Our template automates the calculations based on your own strategy inputs. Indzara.com is not responsible for any trading decisions taken.
Easy to Use
Enter 5 Simple inputs (Stock symbol, Test window, SMA settings, Trading strategy, and Capital Investment) and view the backtesting results instantly.
Customizable/Flexible
- Each trader has a different approach when it comes to trading strategy and the template allows you to customize the settings for the SMA(Simple Moving Average) indicator.
- You can also choose what trading action you would like to take based on the signal events from the SMA(Simple Moving Average) indicator. For more on the SMA indicator, please see this article
- The template supports Long and Short trading
Accuracy
For traders, having accurate data is very crucial and we have verified our calculations with the results from TradingView.com website.
Designed for Insights
Charts and calculations are designed and presented in a way to aid quick and confident decision-making.
Metrics included in the template
1.Number of trades (Closed/Open)
2.Win Rate %
3.Avg. Trade Profit/Loss
4.Avg Win/Avg Loss Ratio
5.Net Profit
6.Profit Factor
7.Max Run-up
8.Max Drawdown
9.Avg # Candles per trade
10.Margin Calls
Timeline View
View the trades on a timeline chart showing exactly when and what type of trades are made based on strategy.
Equity Trend Chart
View the trend of your equity over time during the backtesting period.
Cumulative Profit/Loss Chart
View the trend of profit/loss over the backtesting period.
List of Trades
In addition to the summary metrics and charts, you can view the specific trades in detail.
SMA Chart
A customizable SMA(Simple Moving Average) chart that shows the SMA line, Close Price line and Buy Sell Signals.
Candlestick Chart
A standard candlestick chart that shows the candles, along with the volume bars.
Requirements
To use this solution to backtest SMA trading strategies, you need the following three.
1. Microsoft Subscription
The market data is taken from Microsoft’s service which requires an Office subscription. If you already have an existing Microsoft Office subscription, that would work.
2. Excel Template
You can purchase our template from this page here for an affordable one-time fee. Our template uses the Market data and automates all the calculations involved in backtesting.
3. Internet connection
You need to connect to the internet to get market data.
Application / Limitation
- The template can be used for Swing Trading using daily market prices. The template cannot be used for intra-day trading. Microsoft does not provide data at minute or hourly intervals. If you would like a solution for this, we can custom develop a solution if you have source for minute level market data. Please contact us.
- Since the template uses market data from Microsoft, only the stocks, indices and currencies that are available in the Microsoft service can be analyzed. Please see this article for exchanges whose data are available from Microsoft. Not all symbols are available from Microsoft.
Reviews
There are no reviews yet