Technical Analysis Excel Template with Trading Strategy Back Testing

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.