Read? Have you started using CAGR or XIRR to measure your portfolio performance?
You just need to seperate into two different worksheets in your MS Excel file for 1) detailed recording of transactions and tracking of portfolio and 2) measuring of portfolio performance and returns on capital using XIRR.
Here are snapshots of examples:
Sometime, two steps are simpler than one step for all. Believe it or not.