top | item 39929465

(no title)

earthWindFi | 1 year ago

Looks promising. Does this sheet calculate both money-weighted returns and time-weighted returns?

discuss

order

getToTheChopin|1 year ago

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.