Hacker News new | ask | show | jobs
by earthWindFi 805 days ago
Looks promising. Does this sheet calculate both money-weighted returns and time-weighted returns?
1 comments

Yes it does calculate your portfolio return using both methods.

The money-weighted return is simpler to calculate, leveraging the XIRR formula built into Google Sheets.

The time-weighted return is calculated using a script that cycles through each month in your trading history, calculating the starting balance / investment return / ending portfolio balance at each month. Those monthly rates of return are then chained together to calculate your aggregate time-weighted return.