Question about calculating fold to 3-bet shove in HU

[TIGANCIC]

Hi!

I'm trying to correctly calculate the fold to a 3-bet shove in heads-up. I'm using the following queries:

Fold to 3-bet shove:

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) 
    >= tourney_hand_player_statistics.amt_p_effective_stack
    AND lookup_actions_p.action = 'RF'
, 1, 0])


Total cases where SB faces a 3-bet shove after a min-raise:

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) 
    >= tourney_hand_player_statistics.amt_p_effective_stack
    AND lookup_actions_p.action LIKE 'R%'
, 1, 0])


The idea is to calculate the percentage of times SB min-raises, faces a 3-bet shove, and folds.
Question: Am I using lookup_actions_p.action = 'RF' correctly to define a fold to a 3-bet shove? Or should I be checking this situation differently?

[Flag_Hippo]

AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb)
>= tourney_hand_player_statistics.amt_p_effective_stack

This isn't correct as you should be adding the size of the players 2bet. You also don't need to divide by blinds when comparing but if you do it as you've done here you are dividing one half of the equation (the size faced) but not the other (the effective stack) so it wouldn't be a valid comparison anyway:

Code: Select all

((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) >= tourney_hand_player_statistics.amt_p_effective_stack)

Question: Am I using lookup_actions_p.action = 'RF' correctly to define a fold to a 3-bet shove? Or should I be checking this situation differently?

That's fine. You could use something else such as cash_hand_player_statistics.enum_p_3bet_action='F' but it doesn't really matter which.

[TIGANCIC]

If I want to create a fold to a 3-bet that is not all-in, do I just need to change the symbol to <? Is that correct?

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) < tourney_hand_player_statistics.amt_p_effective_stack)
    AND tourney_hand_player_statistics.enum_p_3bet_action = 'F'
, 1, 0])

And can the second column be left as it is?

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) < tourney_hand_player_statistics.amt_p_effective_stack)
, 1, 0])

[Flag_Hippo]

If I want to create a fold to a 3-bet that is not all-in, do I just need to change the symbol to <? Is that correct?

Yes.

And can the second column be left as it is?

There is nothing there that implies or specifies that a 3bet was actually faced.

[TIGANCIC]

Hi Hippo,

I wanted to clarify your statement:
"There is nothing there that implies or specifies that a 3bet was actually faced."
Wouldn't the condition:

Code: Select all

AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made)
< tourney_hand_player_statistics.amt_p_effective_stack)


confirm that SB actually faced a 3-bet? Since amt_p_3bet_facing represents the amount faced after the initial raise, doesn’t a nonzero value here indicate that BB has indeed made a 3-bet?
Or do I need to explicitly check for something else to confirm the 3-bet action?

Could this be the correct solution?

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made)
    < tourney_hand_player_statistics.amt_p_effective_stack)
    AND tourney_hand_player_statistics.enum_p_3bet_action SIMILAR TO '(F|C|R)' 
, 1, 0])


Thanks in advance!

[Flag_Hippo]

Wouldn't the condition:

Code: Select all

AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made)
< tourney_hand_player_statistics.amt_p_effective_stack)


confirm that SB actually faced a 3-bet? Since amt_p_3bet_facing represents the amount faced after the initial raise, doesn’t a nonzero value here indicate that BB has indeed made a 3-bet?

If no 3bet was faced then tourney_hand_player_statistics.amt_p_3bet_facing will be equal to zero and that's the value that will get plugged into the calculation/comparison since there isn't anything else in the second columns expression that tests for the player actually facing a 3bet.

Could this be the correct solution?

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_made = (2 * tourney_blinds.amt_bb)
    AND ((tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made)
    < tourney_hand_player_statistics.amt_p_effective_stack)
    AND tourney_hand_player_statistics.enum_p_3bet_action SIMILAR TO '(F|C|R)' 
, 1, 0])


Yes that's good.