Perform Technical Analysis (Template)

Use MarketXLS's ready-to-use template for evaluating stocks based on technical indicators.

What is Technical Analysis?

Technical Analysis is a method for estimating the direction and trend of prices of different stocks by studying historical prices, volumes, charts, and various technical indicators. So, in technical analysis, you are only concerned about past market data, prices, and volumes.

About the Template

MarketXLS provides a ready-to-use template for evaluating the stock based on technical indicators.

Timeliness means that the stocks which the user enters in our template would be ranked according to their expected performance.

Thus in this template, we have ranked stocks based on the SMA & RSI.

Thus, the primary rationale for using the template would be to assess the trend of the stock by using past price data and other indicators.

How to Use the Template

Technical Analysis - Result summary

You have to enter Stock Ticker in cells E7, E9, E11, and E13 of this sheet.

Example Stocks

We have taken the following stocks in this example:

Automatic Analysis

The result and analysis made by the template based on calculations would appear on this sheet itself beside your stock ticker inputs. For detailed analysis, you will have to switch to the 'Calculations' worksheet.

Detailed Calculations

TAT 2

This section of the sheet calculates the score of the stocks based on multiple factors, and the result can be determined based on this score.

Learn More

Additional Resources:

Stock Market Technical Analysis for Beginners
← Previous: Custom BetaNext: Create Charts →