General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I have a spreadsheet recording all bets and I want a column that shows the strike rate of winning to losing bets.
How do I count the number of positive and negative values in a column and express the positive values as a percentage of the total cells in the column? Not interested in the values per se - just a count and a percentage. Ideally I would like to have a seperate column showing the running total for each cell.
Thanks
How do I count the number of positive and negative values in a column and express the positive values as a percentage of the total cells in the column? Not interested in the values per se - just a count and a percentage. Ideally I would like to have a seperate column showing the running total for each cell.
Thanks
Show More
Say you have data in range F8:F12
This would give you percentage of negative numbers (change the cell format in excel to percent, and replace lessthan with the sigh, it does not show in the forum threads)
=COUNTIF(F8:F12,"lessthan0")/COUNT(F8:F12)
Similarly for positive numbers.
This would give you percentage of negative numbers (change the cell format in excel to percent, and replace lessthan with the sigh, it does not show in the forum threads)
=COUNTIF(F8:F12,"lessthan0")/COUNT(F8:F12)
Similarly for positive numbers.
=IF(J160,K15+1,K15)
=IF(J161,L15+1,L15)
If for example the result of each bet is in column J, then put this formula in cells K16 and L16, which represent the runnign totals of losing and winning bets. Wlog starting at row 16
In column M put =K16/(K16+L16)
=IF(J161,L15+1,L15)
If for example the result of each bet is in column J, then put this formula in cells K16 and L16, which represent the runnign totals of losing and winning bets. Wlog starting at row 16
In column M put =K16/(K16+L16)
Assuming the bets P&L starts in cell a2:
In b1 enter: =COUNTIF(A2:A65536,"0")/COUNT(A2:A65536)
In b2 enter: =COUNTIF($A$2:A2,"0")/COUNT($A$2:A2) and drag this down all the way along your bets to give you a running total
In b1 enter: =COUNTIF(A2:A65536,"0")/COUNT(A2:A65536)
In b2 enter: =COUNTIF($A$2:A2,"0")/COUNT($A$2:A2) and drag this down all the way along your bets to give you a running total
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539