Pull stock price from web, format in Excel 2000

[tonyrulesyall]

I am using Microsoft Excel 2000 with Windows XP.

I would like to take stock prices from Yahoo! Finance
and multiply the current price by the number of shares I
currently own.

Here is an example of a stock I would like to track.
http://finance.yahoo.com/q?s=yum

It looks like the number is always to the right of "Last Trade".

Any idea how to do the code?

Thank you in advance for your help.

 

[Don Guillett]

goto
http://groups.yahoo.com/group/xltraders/
join
look for donaldb36 as author and download a free file to do it all for you.
There are other files that will also be of use

Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)