open raise > stack

[plukhead]

hola necesito ayuda con una expresion para cuando enfrentamos un open raise mayor a nuestro stack.Gracias

[Flag_Hippo]

The size of a preflop 2bet faced by a players is:

Code: Select all

tourney_hand_player_statistics.amt_p_2bet_facing

which you can compare to a players effective stack:

Code: Select all

tourney_hand_player_statistics.amt_p_effective_stack

Bear in mind the size of raise faced is the amount the player needs to call so you would have to account for players posting blinds as that reduces the amount to call as well as test for the 2Bet existing as you don't want to include walks:

Code: Select all

tourney_hand_player_statistics.amt_p_2bet_facing > 0 and ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack)

Finally if you only want versus opens then since the player isn't directly facing limpers it needs to be tested for by comparing the second character of the preflop aggressors string to the first character of the preflop actors string. 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.

[plukhead]

gracias,yo me refiero a todas las manos donde enfrentamos una 2bet no all-in mayor a mi stack...por ej SB abre a 3BB y nuestro stack es de 2.2BB

[Flag_Hippo]

Those hands would be included but if you want to test something from another players perspective e.g. testing that they did not 2bet all-in themselves then that would require a subquery which would disable the use of the cache for your custom statistic. For more on how SELECT works see here.