2bet and fold

[clbjuan]

My 2bet and fold statistic is working badly, sometimes I get for example 200%, and it is allways too high
how i fitx it or how i get this stat in good.

[Flag_Hippo]

Rebuild your custom database cache (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild). If that doesn't change anything post the column expressions for your custom statistic.

[clbjuan]

https://ibb.co/pnspbGS i do Custom Cache Rebuild and doesen't work

[Flag_Hippo]

Please copy and paste your column expressions directly in the thread instead of using a screenshot. Thank you.

[clbjuan]

value expresion
(cnt_f_bet_def_action_raise_fold / cnt_f_bet_def_action_raise_fold_opp) * 100

cnt_f_bet_def_action_raise_fold

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (cash_hand_player_statistics.flg_f_fold OR cash_hand_player_statistics.flg_t_fold OR cash_hand_player_statistics.flg_r_fold), 1, 0])

cnt_f_bet_def_action_raise_fold_opp

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (lookup_actions_f.action SIMILAR TO '(RC|RF|RR|XRC|XRF|XRR)' OR 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])

[Flag_Hippo]

(lookup_actions_f.action SIMILAR TO '(RC|RF|RR|XRC|XRF|XRR)' OR 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)')

If the player faces a bet IP and just folds (F) you are not counting any of those hands as an opportunity to fold on the turn or river. You are also not counting hands where the player faces any bet IP and calls/raises or any sequence that contains more than two actions:

Code: Select all

(lookup_actions_f.action SIMILAR TO '(R_|XR_)%' OR lookup_actions_t.action SIMILAR TO '(F|X_|B_|C|R)%' OR lookup_actions_r.action SIMILAR TO '(F|X_|B_|C|R)%')

[clbjuan]

i dont understand sorry.
I told a friend to do me a favor and show me the way he had it and it goes like this:

(cnt_f_bet_def_action_raise_fold / cnt_f_bet_def_action_raise_fold_opp) * 100

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (cash_hand_player_statistics.flg_f_fold OR cash_hand_player_statistics.flg_t_fold OR cash_hand_player_statistics.flg_r_fold), 1, 0])

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (lookup_actions_f.action SIMILAR TO '(RC|RF|RR|XRC|XRF|XRR)%' OR lookup_actions_t.action SIMILAR TO '(XC|XR|XF|BR|BC|BF|C|F|R)%' OR lookup_actions_r.action SIMILAR TO '(XC|XR|XF|BR|BC|BF|C|F|R)%'), 1, 0])

[Flag_Hippo]

cnt_f_bet_def_action_raise_fold

Code: Select all

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (cash_hand_player_statistics.flg_f_fold OR cash_hand_player_statistics.flg_t_fold OR cash_hand_player_statistics.flg_r_fold), 1, 0])

cnt_f_bet_def_action_raise_fold_opp

Code: Select all

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND (lookup_actions_f.action SIMILAR TO '(R_|XR_)%' OR lookup_actions_t.action SIMILAR TO '(F|X_|B_|C|R)%' OR lookup_actions_r.action SIMILAR TO '(F|X_|B_|C|R)%'), 1, 0])