News for hackers. Stuff that matters.
Re:Investment Portfolio Tracker – automated portfolio return... by getToTheChopin on Thursday April 04, 2024 @08:25AM (#39929516)
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.

There are no comments on this comment yet.