Need help to calculate stock returns

[pidugu]

I have put up a sheet to do this job for you. please refer my thread.

just plugin your transactions and you will get both NAV as well as individual stock CAGR and overall stock CAGR.

Google Spreadsheet for Tracking Portfolio

I will start with thanking @Prdnt_investor as i was inspired by his VP public portfolio tracking spreadsheet that he created and shared in the VP portfolio thread. I also learned calculating NAV from his blog. I also have to credit http://www.investmentmoats.com. I have taken his portfolio tracking spreadsheet as baseline to built this. I have customized on top of his spreadsheet. The spreadsheet is built to track my portfolio performance in the way i like. The spreadsheet has provisions for ad…