Hey Guys,
Im in the process of putting together my first trading journal in excel and im having difficulty figuring out how to calculate my % of winning trades. At the moment i have a single column devoted to WIN/LOSS, where it simply states WIN or LOSS depending on the trade. I was hoping to find a formula that can convert this column into a Winning %. Any help would be much appreciated!
This is probably the type of thing you should look for in an excel forum or google, but the formula is:
=countif(range of cells, “WIN”)/countif(range of cells, “")
aka
=COUNTIF(A:A, “Win”)/COUNTIF(A:A, "”)
Note that this counts the total number of strings (text) so if you have the first row (1:1) labeled as “result” then you should adjust the range of cells in the second part of the function.
Hey MilkMonkey
Heres more or less what you want - ther are many ways of doing it
In the first cell =COUNTIF(A$1:A1, “WIN”)/COUNTA(A$1:A1)*100
then if you drag the formula down as you go - you will get =COUNTIF(A$1:A2, “WIN”)/COUNTA(A$1:A2)*100 in the 2nd cell, and so on, so the end result (formatted to 1 decimal) will be as per the screenshot.
Thank you both for your input. All sorted now, cheers!
Oh, quite useful