How to Get Stock History Data in Excel 365

In this video, I'm going to show you how to use the STOCKHISTORY function in Microsoft Excel 365 to view the complete history of any stock in your portfolio. We will also create a line chart with a trendline so you can predict its future performance.

Roger from Riverside, California (a Gold Member) asks: I loved your video on tracking my stock portfolio. Thank you. Is there any way that I can pull up a history of a particular stock's performance so I can see how it's trending?

Members

Members will learn how to create drop-down lists (combo boxes) to select a stock from their portfolio sheet, and the number of years they'd like to see the chart plotted for. We'll also add a second 30-day chart for comparison.

• Extended Cut Video - Silver
• Gold Member Download - Gold

Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

• Stock Portfolio: https://599cd.com/StockPortfolio
• Excel Beginner 4 Charting: https://599cd.com/XLB4
• Microsoft StockHistory: https://tinyurl.com/yeca6hta

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

microsoft excel, ms excel, #excel, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, how do i get stock history in excel, STOCKHISTORY function, excel 365, microsoft 365, advanced excel tricks, excel for analysts, stockhistory formula, excel stockhistory function, historical stock data excel, combo box, drop-down lists, historic data, stock history function excel, stock hstory excel, microsoft excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, excel online course, excel tips and tricks