• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

Originally published: 19/04/2018 15:11
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

by Business Spreadsheets
Purpose built models for financial analysisFollow 92

37 reviews3,276 views|2 comments|Bookmark download for free

roctradingsmatechnical indicatorsmacdrsibollinger bandsback 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.

This Best Practice includes
1 Excel template for Excel 97 or higher

Business Spreadsheets offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• • 
    4.5 / 5 (37 votes)

    • 62%
    • 30%
    • 5%
    • 3%
    • -
  • Rate this Downloadable Tool
    

    Write a review

• Ramnath Viswanathan(last updated: 14/01/2020 04:49)
  
• Michael Xu52(last updated: 05/01/2020 05:02)
  

  technical analysis

  analysis excel
• J T(last updated: 19/12/2019 22:30)
  
• Raju Munikar(last updated: 17/12/2019 11:51)
  
• Arqam Imam(last updated: 17/12/2019 11:04)
  
• Eng Kee Poh(last updated: 06/12/2019 14:01)
  
• Meli(last updated: 13/09/2019 12:10)
  
• Charles.HA. Chen(last updated: 08/09/2019 09:43)
  
• Martin Maga(last updated: 21/08/2019 09:08)
  
• Dioven Rex(last updated: 24/07/2019 08:32)
  
• Leslie Menezes(last updated: 23/07/2019 12:00)
  
• scott Da(last updated: 17/07/2019 18:54)
  
• ANIL SHARMA(last updated: 26/06/2019 18:27)
  
• Mike970(last updated: 15/06/2019 12:08)
  
• Sushant Sharma(last updated: 12/06/2019 17:15)
  
• Nazur Riza Norkaman(last updated: 20/05/2019 03:02)
  
• Irfan Usman(last updated: 07/05/2019 01:52)
  
• Lokesh Goyal(last updated: 31/03/2019 08:13)
  
• Hossam Habib(last updated: 24/03/2019 11:09)
  
• Michael Repper, CPA, CMA(last updated: 24/03/2019 00:59)
  
• Andrewgoga(last updated: 20/03/2019 18:21)
  
• Anup Patil(last updated: 14/03/2019 11:09)
  
• NIRJHAR NANDI MAZUMDER(last updated: 05/03/2019 18:07)
  
• Ameer Bahrain(last updated: 28/02/2019 16:50)
  
• Danny Saunders(last updated: 18/02/2019 04:34)
  
• safwane belaid(last updated: 14/02/2019 16:20)
  
• Mina Banob(last updated: 04/12/2018 14:03)
  
• Илья Емельянов(last updated: 30/11/2018 16:58)
  
• skkakkar(last updated: 31/10/2018 09:19)
  
• Rajendra Prasad(last updated: 27/10/2018 14:24)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  Iwan 2 months ago
  Downloadable Tool Useredit

  can not download..

  arrow_drop_uparrow_drop_downReply reply

  • 

    Russ Penlington 2 months ago
    Eloquens Member

    Click on the blue DOWNLOAD FOR FREE button under the description to download the Excel file.

    arrow_drop_uparrow_drop_downReply reply