Custom Stat : Fold vs 3B AI

[Moby84]

Hi there !

The spot is : BU OR 2bb and Fold vs 3B AI with more than 20bb (the 3B AI come from any position).

Stat to return : % of time BU is folding vs 3B AI with 20bb+

Value Expression :

(cnt_3h_bu_or_2bb_steal_3bet_ai_def_action_fold_sup_20 / cnt_3h_bu_or_2bb_steal_3bet_ai_def_opp_sup_20 ) * 100

Column Expression "cnt_3h_bu_or_2bb_steal_3bet_ai_def_action_fold_sup_20" :

sum(if[tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.enum_p_3bet_action='F' AND
tourney_hand_player_statistics.position = 0 AND
tourney_hand_player_statistics.amt_p_raise_made = (2 * tourney_blinds.amt_bb) AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 and 100 AND
(tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])

Column Expression "cnt_3h_bu_or_2bb_steal_3bet_ai_def_opp_sup_20" :

sum(if[tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.position = 0 AND
tourney_hand_player_statistics.amt_p_raise_made = (2 * tourney_blinds.amt_bb) AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 and 100 AND
(tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])

QUESTION : The stat returns 0/0 why ? What is wrong please ?

Thanks !

[Flag_Hippo]

The size of the 3bet faced in this case will be the difference between the size of the 3bet and the size of the 2bet so you need to account for that in your expression e.g.

cnt_3h_bu_or_2bb_steal_3bet_ai_def_action_fold_sup_20

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.enum_p_3bet_action='F' AND
tourney_hand_player_statistics.position = 0 AND
tourney_hand_player_statistics.amt_p_raise_made = (2 * tourney_blinds.amt_bb) AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 and 100 AND
(tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) >= tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])

[Moby84]

Thanks a lot Flag I'll check that