[Preet]

what I really want to be able to do is have my spreadsheet I use to track my stocks (average price, units etc) auto update with the current stock price. Does anyone do this using Excel?

Would be interested to see how others track stocks, dividends, capital gains etc...

I'm also a fan of Googledocs for this, autoupdates every 5 minutes. See an example I just published to track a hypothetical strategy.