Has anybody using Yahoo quotes services in Excel been experiencing a problem with it working recently? Mine has worked for years, and stopped last week for no apparent reason.
Typically to refresh quotes, I simply hit the "Refresh All" button. However, when I do that I now get the following message:
"Web Query returned no data. To change the query, click OK, .......". Basically, Excel is suggesting that I edit the query.
However, the query has worked without any problems for many years.
The connection string is "http://finance.yahoo.com/quotes/["QUOTE","Enter stock, fund or other symbols separated by commas."]
Within the Parameters... menu, I have selected the "Use the following value:" radio button and have values such as: PGP XPGPX PTY XPTYX.......
Notice that these are stock symbols plus NAV symbols. From what I can tell, MSN does not recognize NAV symbols, which is why I don't use their service.
Typically to refresh quotes, I simply hit the "Refresh All" button. However, when I do that I now get the following message:
"Web Query returned no data. To change the query, click OK, .......". Basically, Excel is suggesting that I edit the query.
However, the query has worked without any problems for many years.
The connection string is "http://finance.yahoo.com/quotes/["QUOTE","Enter stock, fund or other symbols separated by commas."]
Within the Parameters... menu, I have selected the "Use the following value:" radio button and have values such as: PGP XPGPX PTY XPTYX.......
Notice that these are stock symbols plus NAV symbols. From what I can tell, MSN does not recognize NAV symbols, which is why I don't use their service.