How to Calculate Exact Time Weighted Returns in Excel?

[Mephistopheles]

I downloaded Bogle's spreadsheet but the formulas are hard to wrap my head around. Additionally, it uses only month end values, and I'd like to be precise and use daily values. If anyone can provide a formula or even spreadsheet that illustrates the calculations in simple terms, I'd much appreciate it. Thank you!

[racemize]

Time weighted returns are easy, maybe you mean something else?

 

Anyway, Time weighted returns are just the simple returns strung together for each period:

 

TWRR = (1+SRR1)*(1+SRR2)*...(1+SRRn)

 

Money/time weighted returns can be calculated via XIRR in a spreadsheet.

[racemize]

Bogleheads has some spreadsheets in the wiki:

https://www.bogleheads.org/wiki/Calculating_personal_returns

[Mephistopheles]

Ah, you're right race, that's what I was looking for, and it's so simple too. I did download Bogle's spreadsheet, saw all the complex formulas, and got intimidated haha. Thanks!