I’ve also been hoping for a good way to do this. As far as I’ve found, the best option with Google Sheets is this community solution: Investment Returns (Monthly, Annual, Total, XIRR)!. It is a bit hefty though - any change to my data takes ~60 seconds to recalculate in the returns sheet. It is probably not Excel compatible.
1 Like