Create a dynamic chart in excel for mac11/11/2023 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 |