Re: Import External Date/Web query problem

I back up. I had no problem opening the file but when I tried to import to
excel, as you had done, I also got the same message. At the moment, I can't
remember why.

Please feel free to goto the files section of xltrader yahoo group and look
in the files section. I have a couple of free files there under the author
donaldb36.

http://groups.yahoo.com/group/xltraders/

I now off to watch the super bowl so computer is going to bed.

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Carl Hopkins" <Carl Hopkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA8270C6-68BD-46A1-8D31-4AF8B9AEDB5D@xxxxxxxxxxxxxxxx
Don,

I gather by your response that you had no problem? Mine still does not
work. What is also very insteresting is that you got the "Views:...."
line.
That is not even an option on my screen. Each arrow in the yellow box
represents one table. Click on it and it turns green and you get to (try)
to
import that table. But on my screen, the line with "Views: Basic etc
through
[Create New View] is not a table! there is no arrow there. I can (try
to)
import the ads above it or the detail below it but not that line.

What do you suppose is different between our import views that causes mine
to fail while yours obviously works.

Carl

"Don Guillett" wrote:


Views: Basic [edit] - DayWatch - Performance - Fundamentals - DonView -
Real-time ECN - Detailed - [Create New View] Symbol Name Last Trade Last
Td
Size Change Volume Prev Cls Open 52-wk Range EPS (ttm) P/E Ex-Div Prev
Cls
^DJI DOW JONES INDUSTR Feb 3 10,793.62
N/A -58.36 -0.54%
N/A 10,851.98 10,849.57 9,961.52 - 11,




--
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)





.