friidayy wrote:cnt_f_fold2bet_limped_mw_pot
sum(if[cash_hand_player_statistics.flg_f_fold and not cash_hand_player_statistics.flg_f_face_raise and cash_hand_summary.cnt_players_f >= 3 and NOT(cash_hand_player_statistics.flg_p_face_raise) and cash_hand_player_statistics.cnt_p_raise = 0, 1, 0])
Is this fine? Do I need some additional brackets?
cash_hand_player_statistics.flg_f_fold is true if the player folds at anytime on the flop so this isn't suitable as the player may call a bet and then fold to subsequent action as the hand is multiway. As these are multiway pots not cash_hand_player_statistics.flg_f_face_raise isn't suitable either as the player may call the bet (which you want counted) but if they then face a raise from another player it wouldn't get counted. To count folds vs bets you can use:
- Code: Select all
cash_hand_player_statistics.amt_f_bet_facing > 0 and lookup_actions_f.action SIMILAR TO '(F|XF)'
friidayy wrote:cnt_f_fold2bet_limped_mw_pot_opp
How can I do this? I would expect something like: cash_hand_player_statistics.flg_f_fold_opp, but it's
not there.
You can use cash_hand_player_statistics.amt_f_bet_facing > 0 as you want to know if they are facing a bet.