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.
Thank you all for your enthusiasm – I’m excited to say that we’re working on it!
I’m even more excited to say that you’ll be able to try it out soon, as a part of our work to make Excel better understand the data in your spreadsheets. Keep an eye on this page for updates, including instructions on how to try the feature before everyone else – we’ll be using your feedback to help shape our designs!
-James Spotanski (Microsoft Excel)
Roger Dailey commented
This was one great tool. Sad to see it gone. Can only hope it’s brought back or at least a close version of first.
Bring Back Stock Prices
Here are a couple of solutions that worked for me. Still, it would be nice to have it built into Excel.
Carter Coe commented
How is this feature gone? Please resolve.
Please bring back great feature.
Please advise once you have a good solution.
I bought a book on VBA for Excel 2013 specifically to download stock prices (both Canadian and US). It is very disappointing that it cannot be done at this time. Please advise when you will have a solution.
Kirk Lindstrom commented
So when will this "feature" that is something I PAID FOR be working again?
I have several workarounds but none works as well as what we had in the past getting the information from MSN.... how the heck can MSFT cut this valuable feature of Excel off...
This is a big reason to not trust Microsoft... so I hope you restore this trust soon.
I really need this feature!
Barbara Ann Hill commented
Wonderfull!! The sooner the better because I'm getting used to google sheets and liking it....
Claire F commented
Does MS need a financial incentive for this? I would pay $5/ mo for this capability.
Murray Cooper commented
I am currently importing historic prices from Yahoo! using their new (Pelosi) "crumbs" and cookie approach with a Excel vba driven downloader.
My (beta development) model includes Technical indicators, OHLC Candles, optimizers and back-testing.
The key to exchanges is using the exchange index appended to the stock code e.g. Telstra in Australia is TLS.AX; Canada is TS, India is IN, Singapore is SG etc.
So happy to provide the importer part of this model once I have stripped away the other code, if there is sufficient interest.
Also Barchart.com offers free data (10 stock limit per day) and a "pay for" service.
Foat.com.au also offered a free service but it has recently stopped. Historic data up to 12/17 is available - so you only need latest 2 months from another provider.
Anyway, I guess you can reach me here -
Rob Kick commented
When will Excel allow us to import stock quotes from the web? I don't care if it's from Yahoo Finance or some other site, as long as I can pull in the value. Without this functionality, my stock spreadsheets are basically useless.
IEX Trading offers free quotes for U.S. stocks, but their API returns JSON instead of XML. How about adding a new VBA library to MS Office, so every Excel user can create and parse JSON with a few lines of code and without external libraries?
Unbelievable that Excel doesn't have this capability, even Google Sheets does much, much more.
Being able to access daily financial results in excel very important!
Its important that we can put in a start and end date and not just get current prices. This enables us to implement trading rules such as a Trailing Stop.
This is fantastic!
Please make Moving Averages (50 day, 100 day.....) a supported quote field?
Thank you james - I am looking forward to this.