Basics

Technical Analysis: Chart Patterns (Using Excel)

Written by Vanshika Kothari
Mon Jun 14 2021
Technical Analysis Chart
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Technical Analysis Chart
 

Chart Patterns have been widely used by technical analysts to examine current movements and forecast future market movements. Technical analysts use chart patterns to plot the price movements over specific time frames. A complete picture of the stock’s price history can be drawn by plotting the chart. It can also depict the history of the volume of trading in a stock.

The price patterns that are formed on the chart prove to be valuable indicators to anticipate the future direction of a security’s price. There are different types of charts found in technical analysis, but the most commonly used are the candlestick chart patterns.

What is a Candlestick?

DOXc8WRvigeXtm2yDiieb_MgmIfZHqp89tUq8cn9398CYP0bq5vyw70yk3WfzK4_QWft6eGWpMnpBKjoLKyvBZww0jysElDPoFYu-o2sS9Ru5L” alt=””/>

Source: http://whatta.org/?p=461 

A candlestick is a convenient means to display the open, high, low, and closing prices of a stock in a specific period of time that is on a 15-minute chart, one candlestick represents 15 minutes. On a 1-day chart, one candlestick represents 1 day. Candlestick chart most widely used in technical analysis. The body of the candle is the hollow or filled portion. The highs and lows are depicted by the long thin lines called the shadow. 

When the stock closes higher than its opening price, a hollow candlestick is drawn where the opening price is represented with the bottom of the body, and the top of the body represents the closing price. A filled or black candlestick is drawn when the stock closes lower than its opening price, where the top of the body represents the opening price, and the bottom of the body represents the closing price.

Candlestick Patterns

Candlestick charts can often help to read the emotions that dictate the trading. These patterns help traders to determine possible price movement based on past patterns. There are plenty of patterns and chart formations in technical analysis. However, these can be distinguished into four major categories: bullish or bearish and continuation or reversal. Let’s look at some of them in detail.

Bullish Patterns

  1. Bullish engulfing
Bullish Engulfing

Source: https://in.pinterest.com/pin/724727765020631772/

It is formed when a small black candlestick is followed by a large white candlestick that completely eclipses or engulfs the previous candlestick’s body. The psychology behind this trend is that after a decline, the price opens at a lower level, and the buyers have taken over, altering the emotions of the previous trend.

  1. Bullish Harami
Bullish Harami

Source: https://www.moneycontrol.com/technicals/news/candlestick-patterns/bullish-harami-bullish-reversal-pattern_580514.html

It is a chart pattern in which a large candlestick is followed by a smaller candlestick whose body is located within the vertical range of the larger body. It signifies a small increase in price that has been in effect after a strong down-trend and a selling day. It opens at a price higher than the previous close. 

  1. Morning Star
Morning Star

Source: https://hitandruncandlesticks.com/morning-star-candlestick-pattern/

A bullish pattern is formed by a tall black body candle, a second candle with a petite body that gaps below the first body to form a star, and a third white candle that closes well into the first session’s black body. Its name indicates that it foresees higher prices. The Morning Star is a bottom reversal signal. Like the planet Mercury, the morning star signifies brighter things – that is, sunrise is about to occur, or the prices will go higher. 

Bearish Patterns

  1. Bearish engulfing
Bearish Engulfing

Source: https://hitandruncandlesticks.com/bearish-engulfing-pattern/ 

A bearish engulfing pattern signals lower prices to come. It consists of a white candlestick followed by a large black candlestick that eclipses or engulfs the smaller black candle.

  1. Bearish Harami
LUBx7uIGXfKw1Z3j-53ol5yfliESr4v1lHVimzzDnCEIK6″ alt=”Bearish Harami”/>

Source: https://www.moneycontrol.com/technicals/news/candlestick-patterns/bearish-harami-bearish-reversal-pattern_580515.html 

It is a chart pattern in which a large candlestick is followed by a smaller candlestick whose body is located within the vertical range of the larger body. It signifies a small decrease in price that has been in effect after a strong up-trend and a buying day. It opens at a price lower than the previous close. 

  1. Evening Star
Evening Star

Source: https://hitandruncandlesticks.com/evening-star-candlestick-pattern/ 

This pattern occurs at the top of an uptrend. It is a bearish pattern formed usually by three candles: a tall white body candle, a second white candle with a petite body that gaps above the first body to form a “star,” and a third black candle that closes well into the first session’s white body.

Continuation Patterns

Continuation patterns are indication traders signal a price trend that is likely to remain in play. These patterns indicate that the trend will be most likely to continue once a pattern has completed and they occur in the middle of a trend and signal that the trend is going to continue.

  1. Triangles
Triangle Pattern

Source: https://www.shutterstock.com/search/ascending+triangle

Triangles can be depicted by drawing trend lines along a converging price range. The upper and lower trendlines are formed by connecting the highs and lows, respectively. It usually occurs mid-trend and is a consolidation pattern. A breakout in the direction of the previous trend can be seen as a signal to enter a trade.

  1. Rectangles
Rectangle Screen

It is formed as a trading range during a pause in the trend. When the price reaches the same support and resistance lines multiple times, a rectangle is formed. The two parallel lines that make up the top and bottom of a rectangle are connected to the highs and lows. 

