Calculating accuracy in Excel

rjay

Active member
Messages
122
Likes
0
I have a simple Excel spreadsheet with my number of winners in one cell (I1000) and losers in another (J1000). What sum do I use to end up with a % figure representing the total winners ?
 
Last edited:
No. of winners as a proportion of total trades = I1000/(I1000+J1000). Format the cell as "%" style.
 
dont mean to hijack your thread but i have a related Q and blackcab seems to know his stuff,

How do i calculate the risk/reward ratio generated by my trades and the no of points that i win/lose on each one??
 
Top