To get a total return, you wouldn't add or subtract the daily returns.
For example: If you had a $100,000 account, and you made 100% one day and lost 50% the next, you wouldn't have gained 50%, but instead you would be at 0%. You would have $200,000 after day 1 (+100%) and then you would have $100,0000 after day 2 (-50%).
Here is the actual math our spreadsheets use... (100*(1+(old total %))*(1+(new daily %))-100)/100
I hope this helps. If not, let me know.
Bookmarks