Pull Current Stock Prices and Historical Data Into Excel
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.
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.
There is a function in google spreadsheets that is fabulous, named =GoogleFinance("CURRENCY:base_currencycurrency_to_convert"). For example if you want to convert from US dolars to Euros, you just have to type: =GoogleFinance("CURRENCY:USDEUR").
I know in Excel we can do the same functionality, but we must relly in third party servers, by fetching data from a table and then using a "lookup" function inside excel to get the correct data.
Well it is really cumbersome, and looking at the amount of functions excel i believe this is strange no the have been implemented yet.
We need simple solutions for everyday tasks, and for a company like ours that deals with a different currencys, it is fundamental
Randy Rotter commented
A writer on Seeking Alpha promotes and enables use of Google Docs to accomplish use of Internet derived stock prices.
Its time to re-enable this consumer-level function in this compete situation or risk losing O365 users.
There are millions who use stock market to buy sell stocks. It is time to add functions in Excel so that user can download data from MSN Finance/CNBC and exploit using all financial function such as Average True Range, Support and Resistance ETC.
I am very surprised to see that hardly any effort has been make by the Microsoft team to break Stock Market Functions to Excel.
In a very basic sense, I would like to bring stock market pricing on Excel when I am connected to the Internet.
I do know to refresh that every second will be too much to ask but at very least end of day prices should be there.
See Google Finance does