Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
XL2000 stock price web query stopped working
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/exc...p?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. |
#2
|
|||
|
|||
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. "Matthew Guerreiro" wrote: 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/exc...p?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. |
#3
|
|||
|
|||
That's right Brian. The query worked until July 7th, 2005. Sorry for the
typo. |
#4
|
|||
|
|||
Mine went down as well. It took some trial and error but I found the
query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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 " wrote: Mine went down as well. It took some trial and error but I found the query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#7
|
|||
|
|||
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! "Brian Smith" wrote: 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 " wrote: Mine went down as well. It took some trial and error but I found the query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#8
|
|||
|
|||
This solution also works when downloading foreign currency quotes.
David Truijen " wrote: Mine went down as well. It took some trial and error but I found the query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#9
|
|||
|
|||
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/... "David Truijen" wrote: This solution also works when downloading foreign currency quotes. David Truijen " wrote: Mine went down as well. It took some trial and error but I found the query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2000 stock price web query stopped working
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. -- PROINWV " wrote: Mine went down as well. It took some trial and error but I found the query on the moneycentral site: Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM Best of luck, Jason |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2000 stock price web query stopped working
Hi, Can anybody try this sheet with Moneycetral quotes in Excel 2000? http://www.vertex42.com/Files/StockQuoteTemplate.xls It works fine on my Excel2003, but fails in Excel2000, giving the following message: Unable to open http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=$INDU+$COMP,$INX,$COMP. Cannot download the information you requested. Also with simple IBM as single quote requested, it fails. Now, my Yahoo queries run well uner Xl2000. Anyone any idea? -- kvdwerf ------------------------------------------------------------------------ kvdwerf's Profile: http://www.excelforum.com/member.php...fo&userid=4377 View this thread: http://www.excelforum.com/showthread...hreadid=385583 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2000 stock price web query stopped working
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? "kvdwerf" wrote: Hi, Can anybody try this sheet with Moneycetral quotes in Excel 2000? http://www.vertex42.com/Files/StockQuoteTemplate.xls It works fine on my Excel2003, but fails in Excel2000, giving the following message: Unable to open http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=$INDU+$COMP,$INX,$COMP. Cannot download the information you requested. Also with simple IBM as single quote requested, it fails. Now, my Yahoo queries run well uner Xl2000. Anyone any idea? -- kvdwerf ------------------------------------------------------------------------ kvdwerf's Profile: http://www.excelforum.com/member.php...fo&userid=4377 View this thread: http://www.excelforum.com/showthread...hreadid=385583 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
how to copy old price data onto new stock list if match exists? | Excel Discussion (Misc queries) | |||
Drop-down boxes stopped working | Excel Discussion (Misc queries) | |||
query wizard has stopped working how do i rectify this | Excel Worksheet Functions | |||
In-cell dropdown for validation stopped working | Excel Worksheet Functions |