XL2000 stock price web query stopped working

  • Thread starter Matthew Guerreiro
  • Start date
M

Matthew Guerreiro

I have been using the "Microsoft Investor Stock Quotes.iqy" that was included
in Excel 2000 to get current stock prices. On July 7, 2000, this query
stopped working, returning the following error message: "Unable to open
http://investor.msn.com/external/excel/quotes.asp?SYMBOL=x+y+z
Cannot download the information you requested."

Has Microsoft stopped supporting this web query?

Are there any workarounds? I have 6 years of portfolio performance data in
an excel spreadsheet that I would like to keep using.

Thanks.
 
B

Brian Smith

I am having the same problem with EXCEL2003. I assume you meant it stopped
working on July 7, 2005. I also have a strong, immediate need for a fix or
work-around.
 
M

Matthew Guerreiro

That's right Brian. The query worked until July 7th, 2005. Sorry for the
typo.
 
M

Matthew Guerreiro

Thanks Jason. After a bit of fiddling with the link you supplied, I got
things back to the way they were.

It would have been nice of Microsoft to have warned us about this change,
wouldn't it?
 
B

Brian Smith

Thanks for posting this fix. It worked fine after, of course, it took over an
hour's worth of experimentation to implement it since just changing the URL
in the EDIT|QUERY (the most logical approach) wouldn't save the change.
Ultimately I had to delete the entire old query and set up the new one.

Anyway, thanks again.

Brian Smith
 
K

Kim Blake

Yes, thank you very much, it took me over 2 hours to convert mine over (8
pages). I guess when the service is free, you get what you pay for!
 
D

DAL1066

Kim Blake said:
Yes, thank you very much, it took me over 2 hours to convert mine over (8
pages). I guess when the service is free, you get what you pay for!
Doug
 
D

David McRitchie

Hi Doug,
When you post something new it should *not* have any > indication in front
as that indicates previous material, the deeper (>>, >>>>) the earlier within the thread,
you could also clip out less relevant parts, especially if you are going to
bottom post, because most people will have just read the previous posts.

You will have to look at your macro code to see what you have to change.
It is not going to be exactly the same change for everybody, but where
two symbols are entered the format of the output differs than if only one
symbol were supplied.

Based on Jason Welles information

Different Ways of Using Web Queries in Microsoft Office Excel 2003, MSDN
http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xlWebquery.asp?frame=true

watch out for old links within query:
Old: http://investor.msn.com/external/excel/quotes.asp?SYMBOL=MSFT,IBM
New: http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=MSFT,IBM

Old: http://quote.money.cnn.com/quote/quote?symbols=msft
New: http://money.cnn.com/quote/quote.html?shownav=true&symb=MSFT IBM (not sure)

You will have to look to see where the macro is that you are running and look for
code that invokes bringing up and HTML page but as a query. If you look at
the several MSDN examples in teh first link you will get an idea of what you are looking
for based on the example below that link.

-
HTH, (see my stocks.htm page)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
A

Alias2k5

FYI the MSN tech support people were unaware of this when I emailed them -
they referred me to Excel tech support, who sent me back. Nice to see the
MSN reference pages here.

I think MSN supported both the "old" and "new" URLs for some time, then
terminated the old one. I was lucky enough to have a currency exchange
worksheet with the new URL that continued to work when the old worksheet
failed, and found it had a different query parameter. For those not sure how
to change:

1. L-click an active cell in the table (not the B7 list)
2. This lights up the query toolbar buttons: L-click "Edit Query"
3. Change the "Enter the address" (top) box by replacing the old with the new:
http://moneycentral.msn.com/investor/external/excel/...
 
P

proinwv

Add my thanks to the list. this fix does work. BTW my access to the site went
down and then returned and went down again in October. Go figure!

BOO to MSN for not making the info available.
 
K

kvdwerf

B

B. Wingbermuehle

I'm having a similar problem. But my queries work for some people and not
for others. Is there a setting that has to be changed?
 

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