Technical Analysis with Trading Strategy Back Testing

Technical Analysis with Trading Strategy Back Testing

The technical analysis template by Business Spreadsheets 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.

Author
russp5 (Business Spreadsheets and Excel Templates)
Application
Calc
Category
Business: Finance
License

Business Spreadsheets

Tags
technical, Back, analysis, indicators, testing, total, returns, buy, sell, signals, optimization
Rating
3.96491
Average: 4 (57 votes)
Statistics
Week: 11 - Month: 43 - Year: 1.440 - Timeline

The technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators including configurable period constants to maximize return on trading strategies.