How to correctly count a min-raise from SB in HU?

[TIGANCIC]

I want to check if my query correctly counts a min-raise from the SB in heads-up. I'm using the following query:

Checking if the raise size equals 2 BB:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_made = (2 * tourney_blinds.amt_bb)
, 1, 0])


An alternative approach—simply counting all SB hands:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.id_hand > 0
, 1, 0])


[Flag_Hippo]

I want to check if my query correctly counts a min-raise from the SB in heads-up. I'm using the following query:

Checking if the raise size equals 2 BB:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_made = (2 * tourney_blinds.amt_bb)
, 1, 0])


That's fine.

An alternative approach—simply counting all SB hands:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.id_hand > 0
, 1, 0])


That will count all hands where the SB VPIPs (limps or raises) since you've specified that with the actors string. How is this relevant to calculating min-raises from the SB?

Is this supposed to be a denominator for the first expression for calculating min raises?

Do you want to know the percentage of all 2bets that were min-raises? That would be a denominator of:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_aggressors_p LIKE '89%'
, 1, 0])


[TIGANCIC]

Thanks for your reply!

I appreciate the clarification. But shouldn't it be:

Code: Select all

AND tourney_hand_summary.str_aggressors_p LIKE '98%'


since 9 represents the SB and 8 represents the BB? Wouldn't that be the correct order for cases where the SB raises first?

[Flag_Hippo]

No - the aggressors string always starts with an '8' which represents the posting of the big blind. The second number is the position of the 2bettor, the third number is the position of the 3bettor and so on.

[TIGANCIC]

Thanks, I understand now about the aggressor string. But what about tourney_hand_summary.str_actors_p LIKE '89%'? What's the difference?

[Flag_Hippo]

Thanks, I understand now about the aggressor string. But what about tourney_hand_summary.str_actors_p LIKE '89%'? What's the difference?

That wouldn't be a possible actors string. The actors string starts with the position of the first player to VPIP (limp or raise) and that will not be the big blind.