Wednesday, January 6, 2021

Google Sheets - Create a Candlestick Chart

A candlestick chart is a multiple purpose graph that can provide information about stock history (i.e., open, close, high and low prices) in one consolidated view. Google Sheets give you a way to view a stock history via the ticker symbol in a table and then put it into a candlestick chart. In addition, you can set it up to dynamically pull in different stocks as you enter the new ticker symbol in. In this video, I'll cover how to cover how to create a basic candlestick chart and how to create a box plot (or box and whiskers) with the candlestick chart feature. Caveat: It's not a full fledge box plot, more of a pseudo box plot because it doesn't include a median statistic. Lastly I'll cover how to create a dynamic stock history table and the candlestick chart that pulls it's data from that table.

No comments:

Post a Comment