View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Danny[_13_] Danny[_13_] is offline
external usenet poster
 
Posts: 16
Default Get website information

Hi,

I would like to make a vba to get the website information. May I know
what kind of script able to do that?

excel worksheet format:
column A: Stock Code (eg: HKG:0005)
column B: Now Price (eg: 89.30)
column C: other information (not important)
_______________________________________________
http://www.google.com/finance?q=HKG%3A0005

89.30
-0.10 (-0.11%)
Delayed: 12:29PM HKT
HKG data delayed by 15 mins - Disclaimer Range 88.95 - 89.90 52 week
33.00 - 98.25 Open 89.40 Vol. 6.04M Mkt cap 1.55T P/E 212.91 Div/
yield - EPS 0.42 Shares 17.34B Beta - Inst. own -