BU MR, SB F, BB 3B

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

BU MR, SB F, BB 3B

Postby DJSpinThat » Fri Dec 24, 2021 11:52 am

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!
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: BU MR, SB F, BB 3B

Postby Flag_Hippo » Sun Dec 26, 2021 1:21 pm

Code: Select all
tourney_hand_summary.str_actors_p LIKE '0%' and tourney_hand_summary.str_actors_p NOT LIKE '09%'
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 32 guests

cron