error code and proceed however you wish.
Paul
From: vitovla
To: MS EXCEL AND VBA MACROS
Sent: Monday, April 6, 2009 10:18:29 AM
Subject: $$Excel-Macros$$ Re: Connecting with yahoo finance servers
Hello Ashish Jain,
Yes you are right but my real problem it'
Hello Ashish Jain,
Yes you are right but my real problem it's that I don't know what is/
are the condition to establish that the connection fails. I tried put
in a "On Error GoTo" statement but the problem persist because Excel
doesn't close the failed connection
Do you have any suggestion?
Tha
Yes you are right.
You can access the data from the servers of yahoo directly.
It's not necessary to do a web query.
For example you can download directly the historical prices of the Dow
Jones Industrial Average with these url (you'll obtain a csv format
file with all data inside):
http://ichart.
Hi,
I must say I am interested in your project... I worked on this exact task
this past weekend.
I use a web query function to extract the data (I munipulate the url to adj
the data date range and symbol)
and if the data comes back in an unusual/unexpected format...i consider it a
fail and react a
Hi vitovla,
Use Exit keyword to break a process. You can use it to come out of
Subroutine or a Loop.
Its possible combinations are:
Exit Do
Exit For
Exit Sub
Regards
Ashish Jain
On Apr 4, 9:12 pm, vitovla wrote:
> Hello,
>
> I'm developing an application to download the data from yahoo finan
