Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
StocksTechnical analysisTemplates

Technical Analysis Timeliness – Meaning And Usage In Marketxls

Written by Ansh Thakkar (Individual Contributor)
Sat May 01 2021
Technical Analysis Timeliness
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Technical Analysis Timeliness

What is Technical Analysis?

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. You are not concerned with the fundamentals of the company. You are not concerned with the CEO of a particular company, the shareholding pattern of the company, how’s the industry of that particular company doing, and other fundamentals.
The supply and demand affect the prices and volumes of stocks. Hence, the most crucial factors of technical analysis are supply and demand, which in turn affect the prices and volumes of stocks.

When Should You Use It?

Those who are short-term traders and trade stocks on an intra-day basis use technical analysis more frequently. Day traders and swing traders make use of technical analysis of stock the most often!
Technical Analysis helps in deciding when to enter the market, and fundamental analysis helps in deciding how long an investor should hold a position.
But I would like to say that both technical and fundamental analysis are equally important if you want to gain success in the stock market.
MarketXLS provides a ready-to-use template for keeping track of the technical indicators of a stock and running technical analysis timeliness.
Let us understand a few terminologies (technical indicators) used in the template before diving straight into the template.

  • Simple Moving Average(SMA)

This is one of the most significant indicators of technical analysis. It refers to the average closing price of a stock over a particular period of time. The rationale to use this as a technical indicator is that it indicates the trend/ direction of the price of a stock.
Since it is an average, it is evident that it is based on previous prices. The SMA line is much smoother than the other averages as it allocates equal weightage on all data points.
Simple Moving Average Formula
SMA = Simple Moving Average
P = Price
n = Number of periods

The most prominent periods for SMA are:
10-days SMA
20-days SMA
50-days SMA
200-days SMA
We have used the last three in our ‘Technical Analysis Timeliness’ template.

  • Relative Strength Index(RSI)

The RSI is a momentum indicator used to find the magnitude of price change to ascertain the market’s volatility.
It indicates whether a stock is overbought or oversold. If the stock is overbought, then the traders sell the stock, and its price falls, and if the stock is oversold, then the traders buy the stock, and its price rises.
There are two RSI reference levels: 30 & 70
If the RSI surpasses the 30 reference level, it is a bullish trend. If the RSI crosses the 70 reference level, it is a bearish trend.
(The perspective of many investors, related to RSI, may be different.)
RSI.png”>RSI-300×85.png” alt=”Relative Strength Indicator Formula” width=”314″ height=”89″ />
The formulas of both indicators are just for your knowledge and reference. You don’t have to calculate them while using the template.
The template automatically does all the calculations.

Technical Analysis Timeliness in MarketXLS

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.

Technical Analysis Timeliness

You have to enter Stock Tickr in cell E7, E9, E11, and E13 of this sheet.
We have taken the following stocks in this example:
Amazon (AMZN/”>NYSE: AMZN)
Walmart (WMT/”>NYSE: WMT)
Alibaba Group (NYSE: BABA)
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.

Technical Analysis Timeliness

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.

What are Range Tables?

The current stock price is evaluated with the moving averages in different time frames, and based on that, we have given a rank to them. The closer they are to moving averages, the better rank they will have.
Similarly, we have given the rank on the Relative Strength Index. You can change the range as you desire by changing the yellow highlighted values.

On What Basis is the Timeliness Score Calculated?

However, the first table in the sheet shows the actual score given to the stocks. This score is based on the 20 Days SMA, 50 Days SMA, 200 Days SMA and RSI.
In this example, the total of the stocks are as follows:
AMZN = 37
WMT = 33
JD = 40
BABA = 37
How to interpret the results?
1) If Score > 30, the stock looks attractive for longs
2) If Score < 30, the stock doesn’t look attractive for longs
Hence, according to the template analysis, all the four stocks look attractive for longs.
(These templates should not be considered as an advertisement or advice, professional or otherwise. You are requested to consider all the risk factors, including your financial condition, suitability to risk-return profile, and other similar conditions. These templates do not account for any professional advice but are merely some guidelines to explain the concept.)

The Bottom Line

Thus, the template does all the calculations and returns the score of the stocks, which is based on a couple of significant technical indicators. It makes your work easier by providing all the data related to stocks and technical indicators. You have to enter the stocks of your choice in the ‘Index’ worksheet.
However, we have to remember one thing; past performance is not a guide for future performance.
For more such interesting content, visit https://marketxls.com/blog/.


None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.
The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made. All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.



Image Source


Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

Optionable: Yes
Market Cap: 451 M
Industry: Capital Markets
52 week range    
Midland States Bancorp Inc. logo

Midland States Bancorp Inc.

Optionable: No
Market Cap: 589 M
Industry: Banks - Regional - US
52 week range    
Kroger Company (The) logo

Kroger Company (The)

Optionable: Yes
Market Cap: 35,325 M
Industry: Grocery Stores
52 week range    
Ingles Markets Incorporated Class A Common Stock logo

Ingles Markets Incorporated Class A Common Stock

Optionable: Yes
Market Cap: 1,910 M
Industry: Grocery Stores
52 week range    
Amdocs Limited logo

Amdocs Limited

Optionable: Yes
Market Cap: 10,525 M
Industry: Software - Infrastructure
52 week range    
Tecnoglass Inc. logo

Tecnoglass Inc.

Optionable: Yes
Market Cap: 1,349 M
Industry: Building Materials
52 week range    
Interpublic Group of Companies Inc. (The) logo

Interpublic Group of Companies Inc. (The)

Optionable: Yes
Market Cap: 13,330 M
Industry: Advertising Agencies
52 week range    
Guess? Inc. logo

Guess? Inc.

Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

Optionable: Yes
Market Cap: 168,030 M
Industry: Drug Manufacturers - Major
52 week range    
Best Buy Co. Inc. logo

Best Buy Co. Inc.

Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    

More Features