Call open shove

[sgftymkgg]

( cnt_p_open_shove_call / cnt_p_open_shove_call_opp)*100

cnt_p_open_shove_call
sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (tourney_hand_player_statistics.enum_face_allin_action = 'C' OR tourney_hand_player_statistics.enum_face_allin_action = 'R') AND NOT(tourney_hand_player_statistics.flg_p_open_opp) and tourney_hand_player_statistics.cnt_p_face_limpers = 0, 1, 0])

cnt_p_open_shove_call_opp
sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND NOT(tourney_hand_player_statistics.flg_p_open_opp) and tourney_hand_player_statistics.cnt_p_face_limpers = 0, 1, 0])

This is not correct,How to correct it?
TY

[Flag_Hippo]

1. Your statistic is not specific to open shoves and it's going to count against 3bets+ as well. You can specify that the player faced a 2bet using tourney_hand_player_statistics.amt_p_2bet_facing > 0 but if you want to specify that the 2bet was an all-in then you will need to either limit your statistic to pots where no other players raised behind or use a subquery to test the size of the 2bet against the 2bettors effective stack but that will disable the use of the database cache.

2. Using tourney_hand_player_statistics.cnt_p_face_limpers doesn't mean there wasn't any limpers since the player you are writing the statistic for isn't going to be facing limps. If you want to exclude limped pots you will need to compare the actors and aggressors strings.

[sgftymkgg]

1. Your statistic is not specific to open shoves and it's going to count against 3bets+ as well. You can specify that the player faced a 2bet using tourney_hand_player_statistics.amt_p_2bet_facing > 0 but if you want to specify that the 2bet was an all-in then you will need to either limit your statistic to pots where no other players raised behind or use a subquery to test the size of the 2bet against the 2bettors effective stack but that will disable the use of the database cache.

2. Using tourney_hand_player_statistics.cnt_p_face_limpers doesn't mean there wasn't any limpers since the player you are writing the statistic for isn't going to be facing limps. If you want to exclude limped pots you will need to compare the actors and aggressors strings.

TY


cash_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (cash_hand_player_statistics.enum_face_allin_action = 'C' OR cash_hand_player_statistics.enum_face_allin_action = 'R') and cash_hand_summary.str_aggressors_p LIKE '__%' and cash_hand_summary.str_actors_p LIKE '__'

This is correct, right?

[Flag_Hippo]

cash_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (cash_hand_player_statistics.enum_face_allin_action = 'C' OR cash_hand_player_statistics.enum_face_allin_action = 'R') and cash_hand_summary.str_aggressors_p LIKE '__%' and cash_hand_summary.str_actors_p LIKE '__'

This is correct, right?

I don't know if it's correct since you haven't explained exactly what it is you are trying to do with a written explanation. If you are trying to restrict things to 2Bet pots then that will work for some hands but you will not get hands counted if any player calls behind since you have restricted the actors string to two characters. But if you do extend the actors string then you end with the same problem I mentioned earlier since you haven't specified the player is facing a 2Bet (or their specific position within the strings). Depending on what you want then you will probably need to make more specific comparions/tests with the strings.

[sgftymkgg]

cash_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (cash_hand_player_statistics.enum_face_allin_action = 'C' OR cash_hand_player_statistics.enum_face_allin_action = 'R') and cash_hand_summary.str_aggressors_p LIKE '__%' and cash_hand_summary.str_actors_p LIKE '__'

This is correct, right?

I don't know if it's correct since you haven't explained exactly what it is you are trying to do with a written explanation. If you are trying to restrict things to 2Bet pots then that will work for some hands but you will not get hands counted if any player calls behind since you have restricted the actors string to two characters. But if you do extend the actors string then you end with the same problem I mentioned earlier since you haven't specified the player is facing a 2Bet (or their specific position within the strings). Depending on what you want then you will probably need to make more specific comparions/tests with the strings.

I want to write Call open shove stats for all the positions

EG:UTG ALLIN 14BB, if MP's chips <=14bb, MP call, if MP's chips >14bb, MP call or raise

[sgftymkgg]

It's a little difficult for me, but I'll keep trying
thank you very much

[Flag_Hippo]

This may help you get started but doesn't cover every single scenario:

Code: Select all

sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (tourney_hand_player_statistics.enum_face_allin_action = 'C' OR tourney_hand_player_statistics.enum_face_allin_action = 'R') and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and lookup_actions_p.action LIKE '_' and not tourney_hand_player_statistics.flg_p_squeeze_opp and char_length(tourney_hand_summary.str_aggressors_p) >= 2 and char_length(tourney_hand_summary.str_actors_p) >= 1 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, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and lookup_actions_p.action LIKE 'F' and not tourney_hand_player_statistics.flg_p_squeeze_opp and char_length(tourney_hand_summary.str_aggressors_p) >= 2 and char_length(tourney_hand_summary.str_actors_p) >= 1 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, 1, 0])

Bear in mind the actions column does not count any hands where the player has to make a second decision preflop as that adds more complexity.

The actions column is not specific to calling/raising depending on the size of the 2Bet faced compared to the players stack.

When the player doesn't have a squeeze opportunity due to stack sizes this does not exclude hands where another player might have called in between the two players.

[sgftymkgg]

This may help you get started but doesn't cover every single scenario:

Code: Select all

sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and (tourney_hand_player_statistics.enum_face_allin_action = 'C' OR tourney_hand_player_statistics.enum_face_allin_action = 'R') and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and lookup_actions_p.action LIKE '_' and not tourney_hand_player_statistics.flg_p_squeeze_opp and char_length(tourney_hand_summary.str_aggressors_p) >= 2 and char_length(tourney_hand_summary.str_actors_p) >= 1 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, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' and tourney_hand_player_statistics.amt_p_2bet_facing > 0 and lookup_actions_p.action LIKE 'F' and not tourney_hand_player_statistics.flg_p_squeeze_opp and char_length(tourney_hand_summary.str_aggressors_p) >= 2 and char_length(tourney_hand_summary.str_actors_p) >= 1 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, 1, 0])

Bear in mind the actions column does not count any hands where the player has to make a second decision preflop as that adds more complexity.

The actions column is not specific to calling/raising depending on the size of the 2Bet faced compared to the players stack.

When the player doesn't have a squeeze opportunity due to stack sizes this does not exclude hands where another player might have called in between the two players.

Thank you

[Joop59]

Hello! Did you make it work? I'm interested in the stat if you're willing to share.

Thanks!

[sgftymkgg]

Hello! Did you make it work? I'm interested in the stat if you're willing to share.

Thanks!

NO

Writing this stats is hard
HAHA