Page 1 of 1
2bet and fold
Posted:
Mon Jan 03, 2022 7:58 pmby 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.
Re: 2bet and fold
Posted:
Tue Jan 04, 2022 7:08 amby 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.
Re: 2bet and fold
Posted:
Sat Jan 15, 2022 2:42 amby clbjuan
https://ibb.co/pnspbGS i do Custom Cache Rebuild and doesen't work
Re: 2bet and fold
Posted:
Sat Jan 15, 2022 7:00 amby Flag_Hippo
Please copy and paste your column expressions directly in the thread instead of using a screenshot. Thank you.
Re: 2bet and fold
Posted:
Sun Jan 16, 2022 3:00 pmby 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])
Re: 2bet and fold
Posted:
Mon Jan 17, 2022 6:53 amby Flag_Hippo
clbjuan wrote:(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)%')
Re: 2bet and fold
Posted:
Tue Jan 25, 2022 5:34 pmby 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])
Re: 2bet and fold
Posted:
Wed Jan 26, 2022 6:18 amby 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])
