I find MS Excel very useful to track my finances. So one day I thought how nice it would be to track my portfolio using excel sheet. Then I searched internet for some free excel template to do this. And I found the one. I then modified it to make it more attractive with some color and formulas.

Then I thought how nice it would be if I can use it to calculate my capital gains from this sheet given the transactions. So I learnt some excel programming to come up with very crude way to do it. You can find this excel sheet here. And I have created one ppt with screenshots telling how to use it. You can download it here.How to Use Yahoo Excel.ppt. Please let me know your feedback at my email id purohit under score arvind at the rate of yahoo.com