copying information from a web site

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

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
 
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.
 
Back
Top