We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
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