Reversal Pattern

  1. Head and Shoulders 
Head and Shoulders Pattern

Source:https://en.wikipedia.org/wiki/File:Head_and_Shoulders_Top.jpg 

Head and shoulders is known to be one of the most reliable reversal patterns. Three successive rallies and reactions are portrayed in the head and shoulders pattern, with the second one making the highest/lowest point. It can be a bearish or bullish trend reversal and is one of the most common reversal formations. A head and shoulders bottom is an inverse head and shoulders that helps to predict downtrends.

  1. Double tops and double bottom
Double Tops and Double Bottoms

These are two of the most familiar reversal patterns in technical analysis. The double top is indicated by the letter “M” On the contrary, the double bottom resembles a “W” formation; in reverse of the double top.

A double top is a reversal pattern which occurs following an extended uptrend. This name is given to the pair of peaks which is formed when price is unable to reach a new high. It is desirable to sell when the price breaks below the reaction low that is formed between the two peaks.

Double bottom is used to describe a drop in the value of a stock (or index), a bounce back up, and then another drop to the similar level as the previous low and finally another rebound. A double bottom is a reversal pattern which occurs following an extended downtrend. The buy signal is when price breaks above the reaction high which is formed between the two lows.

Identifying Patterns for Stocks (Using MarketXLS)

Technical Charts

MarketXLS is a handy tool to calculate more than 120 Technical Indicators with a few clicks in Excel. You can scan your data for Candlestick Patterns, Perform Technical Analysis, and run groups of indicators on your data in Excel.

MarketXLS allows you to customize everything, including time period, Moving Average types, etc., and has the option to run with default inputs without prompting.

You can discover patterns in your data and analyze its impacts. 

Step by Step Using MarketXLS To Identify Candlestick Patterns

  1. To identify candlestick patterns we first need to get the data of the stock. Here we just need to add the ticker in any cell and select custom dates and get the historical data.

  1. You will be prompted to select the dates for the period you want the data.
Candlestick Patterns
  1. Once you have the data generated you can generate your candlestick charts by selecting the charts option> Candlestick charts
Candlestick charts using Excel
  1. Now enter the data as per the requirement i.e Date values, Open High Low Close in the same sequence and the Volume data.
Generating Charts using Excel
  1. The candlestick chart is generated. Charts can be maximized to full screen and they automatically adjust dates etc depending on size of the area.
Candlestick chart patterns

  1. Now, let’s try adding a chart pattern on the candlestick chart. So we first select any chart pattern we want to look for, here we’ve selected the engulfing pattern. As we did for generating the candlestick it will again prompt us to add the open high low and close. 
Engulfing Pattern Using Excrl
  1. A pattern series will be generated. This pattern series only has binary data. That means if the pattern value is 0 it means there is no pattern and if it is 100 or -100 it means there is a pattern.
  2. To view the engulfing pattern, you need to right click on the chart area and select add series. Select the entire range of the binary pattern series. Once done, you will be able to see the pattern in your candlestick chart.

You can also right click on the chart to add any number series and annotate patterns on the candlestick charts. MarketXLS will prompt you to select series with annotations and patterns.

To know more about creating candlestick charts in excel check out this video: MarketXLS Charts – Candlestick Charts – Stock Research Tool

Disclaimer

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.

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.

108.90
 
USD
 
0.11
 
(0.10%)
91
Rank
Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
72.35   
   119.47
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

63.76
 
USD
 
2.46
 
(4.01%)
80
Rank
Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
33.71   
   91.23
Kronos Worldwide Inc logo

Kronos Worldwide Inc

18.02
 
USD
 
1.54
 
(9.34%)
80
Rank
Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
12.06   
   18.31
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

179.61
 
USD
 
5.39
 
(3.09%)
80
Rank
Optionable: Yes
Market Cap: 3,101 M
Industry: Auto & Truck Dealerships
52 week range    
143.00   
   212.23
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

24.62
 
USD
 
-0.68
 
(-2.69%)
79
Rank
Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
15.86   
   26.90
NRG Energy Inc. logo

NRG Energy Inc.

46.21
 
USD
 
0.45
 
(0.98%)
79
Rank
Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
31.94   
   46.71
First BanCorp. logo

First BanCorp.

13.64
 
USD
 
-0.16
 
(-1.16%)
79
Rank
Optionable: Yes
Market Cap: 2,795 M
Industry: Banks - Regional - US
52 week range    
10.88   
   16.62
TriCo Bancshares logo

TriCo Bancshares

42.29
 
USD
 
-0.42
 
(-0.98%)
78
Rank
Optionable: Yes
Market Cap: 1,468 M
Industry: Banks - Regional - US
52 week range    
37.41   
   48.96
ManTech International Corporation logo

ManTech International Corporation

94.25
 
USD
 
-0.18
 
(-0.19%)
78
Rank
Optionable: Yes
Market Cap: 3,860 M
Industry: Software - Application
52 week range    
66.91   
   94.73
Universal Corporation logo

Universal Corporation

60.06
 
USD
 
-2.61
 
(-4.16%)
77
Rank
Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
46.24   
   63.46

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 support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!