Well, I now have restored my ability to login to Yahoo Finance via Edge. However, I'm not sure if it's something I did, or perhaps something Yahoo did. I had most recently been adding Yahoo.com to my Trusted Sites in MS IE 11, which I understand carries through to MS Edge. After doing so, I found that I could finally login to Yahoo Finance via Edge. Unfortunately, this did not solve my real problem--which is to re-establish my ability to import data from Yahoo Finance (My Portfolios) into Excel via Excel's Web Queries. My hypothesis had been that my inability to login to Yahoo Finance via Edge was the underlying problem. Now that hypothesis has been proven false. When I edit my embedded web query (to Yahoo Finance's My Portfolios) in Excel, all I see is a blank space. Perhaps I'm making progress, but still searching for a solution.
So frustrating - I might just have to abandon yahoo finance - this is like the third time they have killed me with nonsense like this
I'm having the same problem and I can't find anywhere to contact the programmers outside this forum. Also looking for another financial website, but can't find anything as good as Yahoo that works. Maybe we need to organize a march LOL
My Yahoo finance queries from Excel stopped working last night (4/28/17) after working for years. If I paste the query into my browser (Safari) it returns results, but it does not return results with Excel. I have not changed anything. I'm guessing this is a Yahoo problem, but I'm confused about the inconsistent timing of eveyone's issue listed here . . . .
Ditto here. AFAICT, this is due to yahoo changing their layout so the financial info we seek is now presented in an iframe, rather than a table html element. One of the moderators on the Microsoft support site mentions that Excel can't pull data from an iframe via a web query. Hence an Excel web query for a stock quote like: https://finance.yahoo.com/quotes/AAPL,F,T/view/v1 pulls up nothing (being inside a frame element), where as the same URL in a browser will pull up stock quotes for APPL, F, & T tickers.
Now I'm looking into a work-around via microsoft money site (which has its own problems, I know) or dynamically importing a comma delimited format of the stocks I want to track via yahoo. VBA is another path I may pursue if I must. I don't hold out much hope that Yahoo will bring back their old Excel friendly financial web page layout.
The following references may help: Yahoo is going to redact any offsite links I happen to post, so here's hoping the site descriptions will provide interested parties enough info to find the sites on thier own via their favorite Internet searcher.
Celeste's post in the Microsoft Excel support forums mentions the iframe / table issue. The thread is titled:
Import Data from Balance Sheets Published on Yahoo Finance
An Excel University web page titled: MSN MoneyCentral IQY Web Query
Provides info on setting up Excel .iqy files to import data from Yahoo Finance (broken as reported for now) or MSN Money Central (which is operational once more after a hiatus awhile back, but with its own ongoing issues, flakily fed by Morningstar).
An alternate method of grabbing web data from Yahoo, via comma delimited files, on a rather promising page titled:
web connecting csv files as external data to excel spreadsheet from Kim Gentes.
Just adding that I'm not seeing a way to access the iframe element directly as a URL, but if that's possible, it may provide us a path toward restoring functionality to our Excel web queries to Yahoo Finance.
Glad to hear it, AdrianCos. I also enjoyed some success today with the comma delimited file approach. Things got even better once I realized I really did need to turn off the prompt for a text query's data range properties, as Kim's article above suggested. If you're using the auto refresh, you might also want to dial the frequency of the refreshes down or even off, since one is prompted for one's yahoo login info each time it updates.
For anyone else interested, here's an example of a text based excel query that downloads stock data in a comma delimited format:
Data columns returned (for Apple, Google, and Yahoo):
Symbol,Last Trade (Price Only),Last Trade Date,Last Trade Time,Change,Open,Day's High,Day's Low,Volume
I imagine one will be limited in how long an Excel text query can be, either by the number of characters (I'm guessing 256), or number of ticker symbols (I'd guess no more than 25) in the query, or both.
If you want more customized query results, do a search on "Yahoo! Finance: URL Download to a CSV File" from the Canbike site. It parses out the various yahoo download url parameters, and explains the keys that produce different query results. Only caveat I found in the info presented there was having my multi-stock yahoo queries fail if I changed the [FILENAME] parameter to anything other than the default quotes.csv.