Originally published: 19/04/2018 15:11
Last version published: 21/06/2018 07:18
Publication number: ELQ-69648-2
View all versions & Certificate
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
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
Reviews
4.5 / 5 (68 votes)- 65%
- 26%
- 4%
- 3%
- 1%
Write a review
- One StopDocument provides all the appropriate information needed to take a trading position. Great for beginners like me.
People using this Best Practice also downloaded
TRADING SYSTEM (enhanced fully editable version)
Providing trading signals using mix of technical indicators and historical price trends. FULLY TESTED OVER 15YR HISTORY.205Discussadd_shopping_cart$40.00
by Domenico Cristarella
Options Trading Excel Model (With Fundamentals)
Options Strategy Excel Model With Greeks1,758Discussadd_shopping_cart$49.00
by Jatin Goel
Fully Automated Stock Portfolio and Valuation Template
Fully Automated G. Sheet template for Portfolio and Stock Valuation with live data from internet (for US listed stocks)2,8292add_shopping_cart$20.00
by Bassir Ahmadzai
Crypto Viewer and Trendsignals (FREE VERSION)
With this program you keep track of your CryptoCoins and keep informed of every trend change. You can choose from over 756Discussadd_shopping_cartfree
by Markus Polzer
Net Total Return on Bond Investment Calculator
Calculate Net Total Return on Bond Investment Denominated in Any Currency.427Discussadd_shopping_cartStock Analysis & Valuation (Google Sheets Template)
Google sheet template for Analysing and Valuation of US listed stocks with live data from internet.2,8881add_shopping_cart$20.00
by Bassir Ahmadzai
Trade Tracker & Portfolio (Google Sheets Template)
This template will help you keep track of your trades and help visualize your portfolio performance1,8031add_shopping_cart$10.00
by Bassir Ahmadzai
Currency Backtesting in Excel (FREE VERSION)
Forex- Backtesting for more than 60 currency pairs for 20 years197Discussadd_shopping_cartfree
by Markus Polzer
Option Trading Workbook
Price options and choose the appropriate strategies. Visualise them in a graph.2,0662add_shopping_cartfree
by Peter McFee
Capital Budgeting Analysis Excel Model
This Excel Model allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI18,6013add_shopping_cartfree
by Aswath Damodaran
More Best Practices from Business Spreadsheets
Portfolio Optimization for Asset Allocation and Rebalancing
The Excel portfolio optimization model combines asset allocation and technical analysis to maximize investment returns.2,6204add_shopping_cart$26.00
by Business Spreadsheets
Project Management with Automated Schedule Optimization
The Excel project management solution facilitates the creation of project plans and automated monitoring of progress.747Discussadd_shopping_cart$26.00
by Business Spreadsheets
Business Valuation Excel Model with Pro-Forma Financial Statements
The business valuation model provides an accurate and robust financial reporting structure to value proposed investments1,278Discussadd_shopping_cart$26.00
by Business Spreadsheets
Multivariate Regression Analysis Excel Model with Forecasting
The Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.1,497Discussadd_shopping_cart$19.00
by Business Spreadsheets
Customer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.1,707Discussadd_shopping_cart$26.00
by Business Spreadsheets
Financial Portfolio Tracking and Valuation Excel Model Template
Excel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios1,018Discussadd_shopping_cart$22.00
by Business Spreadsheets
Real Options Valuation and Analysis Excel Model
The Excel real options valuation and analysis provides quantification of embedded value in investment strategies.995Discussadd_shopping_cart$26.00
by Business Spreadsheets
Seasonality Forecasting with Time Series Decomposition
Data forecasting with analysis of periodic variation in predicted data projections.248Discussadd_shopping_cartBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.2,5943add_shopping_cartProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis877Discussadd_shopping_cartOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.2,779Discussadd_shopping_cartCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.1,766Discussadd_shopping_cart
Discussion feed for Technical Analysis Excel Template With Trading Strategy Back Testing
The user community and author are here to help. Go ahead!
- Help me to correctly interpret the final results as I'm not sure if the model is telling me to go long or short.
- The test results at the top show the action under each of the indicators: Buy, Sell or Hold. These can be mixed but the value add of each indicator can help to indicate whether to be long or short overall. Obviously if all indicators are in alignment then this is easier.
- can not download..
- Click on the blue DOWNLOAD FOR FREE button under the description to download the Excel file.
- Do you have any tutorial/demo on how to best use this excel template? Thank you. Great work!
- It is part of a larger template and the user guide for the technical analysis section can be found at https://www.business-spreadsheets.com/help.asp?t=26
- The larger Template can also be found here: https://www.eloquens.com/tool/AdktZr/finance/financial-markets/portfolio-optimization-for-asset-allocation-and-rebalancing =)
