Re: Import External Date/Web query problem



Don, Thanks. I know there are other ways to gee the data into my
spread***, but I guess I am a bit stubborn. I like the WEB Query methos
and am going to try and find out why it broke and get it working again. In
the meantme I will use one of the other methods to get me by. Thanks for
pointing out the xltraders site. Lots of good stuff there. Carl

"Don Guillett" wrote:

I took another look at this morning and could not get the portfolio to stick
on an import or on a query using the url so all I can suggest is that you
use my program in xltraders or something similar to build your portfolio.

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Carl Hopkins" <CarlHopkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2239E7E6-0766-44B4-8BFF-D0FD2CB35F1B@xxxxxxxxxxxxxxxx
I have a spread*** that does a Data/Import External Data/Web Query to get
data from my Yahoo stock portfolio. It has worked for years. On January
31,
Yahoo made a change to their web page and my query stopped working with
the
following message: "Unable to open http://finance.yahoo.com/p?v&k=pf_1.
The
internet site reports that a connection was established but the data is
not
available." I have redone the query with the same results.
Interestingly, I
can query other tables on Yahoo, just nothing on their finance page. I
tried
MSN and also got the same results from a stock portfolio I set up there.
Yahoo fianance's response was they they don't know what the problem is but
it
isn't anything at their end so they can't/won't do anything. I really
rely
on this feature and it's absence is hurting. Anyone got any ideas? Carl
(Running current XP and Office 2003)



.