Posts Tagged ‘candlestick chart’

Tableau Candlestick Chart

October 10th, 2013 No comments

Recently I’ve had reason to pay more attention to the stock of who are the company that introduced me to Tableau. They implemented Tableau Server a few years ago while I was in a very small team of analysts working there at the time, enabling me gain the level of expertise I now have. While analysing the performance of their stock I’ve begun to gain a new appreciation for the candlestick chart and thought about creating this chart in Tableau.

I downloaded the daily stock data for the past 2 years from the Nasdaq website and found a very useful tutorial on the Tableau site about how to create a candlestick chart in Tableau. This saved me many hours of working out how to do this and now I’m going to write it up step by step on this site.

The downloaded dataset is very simple, it contains the date, open price, close price, day high, day low and the volume. I added the ticker to this as well, although unnecessary if only looking at one stock. This can be used as a filter should you load a number of different stocks into the same chart. Tableau should automatically assign the correct data type to the dimensions and measures, they should appear as follows:

Read more…