bet/fold river correct?

[skatemaza]

Hello,

this is the first time, I tried out to develop my own stat.

Situation: How often does a player fold if he bets the river and faces a raise related to how often his bet was raised on the river.

For that I have created two new colums:

cnt_raised_r_bet (Number of times player faced a raise on the river to his bet):

sum(if[holdem_hand_player_statistics.flg_r_bet AND holdem_hand_player_statistics.flg_r_face_raise, 1, 0])

cnt_bet_fold_r (Total number of times a player made a bet fold on the river):

sum( if[ (holdem_hand_player_statistics.flg_r_bet) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown) and NOT
(holdem_hand_player_statistics.flg_r_3bet), 1, 0])


And then I have combined them to b/f river %:

(cnt_bet_fold_r/cnt_raised_r_bet)*100


Is my first own stat correct? :)

Thanks
Martin

[kraada]

That should work.

Just for completeness's sake though, you could do your second column much more simply:

cnt_bet_fold_r (Total number of times a player made a bet fold on the river):

sum( if[ lookup_actions_r.action = 'BF', 1, 0])

Will look for times the river string is exactly bet, then fold :)