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 commentFloyd Rentz commented
Good start - can you tell me the proper syntax for the ticker of preferred stock. Most brokers use (for NEE series J preferred stock) NEE-J or NEEprJ or something similar but I can't find one that works in Stock Data Types