Hello guys im trying to create a custom stat for BB vs SB situation:
so i would like to have BB fold to cbet from SB on the turn when the cbet is less than 65% of the pot and same stat with cbet more than 65% of the pot.
For 65%-:
(LDB_cnt_t_cbet_def_action_fold_0_65 / LDB_cnt_t_cbet_def_opp_0_65) * 100
LDB_cnt_t_cbet_def_action_fold_0_65:
sum(if[tourney_hand_player_statistics.enum_t_cbet_action='F'
AND tourney_hand_player_statistics.val_t_bet_facing_pct <= 65
AND 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 , 1, 0])
LDB_cnt_t_cbet_def_opp_0_65:
sum(if[tourney_hand_player_statistics.flg_t_cbet_def_opp
AND tourney_hand_player_statistics.val_t_bet_facing_pct <= 65
AND 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 , 1, 0])
Stat for 65%+:
(LDB_cnt_t_cbet_def_action_fold_65plus / LDB_cnt_t_cbet_def_opp_65plus ) * 100
LDB_cnt_t_cbet_def_action_fold_65plus:
sum(if[tourney_hand_player_statistics.enum_t_cbet_action='F'
AND tourney_hand_player_statistics.val_t_bet_facing_pct > 65
AND 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 , 1, 0])
LDB_cnt_t_cbet_def_opp_65plus:
sum(if[tourney_hand_player_statistics.flg_t_cbet_def_opp
AND tourney_hand_player_statistics.val_t_bet_facing_pct > 65
AND 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 , 1, 0])
So i would like to be sure i dont have mistake.
Thank you so much