Page 1 of 1

BU MR, SB F, BB 3B

PostPosted: Fri Dec 24, 2021 11:52 am
by DJSpinThat
Hi, im having trouble creating the second column, the 3B_opp stat for when BU MR-2.5x, SB F, BB 3B

BB 3B vs BU MR2.5x

(cnt_p_3bet_BB_BUMR2.5x / cnt_p_3bet_opp_BB_BUMR2.5x)*100

cnt_p_3bet_opp_BB_BUMR2.5x

sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.str_actors_p LIKE '08%' and ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) between 2 and 2.5 and tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.flg_p_3bet_opp and NOT (tourney_hand_player_statistics.flg_p_limp), 1, 0])

This captures the hands where BU MR-2.5x, SB F, and BB calls or 3Bets, but the times when the BB folds, this is also a 3B opp so im trying to figure out an expression that includes that also, but im having trouble.

If you use tourney_hand_summary.str_actors_p LIKE '0', this captures it, but what expression can i use/add so that it captures all 3 scenarios (BB fold, BB call, BB 3Bets, since as long as it is folded to the BB it is a 3bet opportunity)

Merry Christmas everybody!

Re: BU MR, SB F, BB 3B

PostPosted: Sun Dec 26, 2021 1:21 pm
by Flag_Hippo
Code: Select all
tourney_hand_summary.str_actors_p LIKE '0%' and tourney_hand_summary.str_actors_p NOT LIKE '09%'

highfalutin