[stinsont]

I am a Google Spreadsheet and Google Finance fan.

For example, to get the latest Apple Inc. stock price you type this in the google spreadsheet cell:

=googlefinance("AAPL", "price")

If you want a list of closing prices for a date range you can type:
=googlefinance("AAPL", "close", "2009-01-01", "2009-05-31")


Read more here
http://docs.google.com/support/bin/answer.py?hl=en&answer=54198

How do I get the latest stock prices into a MS spreadsheet rather than a Google spreadsheet?

 

[stinsont]

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...