Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.1,135 votes
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.
We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey
Blake, Excel Product Team
Allow users to define custom non-VBA functions from built in functions, this can be used to simplify complex functions that are used often e.g.
FastVlookup = (X, Y, Z) => IF(VLOOKUP(X,Y,1,TRUE)=X,VLOOKUP(X,Y,Z,TRUE),NA())6 votes
Good news! We have added support for native lambdas as of today in Insiders: Beta.
Please see this post for more details:
- Don't see your idea?