Re: Yahoo quotes error in Excel

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/10/04


Date: Tue, 10 Feb 2004 10:18:32 -0500

Shouldn't
This pointing is provided "AS IS" with no warranties, and confers no rights.

be
This posting is provided "AS IS" with no warranties, and confers no rights.

-- 
Regards,
Tom Ogilvy
"Sonny Kocak[MSFT]" <a-sonnyk@online.microsoft.com> wrote in message
news:tTE%23oO%237DHA.3852@cpmsftngxa07.phx.gbl...
> Dear Peter ,
>
> Thank you for contacting Microsoft Excel Online Support. My name is Sonny
> and I will
> be assisting you with this issue.
>
> It clearly appears that you understand that the whole issue is the lack of
> the CSV file. Thus, I can not speculate to Yahoo behavior on this manner.
> However, I can offer some helpful suggestions. One needs to ask: does this
> happen for each stock? Does it happen only for my existing stock list? Do
I
> need to rebuild my list? Does this occur on new stock that I haven't
tried?
> Is the problem isolated to just this machine?
>
> Finally, It appears that Yahoo Finance web site still supports and
provides
> downloadable stock files for spreadsheets. I am including two links below
> to Yahoo support pages: The first is for problems with downloadable
> spread***. (NOTE: with special instructions for Netscape 4.0 users). The
> second link is general finance support.
>
> 1)    http://help.yahoo.com/help/us/fin/quote/quote-05.html
>
> 2)    http://help.yahoo.com/help/us/fin/quote/
>
> Hope this helps,
>
> Sonny Kocak
> Microsoft Developer Support Professional
> This pointing is provided "AS IS" with no warranties, and confers no
rights.
> --------------------
> | From: "Peter Benson" <junk@junk.com>
> | Subject: Yahoo quotes error in Excel
> | Date: Tue, 10 Feb 2004 23:16:17 +1100
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | Message-ID: <e0dW2#87DHA.2472@TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.excel.programming
> | NNTP-Posting-Host: cpe-144-132-167-133.nsw.bigpond.net.au
144.132.167.133
> | Path:
>
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
> phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: cpmsftngxa07.phx.gbl microsoft.public.excel.programming:461562
> | X-Tomcat-NG: microsoft.public.excel.programming
> |
> | For those of you who have recently been getting "Application-defined or
> | object-defined error" when attepting to get a quote from Yahoo from Exce
> | VBA:  their US site http://finance.yahoo.com/?u  currently won't let you
> | download a CSV file. eg get a quote for IBM and click  the "download
data"
> | link. As at today it simply displays the data in your browser window
> rather
> | than letting you download the data in CSV format like it used to. Over
the
> | last month the problem was intermittent but now it seems to be constant.
> As
> | no CSV file is downloaded Excel displays the Application-defined or
object
> | defined error.
> |
> | I have no idea whether the problem with Yahoo is temporary or permanent.
> |
> |
> |
> |
>