.
65 Points
Joined February 2009
If trades are from intraday then purchase and sale value is irrelevant.
What you need to do is calculate profit and loss on each trade individually (without considering brokerage and other COA expenses)
Now you need to ignore negative value from all loss trades and sum it up
In excel this can be done easily using ABS Formulae