Building Custom 3 Bet Stat Based on Position of Hero
Posted: Wed Jan 25, 2023 2:23 pm
Hi, I am trying to build a custom stat to see certain actions vs a 3Bet and I want to do this position of both Hero and Villan (for preflop). I also want to assume that the Hero is the preflop raiser.
So I built out these two columns for cash 6 max where the first time is the number of times the UTG will call a BTN 3 Bet and the second time is the total oppurtunities when UTG faces a BTN 3 Bet. However, there is a mistake somewhere because I am getting a result of 0 for my column. I believe it is in the p_3bet_action as call as this is yielding the value to be 0. Any ideas on how to fix this would be very helpful. Thank you
utg_vs_btn_3_bet_call -
sum(if[cash_hand_player_statistics.position= 1 AND cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND
cash_hand_player_statistics.enum_p_3bet_action = 'C' AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
not(cash_hand_player_statistics.flg_p_4bet_def_opp) AND
not(cash_hand_player_statistics.flg_p_4bet) AND
(cash_hand_summary.str_aggressors_p LIKE '80%'), 1, 0])
utg_vs_btn_3_bet_opp
sum(if[cash_hand_player_statistics.position= 1 AND cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
not(cash_hand_player_statistics.flg_p_4bet_def_opp) AND
not(cash_hand_player_statistics.flg_p_4bet) AND
(cash_hand_summary.str_aggressors_p LIKE '80%'), 1, 0])
So I built out these two columns for cash 6 max where the first time is the number of times the UTG will call a BTN 3 Bet and the second time is the total oppurtunities when UTG faces a BTN 3 Bet. However, there is a mistake somewhere because I am getting a result of 0 for my column. I believe it is in the p_3bet_action as call as this is yielding the value to be 0. Any ideas on how to fix this would be very helpful. Thank you
utg_vs_btn_3_bet_call -
sum(if[cash_hand_player_statistics.position= 1 AND cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND
cash_hand_player_statistics.enum_p_3bet_action = 'C' AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
not(cash_hand_player_statistics.flg_p_4bet_def_opp) AND
not(cash_hand_player_statistics.flg_p_4bet) AND
(cash_hand_summary.str_aggressors_p LIKE '80%'), 1, 0])
utg_vs_btn_3_bet_opp
sum(if[cash_hand_player_statistics.position= 1 AND cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
not(cash_hand_player_statistics.flg_p_4bet_def_opp) AND
not(cash_hand_player_statistics.flg_p_4bet) AND
(cash_hand_summary.str_aggressors_p LIKE '80%'), 1, 0])