Stock Data Analysis is no easy feat!  Once you have a lot of historical stock data it’s hard to visualize the trend using technical analysis.

Thankfully Excel has a lot of stock charts to help you with that, and one of them is the Candlestick Chart!

A Candlestick Chart has a vertical line that indicates the range of low to high prices and a thicker column for the opening and closing prices:

Candlestick Chart Using Excel

 

Below is the data source that we are going to use in Excel:

Candlestick Chart

You need a Date column which should be the first column.

Then this should be followed by a Open, High, Low, and Close column. This is the exact order that needs to be followed in order to create the Candlestick Chart.

In this example I show you how easy it is to insert this using Excel.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Highlight your data of stock prices:

Candlestick Chart

 

STEP 2: Go to Insert > Stock Charts > Open-High-Low-Close

Candlestick Chart

 

STEP 3: Right click on your Legend and choose Delete as we do not need this.

Candlestick Chart

 

STEP 4: Go to Chart Tools > Design and select the preferred design to make your chart more presentable!

Candlestick Chart

 

And there you have it! Your own Candlestick Chart!

Candlestick Chart

Create a Candlestick Chart

HELPFUL RESOURCE:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin