3Bet 3bb

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

3Bet 3bb

Postby juzi » Sun Aug 21, 2022 8:59 pm

I want made a stat, if someone 3Bet with 2bb Raise first in, His 3Bet scale is 3bb.
I tried to make one,like this:

3Bet PF (3bb)
(cnt_p_3bet_3bb / cnt_p_3bet_opp) * 100

cnt_p_3bet_3bb
sum(if[tourney_hand_player_statistics.flg_p_3bet AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb = 3), 1, 0])

It passed the test, but it doesn't seem to be collecting data, and I want you to check if there are any mistakes.
juzi
 
Posts: 39
Joined: Wed Nov 06, 2013 3:05 am

Re: 3Bet 3bb

Postby Flag_Hippo » Mon Aug 22, 2022 5:24 am

juzi wrote:(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb = 3)

With this you are testing if the players effective stack is 3bb so that isn't going to work. If you want to test the players 3Bet size then you would need to use:

Code: Select all
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)

Also using the default cnt_p_3bet_opp column isn't going to be suitable as not every 3Bet opportunity is an opportunity to 3Bet to 3bb. You will need to build a custom 3Bet opportunities column that tests how often the player is facing a 2bb raise:

Code: Select all
(tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb)

Bear in mind that the size of the raise faced is the amount the player needs to call so for a player in the SB this would be equal to 1.5bb and for the BB it would be 1bb so you would have to account for the players position and size of 2bet faced separately in your custom column. Finally if you only want versus 2bb RFI then you would also need to specify that there were no limpers and since the player 3betting isn't directly facing limpers it needs to be tested for indirectly rather than using tourney_hand_player_statistics.cnt_p_face_limpers:

Code: Select all
char_length(tourney_hand_summary.str_aggressors_p) >= 2 and substring(tourney_hand_summary.str_aggressors_p from 2 for 1) ::int = substring(tourney_hand_summary.str_actors_p from 1 for 1) ::int

This expression says that the player who 2Bet was also the first player to VPIP. This post has information on how the actors and aggressors strings work while this thread and this thread discuss how you can compare/test the strings.
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 24 guests

cron
highfalutin