XIRR
Sometime, two steps are simpler than one step for all. Believe it or not.
Read? How are you measuring up with your investment return? (2)
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:
Portfolio Tracking
...