Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Excel 97/2000 - Help with looking up external data. | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) |