1,110 votes401 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8
However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.
If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.
An error occurred while saving the commentAndrew MacLean commented
I'd like to announce the availability of an inexpensive add-in for Excel which is designed to make it super simple to import historical prices, dividends and splits from the Yahoo! JSON feeds. No VBA, automatic update, just fill out a simple userform and hey presto, refreshable data anywhere in your workbook with extremely flexible formatting!
Hope you like it!