Time weighted return - really need help :(

[domgilberto]

Im going insane. I'd really appreciate someones help on this?

Please see the spreadsheet attached.

Everything under the green column is 1,000 dollar invested and copying the "traders" daily returns (white headed columns) BUT ignoring their deposits and withdrawals (as you will see, I need to factor in their deposit and withdrawals but I don't know how to do this using a specific and clear formula that's fair and relative to a "Time weighted return" or what your: "1 dollar invested over this period would have looked like".

How do I do this on the percentages under the "Synthetic Columns"?

[domgilberto]

anyone have any ideas or even suggestions?