This is part six of our Microsoft Excel Tutorial Series, if you haven’t read the previous articles you can find them here:
An Introduction to Microsoft Excel 2007
The basic’s data entry and navigation
Importing Market Data from Yahoo Finance
The basic’s of charting market data the line chart
The basics of charting market data the bar chart
Today we will be looking at setting up candlestick charts in Excel. This tutorial will go through producing the two built in Excel versions of candlestick charts. Normally a candlestick chart will display open, high, low and close and the range for a given period. They are a great tool to quickly gauge price action.
Candlestick Chart
I am going to assume that you are familiar with candlestick charts, however if you are new to these type of charts I have included some useful resources on the topic of candlestick charting below.
Introduction to Candlesticks
The Art of Candlestick Charting
Books
Popularity: 44% [?]
