Facing Open Raise and No Callers

[husngforfood]

This should say that we are facing an open raise and no callers. Am I right?

substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int = substring(tourney_hand_summary.str_actors_p from 1 for 1)::int AND char_length(tourney_hand_summary.str_aggressors_p) = 2 AND char_length(tourney_hand_summary.str_aggressors_p) = 1

[WhiteRider]

A couple of points here.

Firstly, I think you have a typo in there in that you probably meant to check the length of str_actors_p = 1 at the end.

More importantly, you need to do the check of the string lengths BEFORE you check the specific characters.
If (for example) you try to turn the second character of the aggressors string into an integer, and that string is only 1 character long that will cause problems, so you need to swap the order and do the length checks first.

However, I don't think this will work as you expect. The actors and aggressors strings include all of the preflop actors/aggressors, not just those up to the point of the active player's first action. If anyone else acts after that open raise then this expression will fail.

The check for "open raiser" is correct as long as you put the length check before it:

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

To check that there were no calls or raises of the 2bet before the active player you can check for having an opportunity to 3Bet or higher and not an opportunity to squeeze.

cash_hand_player_statistics.flg_p_3bet_opp AND NOT cash_hand_player_statistics.flg_p_squeeze_opp

[husngforfood]

What about situations where I face an open raise but can't 3bet?

[kraada]

In order to catch that case it might be easier to use:

cash_hand_player_statistics.amt_p_2bet_facing > 0 and not(cash_hand_player_statistics.flg_p_squeeze_opp)

[husngforfood]

There's still a scenario that we want to exclude

EP 2bet shoves and has everyone covered at the table, MP calls, we are OTB and have no option to squeeze.

[kraada]

That one is a bit more complicated to exclude; I'll need to think on that one a little.

[husngforfood]

bump

[kraada]

I think a multi-stage approach is needed here:
(1) Make sure the raise is an open raise -- ie: substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_actors_p from 1 for 1)

(2) Then make sure the next actor is either you or not someone between you and the open raiser. The way to do this is to use modulo to rotate the board so that you effectively become the button, then make sure the next actor is not in the range between you and them. Like so:

NOT(((10 + substring(cash_hand_summary.str_actors_p from 2 for 1)::int) - cash_hand_player_statistics.position) % 10
BETWEEN 1 AND
(((10 + substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int -
cash_hand_player_statistics.position) % 10) - 1)))

The reason we do this rotation is because if you're OTB and the open raiser is in position 3 then the people who can act between you are between your position values (between 0 and 3 - positions 1 and 2 match). But if you're in the small blind and the open raiser is in position 3 then the people who can act between you are not between your position values (not between 3 and 9, but the others - 0, 1, and 2). This technique is used in the 5bet defense stats if you want to see another situation where it's in use.

[husngforfood]

Thank you!