Time Weighted Return

[KyleT]

You could also have a look at this solution by @Cowboy13

Investment Returns (Monthly, Annual, Total, XIRR)!

October 2023 Update- Part 1 (Rev 1.6) @wally.bryan found error on the All Investment tab. This fixes that error. Rev 1.6 can be found here July 2023 Update- Part 3 (Rev 1.5) Update based on my July 23 post below. Rev 1.5 can be found here This updates allows a larger number of Balance History cells to be imported. @jmilner uncovered a scenario where importrange reached its limit of importing 175,000 cells from Balance History. I updated the importrange function to pull in 1 column of Balanc…