Canadian Money Forum banner
1 - 2 of 2 Posts

· Registered
Joined
·
91 Posts
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?
 

· Registered
Joined
·
91 Posts
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...
 
1 - 2 of 2 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top