00:00In my previous video, I demonstrated how you can create a candlestick chart like this.
00:04If you need the link to that video, please leave a request on the comment section and I'll send it
00:08to you. For this segment of the video, I'll show you how you can assign a ticker by selecting the
00:11company name, thereby updating the candlestick chart. Let's begin by extracting the company name
00:16and the ticker from the internet. Although any website could be used for this purpose,
00:20but I'm going to use this one for my demonstration. Go to data from web,
00:24paste this URL and click on OK, and you'll be selecting table 4 from this website and click on
00:29load. This will generate a new worksheet for you. Now let's return to the original worksheet and
00:33incorporate the company name as a dropdown in cell C4, utilizing the data from the new worksheet
00:38obtained from the web. Follow the step display on the screen to add the dropdown. Now let's ensure
00:43that the ticker dynamically updates as we change the company name. Select cell C5. We're going to
00:47use the X lookup formula. The first argument would be the company name. The second argument would be
00:51the list of company names from the new worksheet. And the third argument is a list of tickers.
00:56And to close off, assign the chart title with the value from cell C4.
Comments