Dynamic link to website

[Rajan Iyer]

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/EquitySearchResults.jsp?method=get&template=F1001&ASXCodes=mzm)
so that the current value is listed every time I open the asset register?

Thanks in advance O gurus!

 

[Mark]

Hi
I have used the following from MS Excel Help. In your case I would put this
link into a working worksheet and link a cell reference to the data you
require.

Cheers
Mark

Query for data from a Web page
Show All
Hide All
You can create or run a to retrieve text or data on a Web page. Web
queries are especially useful for retrieving data that is in tables or
preformatted areas The retrieved data does not include pictures, such as
..gif images, and does not include the contents of scripts.

Note If you retrieve data from a Web site, it is your responsibility
to make sure you use the data in compliance with any applicable terms and
conditions governing the use of the data by the owner and/or operator of
such web site.

Create a new Web query

1.. Do one of the following:
Start in Microsoft Excel

1.. On the Data menu, point to Import External Data, and then
click New Web Query.

2.. In the New Web Query dialog box enter the URL for the Web
page from which you want to get data. You can type the URL, paste it from a
copied address, or click the arrow next to the Address list and select a
recently used address.

3.. Click Go.

 

[David Biddulph]

Mark,

You should NOT include binary attachments in a non-binary newsgroup.