Stat help fold after calling a raise to cbet

[donduris]

Im trying to make a stat in this situation: Player did raise preflop(or 3bet) and got called, player does cbet and got raised and called the raise, i want the amount to times he folded on later streets, if its already built i do not figure where.

Stat would be

(cnt_f_cbet_call_to_raise_fold_despues / cnt_f_cbet_call_to_raise_fold_despues_opp) * 100


cnt_f_cbet_call_to_raise_fold_despues:
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (cash_hand_player_statistics.flg_t_fold OR cash_hand_player_statistics.flg_r_fold), 1, 0])

cnt_f_cbet_call_to_raise_fold_despues_opp
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (lookup_actions_t.action SIMILAR TO '(XC|XR|XF|BR|BC|BF)' OR lookup_actions_r.action SIMILAR TO '(XC|XR|XF|BR|BC|BF)'), 1, 0])

i think im close to it, but not so sure, any help comments will be very apreciated.

[WhiteRider]

That's pretty close - your actions column (the first one) should work fine.
In the second one I think you wanted one of your SIMILAR TO strings to not include the Xs. However, you probably need to end most of the options with a % character too, which represents any zero or more characters.

cnt_f_cbet_call_to_raise_fold_despues_opp
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (lookup_actions_t.action SIMILAR TO '(C%|R%|F|BR%|BC%|BF)' OR lookup_actions_r.action SIMILAR TO '(XC%|XR%|XF|BR%|BC%|BF)'), 1, 0])

Fortunately there are easier ways to check for an opportunity to fold.

I think I would probably use:

cnt_f_cbet_call_to_raise_fold_despues_opp
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (cash_hand_player_statistics.amt_t_bet_facing + cash_hand_player_statistics.amt_t_raise_facing + cash_hand_player_statistics.amt_r_bet_facing + cash_hand_player_statistics.amt_r_raise_facing) > 0, 1, 0])

..which says that total amount of bets or raises faced by the player on the turn or river was greater than zero, meaning they had a chance to fold.

[donduris]

That's pretty close - your actions column (the first one) should work fine.
In the second one I think you wanted one of your SIMILAR TO strings to not include the Xs. However, you probably need to end most of the options with a % character too, which represents any zero or more characters.

cnt_f_cbet_call_to_raise_fold_despues_opp
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (lookup_actions_t.action SIMILAR TO '(C%|R%|F|BR%|BC%|BF)' OR lookup_actions_r.action SIMILAR TO '(XC%|XR%|XF|BR%|BC%|BF)'), 1, 0])

Fortunately there are easier ways to check for an opportunity to fold.

I think I would probably use:

cnt_f_cbet_call_to_raise_fold_despues_opp
sum(if[cash_hand_player_statistics.flg_f_cbet AND (lookup_actions_f.action = 'BC') AND (cash_hand_player_statistics.amt_t_bet_facing + cash_hand_player_statistics.amt_t_raise_facing + cash_hand_player_statistics.amt_r_bet_facing + cash_hand_player_statistics.amt_r_raise_facing) > 0, 1, 0])

..which says that total amount of bets or raises faced by the player on the turn or river was greater than zero, meaning they had a chance to fold.

awesome, ur the best!