You can use STOCKH to get the closing price for a stock, but it is tricky to get around weekends and holidays when trying to build a table and then a chart.
Note: This is Club MacMost exclusive content. To view this video click the thumbnail below to go to the post as Patreon.com. Once there you will be able to view the video as long as you are logged into your Patreon account and a current supporter of MacMost at the "Club MacMost" or higher level.