Pull stock price from web, format in Excel 2000

T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top