Getting External Data with Saved Query

  • Thread starter Festus Bola Ademorijimi
  • Start date
F

Festus Bola Ademorijimi

Folks,
I am using an excel 2000, and I set up the Microsoft's saved web query
"Microsoft Investor Stock Quotes.iqy" which ran smoothly, and I was able to
refresh the data on my worksheet until some months ago when it stopped
working. I have tried setting up a new one that still would not work.
Any idea how to get this working again? I have tried rebooting my machine,
still no luck.
Here is the message which I am getting each time I tried to refresh the
query: Unable to open
http://investor.msn.com/external/excel/quotes.asp?symbol=LU+ Cannot download
the information you requested"
Note-LU is the symbol of the stock which I set up
 
C

CyberTaz

That URL doesn't work as a hyperlink or when used in the IE address bar, so
the problem is not with Excel or the import feature.

My guess is that the site has been modified and maybe in such a way as to
prevent downloading of data.

Have you tried recreating the query and navigating to the current page?

Good Luck |:>)
 
S

Stephen Sander

I had the same problem. Uuse this link instead of the MSN site (which
appears to have been changed to "lock out" external queries:

http://finance.yahoo.com/q/cq?d=v1&s=["QUOTE0","Enter stock, fund or
other MS Investor symbols separated by commas."]

This is the Yahoo site...works well for me, but you'll have to update
your cell references, since it places the data in different cells.

Steve Sander
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top