|
|||||
|
Stock History By Richard Rost ![]() ![]() 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? MembersMembers 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!
|
| |||