New Posts For Thread: Excel Helphttps://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-helpI 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 cellsCheers, I'll try those out.https://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931966#420931966Cheers, I'll try those out.Wed, 31 Mar 2010 04:50:37 -0500snaphttps://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931962#420931962snapWed, 31 Mar 2010 04:41:00 -0500Assuming 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 totalhttps://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931958#420931958Assuming 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 totalWed, 31 Mar 2010 04:40:44 -0500=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 16In column M put =K16/(K16+L1https://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931954#420931954=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 16In column M put =K16/(K16+L1Wed, 31 Mar 2010 04:40:31 -0500*sign ;)https://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931950#420931950*sign ;)Wed, 31 Mar 2010 04:38:58 -0500Say you have data in range F8:F12This 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)Similhttps://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931946#420931946Say you have data in range F8:F12This 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)SimilWed, 31 Mar 2010 04:38:11 -0500I 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 cellshttps://community.betfair.com/general_betting/go/thread/view/94082/23535694/excel-help?post_id=420931942#420931942I 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 cellsWed, 31 Mar 2010 04:30:51 -0500