How to Get a Stock Price ONLY - not quote

Is there a way to import a stock price so that it can update automagically...

I see that I can do it with a full stock quote, but all I want is the price and volume. I'm using Excel 2007, but can't seem to figure it out.

In a best case senerio I'd like to have the symbol in cell A1, the quote pulled from internet on cell A2, and the volume in Cell A3. Is this possible?

As far as I know, I don't think you can do what you're wanting, but you can get around it by putting the stock quote on a different tab and then setting up a "Summary" sheet to pull just the informaiton you want (by linking to the Stock Quote tab). This will allow you to update the Quote and have your summary sheet update as well.