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.