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.
Progress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*
We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs
Again, we genuinely appreciate your involvement as we take our first steps in a much greater journey to make Excel better understand your data, and can’t wait to hear about your experiences and suggestions for the future!
James Spotanski (Microsoft Excel)
*Unfortunately there is no way to override the controls to give yourself access – your patience is appreciated :)
I must correct my comment below. I thought I was an Office Insider but I was actually signed up as a Monthly Channel (Targeted) user. I changed this to Insider and downloaded updates, restarted my PC and presto the new Data Types category was on the ribbon under the Data tab. I am looking forward to testing it out
Maybe this will help others anxiously waiting for this new feature.
I too am getting antsy to try this. As an Office Insider I thought I would have it by now. Been almost 3 months since the initial roll out.
Is the Insider option available to users of other languages of Office 365?
Lars Hansen commented
Doug Rickenback commented
I'm an Office 365 insider and still waiting to see/test this functionality. Tick, tock, tick, tock...
Why Yahoo saw fit to destroy an excellent service befits Yahoo. What should I expect from a company that charges for email features offered for free other places. Yahoo still gets revenue from ads. M$ should feast on using this Yahoo error of its ways. M$, make your Money page a go-to place. As is, I never hear anyone using Money as a go-to for financial news. Here is gap you fill, quickly.
What a shame! Disabling such a useful feature.
Who paid whom?
Who was bribed by whom?
As an office insider, I would like to suggest that you add EPS, dividend yield, and dividend per share to the data available.
After Bill Gates left, everything has changed.
I have been using MS Money for a long time, now discontinued.
I love MS Flight Simulator very much, now discontinued.
I depended on MS Mobil phone badly, now discontinued
In short, my prediction of MS Excel is it's going to be discontinued soon.
As you can see, Yahoo Finance is now already discontinued from Excel.
I cannot wait until Excel will be discontinued.
I have started to use Google Sheets, and I like it because it's including Google Finance, and it's FREE.
Sankar Ramasubramanian commented
Please provide a way to Pull Current Stock Prices and Historical Data Into Excel. Thanks!
please make it work with 2007!
It's a great opportunity for MS to move Yahoo finance users to MSN Finance.
Plis Dmitriy commented
Please bring it back to us! thanks
JW Finkler commented
For years I have been teaching students advanced Excel functionality and coupling these functions with real-world applications. Excel 2016 and 365 versions lack a feature of importing stock information into a Workbook or Worksheet. The functionality was part of Excel 2010. I have read articles that Microsoft has eliminated or phased out the use of .iqy file structures. Please restore the ability to import stock price or other data sets (geographic, medical, etc) directly from the Data ribbon. Sincere thanks,
When will the ability to pull live stock quote be released to the general public? Thanks
Please bring this back or give us any other easy was to simply get a Qoute.
it was very useful reintroduce please!
Please bring this functionality back/
Jack B. commented
When will we see a stock quote template for Microsoft Excel?