BB vs SB Open - fold AI and NAI

[G1PoQ]

Hi guys im trying to build custom that show a BvB situation when BB fold to an open raise Allin from SB and same stat with non allin i try this but it doesnt work:

Here is my custom stat for No allin

( LDB_cnt_p_bb_v_sb_fold_NAI_global / (LDB_cnt_p_bb_v_sb_fold_NAI_global+LDB_cnt_p_bb_v_sb_call_NAI_global+LDB_cnt_p_bb_v_sb_3bet_NAI_global) ) * 100

LDB_cnt_p_bb_v_sb_fold_NAI_global:

sum
(if[tourney_hand_player_statistics.position=8
AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F'
AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9
AND tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack , 1, 0])

LDB_cnt_p_bb_v_sb_call_NAI_global:

sum
(if[tourney_hand_player_statistics.position=8
AND tourney_hand_player_statistics.flg_blind_def_opp
AND lookup_actions_p.action='C'
AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9
AND tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack , 1, 0])

LDB_cnt_p_bb_v_sb_3bet_NAI_global:

sum
(if[tourney_hand_player_statistics.position=8
AND tourney_hand_player_statistics.flg_blind_def_opp
AND lookup_actions_p.action LIKE 'R%'
AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9
AND tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack , 1, 0])

Can you help me with this please?

And i try this for allin situation but same result it doenst work

Thanks a lot

[Flag_Hippo]

The size of the raise faced is the amount need to call and the BB has already posted 1BB. Also amt_p_raise_facing is the size of the last raise faced which will not necessarily be the 2Bet in the 3Bet column so if you are comparing stacks to the size of an open raise then it's more accurate to use amt_p_2bet_facing:

Code: Select all

(tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) < tourney_hand_player_statistics.amt_p_effective_stack

If you need further assistance have you rebuilt your custom database cache? Also explain exactly how you know something isn't working. Provide details and if you have a hand that is counted but shouldn't be (or vice versa) then attach it here.

[G1PoQ]

Thank you so much its working now :p.

[Joop59]

Hi! Do you have a custom statistic made available for this? I'd love to have those stats :)