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 (42 votes)- 60%
- 33%
- 5%
- 2%
- -
Write a review
- technical analysisanalysis excel
People using this Best Practice also downloaded
Options Trading Excel Model (With Fundamentals)
A spread focus Excel Model (Price Spread and Calendar Spread) for Options.372Discussadd_shopping_cart$40.00by Jatin Goel
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 ROI15,6553add_shopping_cartfreeby Aswath Damodaran
Option Trading Workbook
Price options and choose the appropriate strategies. Visualise them in a graph.9982add_shopping_cartfreeby Peter McFee
Implied Return on Capital (ROC) & Return on Equity (ROE) Terminal Value
Compute the ROC or ROE implied in your terminal value calculation1,181Discussadd_shopping_cartfreeVWAP Template Calculator Excel Model (Volume Weighted Average Price)
Simple, ready-to-use VWAP template calculator.1,943Discussadd_shopping_cart$9.00by Alexander Jarvis
How to Use Trading Multiples for Valuing a Company.
A step-by-step guide on how to use trading multiples for valuing a company.80Discussadd_shopping_cartTrade Journal Excel Template
This is a fantastic Trade Journal Template providing help for traders tracking the development of transactions.486Discussadd_shopping_cart$150.00by Someka
More Best Practices from Business Spreadsheets
Project Management with Automated Schedule Optimization
The Excel project management solution facilitates the creation of project plans and automated monitoring of progress.463Discussadd_shopping_cart$26.00by 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 investments688Discussadd_shopping_cart$26.00Multivariate Regression Analysis Excel Model with Forecasting
The Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.566Discussadd_shopping_cart$19.00Portfolio Optimization for Asset Allocation and Rebalancing
The Excel portfolio optimization model combines asset allocation and technical analysis to maximize investment returns.1,113Discussadd_shopping_cart$26.00Customer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.680Discussadd_shopping_cart$26.00Financial Portfolio Tracking and Valuation Excel Model Template
Excel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios624Discussadd_shopping_cart$22.00Real Options Valuation and Analysis Excel Model
The Excel real options valuation and analysis provides quantification of embedded value in investment strategies.446Discussadd_shopping_cart$26.00Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.2,0003add_shopping_cartProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis621Discussadd_shopping_cartOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.1,169Discussadd_shopping_cartCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.1,251Discussadd_shopping_cartBond Yield Calculator Excel Model
Automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.266Discussadd_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!
- 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 =)
