Fold to ISO shove from BB after SB limp in HU

[TIGANCIC]

Hello!

I want to correctly calculate how often the SB limps and then folds to an isolation shove from the BB in heads-up. I'm using the following query:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9 
    AND tourney_hand_summary.cnt_players = 2 
    AND (tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack
    AND lookup_actions_p.action LIKE 'CF'
, 1, 0])


Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9 
    AND tourney_hand_summary.cnt_players = 2 
    AND (tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack
    AND lookup_actions_p.action LIKE 'C%'
, 1, 0])


[Flag_Hippo]

I'd recommend using the following in the second expression which means that the player had to have taken a second preflop action otherwise you could potentially have a hand counted where the SB limps all-in:

Code: Select all

lookup_actions_p.action LIKE 'C_%'

[TIGANCIC]

Why isn't this statistic working? Could there be an issue with the code?

Is it possible that something is wrong with this expression?

Code: Select all

AND (tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind)
>= tourney_hand_player_statistics.amt_p_effective_stack


[Flag_Hippo]

Why isn't this statistic working? Could there be an issue with the code?

Is it possible that something is wrong with this expression?

Code: Select all

AND (tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind)
>= tourney_hand_player_statistics.amt_p_effective_stack


Ah yes there is an issue I didn't initially spot. tourney_hand_player_statistics.amt_blind is the amount the player posted so in this case it will be 0.5 BB for the SB however after they limp that formula is not going to account correctly for the amount they need to call since at that point they have now invested 1BB:

Code: Select all

AND (tourney_hand_player_statistics.amt_p_raise_facing + (2 * tourney_hand_player_statistics.amt_blind))
>= tourney_hand_player_statistics.amt_p_effective_stack

[TIGANCIC]

And if I want to calculate a fold not to an isolate shove, but to a regular isolate?

That is, a fold to an isolate raise from BB. Would the following statistic work?

The problem is that I don't know what values to use in the BETWEEN ... AND ... range.

The isolate raise size should be between 2 BB and 4 BB.

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2
    AND (tourney_hand_player_statistics.amt_p_raise_facing + (2 * tourney_hand_player_statistics.amt_blind)) /   tourney_blinds.amt_bb between 2 and 4
    AND lookup_actions_p.action LIKE 'CF'
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2
    AND (tourney_hand_player_statistics.amt_p_raise_facing + (2 * tourney_hand_player_statistics.amt_blind)) /   tourney_blinds.amt_bb between 2 and 4
    AND lookup_actions_p.action LIKE 'C_%'
, 1, 0])

[Flag_Hippo]

That's fine. If you want to check some hands you can test your expressions using one of the methods described in this thread.