Re: Downloading .csv Data from Yahoo Finance into Excel

From: PA Bear (PABear_at_mvps.org)
Date: 02/17/04 

Date: Mon, 16 Feb 2004 20:52:24 -0500

Yes, the recent IE update is involved but the problem really is Yahoo, who
hasn't brought the website function up-to-speed with current IE and Windows
security. (Not unusual for Yahoo, BTW.)

You can uninstall the problem update via Add/Remove Programs> 'Internet
Explorer Q832894'. Your anti-virus application and all other running
processes (e.g., OE, IE) must be closed prior to the uninstall and you will
have to reboot.

Q832894 includes very important security fixes. I wouldn't go without it
myself. 

-- 
HTH...Please post back to this thread
~Robear Dyer (aka PA Bear)
MS MVP-Windows (IE/OE), AH-VSOP
AumHa Forums
http://forum.mvps.org/
Protect Your PC
http://www.microsoft.com/security/protect
fourstar77 wrote:
> Hello,
>
> Ever since a recent update of Internet Explorer 6 I have been unable to
> download .csv data from Yahoo Finance. However, my father who uses a MAC
> as well as an older version of IE for windows has no problem. I believe
> that the problem is a combination of Yahoo and some recent updates to
> IE6. Therefore I either need a workaround or a way to get back to an
> older version of IE 6 or even further back to IE5. Here is the background
> for the problem which relates to running a web query in Excel can be
> found below:
>
> Thanks
>
> Matt
>
> ----------------------------------------------------
>
> Matt
> I and many others have exactly the same problem. It's to do with changes
> made at Yahoo.  See my other post on this topic.  Their link has changed.
> If you left click their download link it now loads the data into your
> browser window rather than giving you the option of saving a CSV file.  If
> you right click you get an error.  This error, which you get from within
> IE,
> is also preventing web queries from working.
>
> I have found this is quite Windows/browser version specific. It may depend
> on the security patches applied to IE as well. With IE 5.1 I don't have
> problems.  With IE 6.0 with the latest security patches I now (as at a few
> days ago) cannot get it to work.
>
> Send a note to Yahoo -- it's definitly their service that's the problem.
> But
> who knows whether it is something intentional on their part or whether
> it's
> just a bug which they will fix.
>
>
> "Matt Day" <fourstar77@hotmail.com> wrote in message
> news:e3t$mhQ8DHA.1040@TK2MSFTNGP10.phx.gbl...
>> Hello,
>>> I have a web query embedded within a spread*** that up until recently
> was
>> working just fine. It goes out to Yahoo's website and grabs financial
>> data
>> in .csv format and brings it back to the spread***. This macro and
>> connection works fine for others as well as for me at work, but at home I
> am
>> getting an error message stating that the connection was made but the
>> data
>> was not available. This seems to be related to either my computer or my
>> internet connection. I am currently on Comcast High Speed Internet at
> home,
>> but others are able to use their cable internet as well as T1 lines to
>> access the info. It will even work on a dial up connection. Does anyone
> have
>> an idea as to why this could be happening?
>>> I have tried power cycling my cable modem to acquire a new connection
>>> but
>> that does not seem to help. The interesting thing is that up until today
>> I
>> was able to eventually get the macro to grab the data from the website,
> but
>> it took many tries. Tonight I am not able to grab the data at all. Even
>> if
> I
>> try to right click on the cell in the spread*** and attempt to just
>> refresh the query, it says:
>>> Unable to open. http://finance.yahoo.com/d/quotes.csv?s=.....=.csv
>>>  and that the internet site reports that a connection was made but the
>>> data was not available.
>>> Suggestions would be greatly appreciated. I have no idea what would have
>> caused this or why it started.
>>> Thanks
>>> Matt