Technical Analysis Excel Template with Trading Strategy Back Testing
Originally published: 19/04/2018 15:11
Last version published: 21/06/2018 07:18
Publication number: ELQ-69648-2
View all versions & Certificate

Technical Analysis Excel Template with Trading Strategy Back Testing

The technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators

The Excel Technical Analysis model performs technical analysis for simple moving average, rate of change, moving average convergence divergence, relative strength index and Bollinger bands.

Constant parameters for each of the technical analysis indicators can be adjusted to evaluate the back tested total return from the resulting trading strategies on buy and sell signals.

Technical charting displays signals and back tested total returns while signal analysis calculates the value added return from each trading strategy. Technical analysis can be performed on both Long and Short positions for securities, indices and financial instruments.

A more advanced version of the technical analysis is available in the portfolio optimization model at

This includes period constant optimization of technical indicators to maximize back tested returns, last period trading signals and a tool for downloading automatically downloading market stock data.

This Best Practice includes
1 Excel template for Excel 97 or higher

Business Spreadsheets offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Back testing technical indicator trading signals

Market data is already available for testing

Market data needs to be downloaded for analysis

4.5 / 5 (76 votes)

please wait...