I am trying to figure out the win-loss/accuracy of stock trades exported to excel. I have thousand of lines of trades. Unfortunately the software exports the win/loss as a fraction and not two separate numbers. The only thing I can do is divide the cell with the win/loss, in this example I end up with 1.25/1.00. Is there any way to obtain a win/loss percentage from the available data (#trades and win/loss fraction)? I need to somehow end up with 55.55% (5/9) and 50% (5/10)
No. Trades............Win/Loss...............%
9..............................5/4......................???
10............................5/5......................???
I don't know if this is the appropriate forum but figured I would ask since I've been trying to figure it out for an hour.
Thank you.