00:00I'm sure you have all seen a candlestick chart, but have you tried making one yourself in Excel?
00:05Allow me to demonstrate how you can craft a dynamic and interactive candlestick chart that
00:09can retrieve live data from the web. Let's begin by extracting the live, open, high, low, and close
00:14data from the stock history function. The first argument would be the ticker. The second and the
00:19third argument would be the start and the end date. The fourth argument is the data resolution,
00:23which will set it to daily. And the fifth argument will opt not to show the header.
00:26From the sixth argument onwards, stock history function allows us to specify the field name
00:31to pull. For our candlestick chart, we'll pull date, open, high, low, and close. Then press enter.
00:37Now to create the candlestick chart. Place the cursor on the data set, press ctrl a twice,
00:42and then press alternate f1, chart design, change chart type, then select stock. Then after that,
00:47select open high, low, close chart, and click on ok and reposition your chart. In an upcoming
00:52segment of this video, I'll illustrate how you can automatically assign tickers when selecting
00:56company names using the drop-down list like this. Stay tuned.
Comments