I have attached a workbook which contains a sample trade history. Interspersed between trades are deposits and withdrawals. I want to sum up the profit/loss between these deposits/withdrawals and then obtain a % profit/loss based on the account balance at the time of the previous deposit/withdrawal.
Then I want to sum up the total of each of the above calculations on a monthly basis.
The attached workbook provides the desired outcome, along with clarifying comments.
Any advice? Thanks!
Bookmarks