Canadian Money Forum banner
1 - 5 of 5 Posts

· Registered
Joined
·
198 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
Just to add to this. Last I remember there is no way to tie a symbol with a specific index. So if you have a symbol on the TSX for companyA and a symbol on the S&P 500 for companyB then by default google docs will take the S&P 500 companyB
 

· Registered
Joined
·
198 Posts

· Registered
Joined
·
198 Posts
I use Quick tax tracker....this software is more gear to tracking stocks for tax purposes (ie capital gains, loss, average price, costs, dividends, etc).

I really couldn't find anything in excel that did that and I was having a problem developing on on my own


There is another thread here that discusses software that you might be interested.
 
1 - 5 of 5 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