Get stock quotes with one click in excel, and company profiles too
By Chandoo at 24 June, 2008, 7:37 pm | 4 Comments
While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything.
First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, [...]
Read More >>Tracking mutual fund / Stock portfolios using excel - howto
By Chandoo at 18 April, 2008, 3:46 pm | 28 Comments
Would you like to spend next 5 minutes learning how to create an excel sheet to track your mutual fund portfolio?
click here to download mutual fund portfolio tracker excel sheet I have created and play with it.
NOTE: I have updated the sheet to fix a formula error, download it again if you need to.
We [...]
