Get External Data

[Dan Chupinsky]

Does anyone use the Data>Get External Data to get multiple stock quotes?
Recently when I try to use it, I get the error message "Unable to open
http://webservices.pcquote.com/cgi-bin/excel.exe.

Has this site been closed,or am I having a problem?

Dan

 

[Don Guillett]

Goto http://groups.yahoo.com/group/xltraders/
and look for author donalb36 and download my FREE files to do just this

 

[R.VENKATARAMAN]

I donwload sometimes the historical data of indian stockas from
in.financ.yahoo (even though at present the historical data appears to be
temporaily suspended). I use in excel data-get external data =create
webquery and download historical data in excel. I have even prepared a
macro for this. I have seen donaldb36's file and it appears to be a
sophisticated vba sub. But the macro appears tobe customised for American
stocks. the vba sheet also is protected and I am not able to see the macro
to customise for my purpose.

is there any way out

 

[Don Guillett]

You may send to my email address your file and the url and some
representative symbols and I will take a look.

 

[Dan Chupinsky]

Thanks Don! I downloaded you file and it does exactly what I want to do. But
I still do not know why my file that worked for over one year suddenly
decided to quit working.

Dan