![]() We’ll walk through the process using these steps: Depending on your 365 update channel, you may or may not have access to it yet. Note: At the time of writing, Microsoft is in the process of rolling out the STOCKHISTORY function to Excel 365 subscribers (Windows, Mac, and Web). Then, we would like Excel to automatically retrieve the closing values, like this:įinally, we’d like all of that data to go into a graph, like this:Īnd, whenever we type a new Ticker, Start Date, or End Date, we’d just like everything to update automagically □ ![]() We want to be able to enter a ticker symbol, start date, and end date into some cells, like this: ![]() Objectiveīefore we get too far, let’s first understand our goal here. But, the most current versions of Excel now have another option: the STOCKHISTORY function. Before the STOCKHISTORY function, we could pull data from relevant web pages using Power Query (which I’ve written about before here). Since this is Excel, there are of course several options. Let’s say we want to retrieve historical stock quotes for a specific security into Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |