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 commentIoannis Rigopoulos commented
As the author of Deriscope, I would like to recomment the inexpensive Deriscope Excel addin for getting all sorts of live and historical data from several providers and not just Excel.
For example, non-delayed bid and ask forex quotes from TrueFX are also supported.
Non-delayed bid/ask stock quotes from IEX are supported too.
Updates can be refreshed asynchronously (i.e. in the background) every single second!
A comprehensive summary of current Deriscope's capabilities can be found at https://blog.deriscope.com/index.php/en/introduction-deriscope-5-excel-live-feeds