Tenspeed39355
01-20-2011, 09:21 AM
Hi guys. I have another one for you. I need to extract some data from a web site and
insert it in excell ss. To start there will be 650 stock symbols in column A.
Copy the first symbol and insert it at http://www.cefconnect.com. After the screen shows
up for AWF which will be the first symbol scroll down the screen until you come to
the heading LEVERAGE. Copy line three (3) Total Debt (USD): $14.090M. Then insert
line three in the Excell ss at E3. Then repeat the process again until all 650 symbol have the data beside them. Here is an example of some of the symbols. AWF,EHI,EMD,HYB
KST,PHT,PHF, HIX,ACG,JDD. If you can get me to this point I think I will be able to
change some of the lines and extract the rest of the data. I think. LOL. Thanks again
for all the help you have given me in the past. I do not know how you do request as
quickly as you do but I do appreate it.
Max
insert it in excell ss. To start there will be 650 stock symbols in column A.
Copy the first symbol and insert it at http://www.cefconnect.com. After the screen shows
up for AWF which will be the first symbol scroll down the screen until you come to
the heading LEVERAGE. Copy line three (3) Total Debt (USD): $14.090M. Then insert
line three in the Excell ss at E3. Then repeat the process again until all 650 symbol have the data beside them. Here is an example of some of the symbols. AWF,EHI,EMD,HYB
KST,PHT,PHF, HIX,ACG,JDD. If you can get me to this point I think I will be able to
change some of the lines and extract the rest of the data. I think. LOL. Thanks again
for all the help you have given me in the past. I do not know how you do request as
quickly as you do but I do appreate it.
Max