View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajan Iyer Rajan Iyer is offline
external usenet poster
 
Posts: 4
Default Dynamic link to website

I have 4000 shares in MZM which are trading around the A$0.27 mark. On my
asset register (created in Excel 2003) the value of this shareholding is
derived by the simple formula =4000*.27

How can I create a dynamic link to the daily listing of MZM on the ASX
website
(http://www.asx.com.au/asx/markets/Eq... ASXCodes=mzm)
so that the current value is listed every time I open the asset register?

Thanks in advance O gurus!
--
Rajan