Re: Dynamic link to website

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Mark,

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

"Mark" <markok@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23pifAxz0HHA.5644@xxxxxxxxxxxxxxxxxxxxxxx
Hi
I have used the following from MS Excel Help. In your case I would put
this link into a working work*** 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.

"Rajan Iyer" <RajanIyer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15F34170-5089-4488-BD87-07F8BD2CB298@xxxxxxxxxxxxxxxx
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!
--
Rajan


.

Quantcast