Technical Analysis Excel Template with Trading Strategy Back Testing

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

by Business Spreadsheets
Purpose built models for financial analysisFollow 147

74 reviews9,778 views|7 comments|Bookmark download for free

Description
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 https://www.eloquens.com/tool/AdktZr/finance/financial-markets/portfolio-optimization-for-asset-allocation-and-rebalancing

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