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.6 / 5 (63 votes)- 65%
- 29%
- 3%
- 3%
- -
Write a review
- One StopDocument provides all the appropriate information needed to take a trading position. Great for beginners like me.
- technical analysisanalysis excel
People using this Best Practice also downloaded
Analytical Return on Investment (ROI) Calculator
Calculate ROI in any currency. Split between realized and unrealized showing impact of exchange rate differences.509Discussadd_shopping_cartNet Total Return on Bond Investment Calculator
Calculate Net Total Return on Bond Investment Denominated in Any Currency.243Discussadd_shopping_cartOptions Trading Excel Model (With Fundamentals)
Options Strategy Excel Model With Greeks1,351Discussadd_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)1,7242add_shopping_cart$20.00
by Bassir Ahmadzai
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 ROI17,7723add_shopping_cartfree
by Aswath Damodaran
Option Trading Workbook
Price options and choose the appropriate strategies. Visualise them in a graph.1,7632add_shopping_cartfree
by Peter McFee
Implied Return on Capital (ROC) & Return on Equity (ROE) Terminal Value
Compute the ROC or ROE implied in your terminal value calculation1,471Discussadd_shopping_cartfree
by Aswath Damodaran
Stock Analysis & Valuation (Google Sheets Template)
Google sheet template for Analysing and Valuation of US listed stocks with live data from internet.504Discussadd_shopping_cart$10.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 performance402Discussadd_shopping_cart$5.00
by Bassir Ahmadzai
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,2194add_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.656Discussadd_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,080Discussadd_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,191Discussadd_shopping_cart$19.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 portfolios896Discussadd_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.837Discussadd_shopping_cart$26.00
by Business Spreadsheets
Customer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.1,306Discussadd_shopping_cart$26.00
by Business Spreadsheets
Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.2,4103add_shopping_cartProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis811Discussadd_shopping_cartOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.2,220Discussadd_shopping_cartCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.1,616Discussadd_shopping_cartBond Yield Calculator Excel Model
Automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.367Discussadd_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 =)
