By Richard Rost 2 years ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. 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 register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Please feel free to post your questions or comments below. Thanks.
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
Subscribe to Stock History
Get notifications when this page is updated