|
Get External Data
Does anyone use the DataGet 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 |
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 -- remove $$$ from email addresss to send email ============================== Don Guillett wrote in message ... Goto http://groups.yahoo.com/group/xltraders/ and look for author donalb36 and download my FREE files to do just this -- Don Guillett SalesAid Software "Dan Chupinsky" wrote in message . .. Does anyone use the DataGet 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 |
You may send to my email address your file and the url and some
representative symbols and I will take a look. -- Don Guillett SalesAid Software "R.VENKATARAMAN" wrote in message ... 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 -- remove $$$ from email addresss to send email ============================== Don Guillett wrote in message ... Goto http://groups.yahoo.com/group/xltraders/ and look for author donalb36 and download my FREE files to do just this -- Don Guillett SalesAid Software "Dan Chupinsky" wrote in message . .. Does anyone use the DataGet 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 |
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 "Dan Chupinsky" wrote in message . .. Does anyone use the DataGet 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 |
| All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com