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


None of the content published on 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
Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
NRG Energy Inc. logo

NRG Energy Inc.

Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
Corteva Inc. logo

Corteva Inc.

Optionable: Yes
Market Cap: 41,692 M
Industry: Agricultural Inputs
52 week range    
Avnet Inc. logo

Avnet Inc.

Optionable: Yes
Market Cap: 4,732 M
Industry: Electronics Distribution
52 week range    
Universal Corporation logo

Universal Corporation

Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
Kronos Worldwide Inc logo

Kronos Worldwide Inc

Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
Boise Cascade L.L.C. logo

Boise Cascade L.L.C.

Optionable: Yes
Market Cap: 3,260 M
Industry: Lumber & Wood Production
52 week range    
Rollins Inc. logo

Rollins Inc.

Optionable: Yes
Market Cap: 17,428 M
Industry: Business Services
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!