In my brief trading stint, I’ve realized how important it is to track trades properly. So, I’ve created this workbook to track past and current trades, including P&L, capital allocation, and performance analysis. I’ve also added instructions to link it with the tradebook from Zerodha.
Feel free to check it out and share your feedback! Please connect with me via comments for any feedback, a walkthrough, or if you have a better alternative for tracking trades with historical data. Make a copy of this sheet on Gsheets itself instead of downloading it in excel, if you want to try it.
Currently I have dummy trades in this which you can remove manually from input sheets. Portfolio tracker - Google Sheets