Hey Tradersâ¦ I was wondering if anyone has put Van Tharpâs expectancy formulaâs into an excel spreadsheet. I have been doing it by hand, but the number of trades is making this process pretty tedious. I did a search, but didn't find what I was looking for. I have trouble figuring out the formulas. All my trades are in column A in points gain/loss format, (ie. 1.25; -.75). For Average Win I use: =SUMIF(A:A,">=0")/COUNTIF(A:A,">=0") For Average Loss I use: =SUMIF(A:A,"<0")/COUNTIF(A:A,"<0") For Percentage Win I use: =COUNTIF(A:A,">0")/COUNT(A:A) The above 3 formulaâs I got off another spreadsheet and seem to be accurate. My average risk in 1 point, so R = 1 (for now). Scratch trades are -.25, 0, and +.25 pts. .5R trades are .50 to .75; 1R trades are 1.0 to 1.25; 1.5R gains are 1.5 to 1.75: and so on. Reverse is true for losses. Here is where my "programming deficiencies" lieâ¦ What I want in my 1R cell is the sum of all trades in A that are equal to or greater than .75 and equal to or less than 1.25. What I want in my # of 1R trades is the number of all trades in column A that were equal to or greater than .75 and equal to or less than 1.25. Once I get these formulaâs down, the rest is just changing numbers. Any help would be greatly appreciated.