The Money Mustache Community

Learning, Sharing, and Teaching => Investor Alley => Topic started by: henders on February 07, 2015, 01:54:28 AM

Title: deleted
Post by: henders on February 07, 2015, 01:54:28 AM

deleted

Title: Re: Tracking stocks in Excel
Post by: Grog on February 07, 2015, 05:26:46 AM

I use google spreadsheet online, where you can use the GoogleFinance function to retrieve stock price and other interesting info, you could use it like this by writing in the cell:

=GoogleFinance("AAPL")*GoogleFinance("CURRENCY:USDCHF")

You can retrieve other info too:
https://support.google.com/docs/answer/3093281

Title: Re: Tracking stocks in Excel
Post by: hodedofome on February 07, 2015, 07:07:15 AM

I use google finance as well. I'll put up some sample sheets so you can copy the formulas.