I have CSV file of trading stats.
These stats have date on them.
I need a template to add a starting amount X and calculate the daily return with a compound effect over the initial amount.
For this, we will need a new column that calculated ALLOCATED % * NET PROFIT %
Then from that new column, we would calculate the return on a daily basis over our initial amount.
I would also need another column that would give the % return of each rows vs the initial amount.
See the attach file to know what I mean.
It is important that the results are compounded in daily close batch to keep the results as accurate as possible.
Or if you have a better way, I am open to it. I am worried that for example: 3 trade open with amount 100 the first one close with 10% profit so now the amount is 110 then the second close at 10% so the new amount is now 121. But those 2 trade were open at the same time meaning that the second one wasn't using 110 as starting equity, but 100$ also. So the result should be 120 after they both close.
I don't even know if it is possible to do, you let me know
10 freelancers are bidding on average $27 for this job
Hi, I am well versed with Google sheet as well as Excel. I went through project description. It would help to discuss further on the requirement as I have few queries. Looking forward to you response. Thanks