Pull stock price from web, format in Excel 2000
 

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.

Pull stock price from web, format in Excel 2000
 

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

wrote in message
ups.com...
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.