Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
STOCKHISTORY
Let’s say we want to retrieve historical stock quotes for a specific security into Excel. Since this is Excel, there are of course several options. Before the STOCKHISTORY function, we could pull data from relevant web pages using Power Query (which I’ve written about before here). But, the most current versions of Excel now have…
Read More
Microsoft just announced a new Excel function called STOCKHISTORY. This function provides a way to retrieve historical stock quotes directly into Excel. As it is being rolled out over time, I haven’t had a chance to use it yet. But as soon as my copy of Excel receives the function, I’ll write a post about…
Read More