copying information from a web site
 

basically:

i want to go to bloomberg.com and download the market cap of a firm. i
realize the altering of the address.

the websites are basically identical in shape.
is there a way to do a type of
"ctrl+f"
type: [market cap]
go to : next line
copy it.

?

thanks

copying information from a web site
 

It is probably better to use a webapplication form excel VBA. I lot of
people have done this already and you should do a search for "excel VBA
bloomberg" or "excel Visual basic bloomberg" to see if there are macro
available.

If you can't find one I will write the code. Let me know the URL yo uare
going to and the data from the URL you want downloaded into the excel
spreadsheet.

You can also do a webquery from a worksheet or VBA. From worksheet do to
menu : Data - Import External Data - New Webquery.

"jason" wrote:

basically:

i want to go to bloomberg.com and download the market cap of a firm. i
realize the altering of the address.

the websites are basically identical in shape.
is there a way to do a type of
"ctrl+f"
type: [market cap]
go to : next line
copy it.

?

thanks