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.
Al Bush commented
allow excel to download yahoo finance data into spreadsheet
I got tired of waiting for something to be done for desktop Office users, so I glued together something that at least gets me the results for the 5 stocks I own. I used the Power Query feature of Excel 2019 from a little VBA program I wrote. My Query pulls the results (Latest Price, Last Close, Change) from the Nasdaq.com web site. Other sites might work as well, but this is the first one I found that had what I wanted.
Ed Hansberry commented
@ghanshyam, this was fixed last year in Office 365 and I think Excel 2019. I doubt MS will be making any fixes for earlier versions of office.
Ghanshyam Bhat commented
excel 2010 web query needs to support microsoft edge instead of IE11 because Yahoo Finance has stopped supporting IE11. you can no longer use IE11 to get multiple stock prices from Yahoo Finance
Ghanshyam Bhat commented
Microsoft: Please fix this problem of excel web query not working with IE11 in excel 2010
Daniel Mercure commented
Article: Excel Now Lets You Get Real-Time Stock Data From Nasdaq.
Joy Knox commented
When will historical stock prices be available? thank you
I hope also adding Chinese language.
Hi -- is there a way to use the stocks feature under data to pull a stock's price on a specific date? I'd like to be able to pull a table of historical prices by date. Thanks
It seems like Excel 2019 not having the stock price feature is a marketing decision, not a technical one. Many of us have spent our money for Office 2019 for the desktop as we did for earlier versions. Is it right that Microsoft marginalize Office 2019 for the desktop and it's users this way? Is the perpetual Off365 revenue stream the only thing that matters now to Microsoft?
uploading stock prices should be easy - Go Microsoft team
I'm not sure if it has been made apparent here, but I just wanted clarify something :
1 - The failure of the Yahoo API's is NOT Microsofts fault. It is Yahoo who closed the API down
2 - You can still scrape Yahoo manually, or programmatically if you want to program a solution. Python has a solution, and GitHub has lots of python code samples
3 - You can use Excel web service calls with IEX or Alpha Vantage. Both work very well. They are also free.
4 - you can use google sheets "GOOGLEFINANCE" functions. Also free
5 - You can purchase O365
6 - Yes, Excel support for MSN finance would be nice
Please re-connect Yahoo Finance with Excel. PLEASE.
John Demaret commented
Would you please allow excel to download date from MSN so that folks can monitor their portfolios.
Andrew Sinclair commented
I’ve built an Excel Add-In (https://www.excelpricefeed.com) which retrieves financial prices/data via simple formulas. It also includes a search function so you can easily find stock codes. It currently connects to Yahoo Finance, I am working on adding other data providers.
For example to populate a cell with the latest Apple stock price: =EPF.Yahoo.Price(“AAPL”)
I am currently adding historical data as well as other functionality. The Add-in works with all versions of Excel.
Niels Lauge Rasmussen commented
I miss the feature for Windows Excel 2019 What is the prospects ?
Kenny Peh commented
Hi, adding the country code does not work for MY - Malaysia and SG - Singapore
Allow Yahoo Finance to impost spread sheet to Excelll spread sheet. PLEASE
Richard Schwartz commented
I use Yahoo finance. It is very convenient to simply highlight the daily list, copy, and paste into a spreadsheet. Since the change from yesterday's prices is also given, you can subtract that to get yesterdays data, in case you skipped a day.
The big risk is that by advertising this, I may cause Yahoo to reformat their data into something that a spreadsheet cannot handle. But Microsoft excel is a very powerful package that can do most of what you will ever want to do with data. You don't have to know everything about excel in order to get good use out of it; just learn the features and capabilities you need.