about probe barreling on the turn and river in raised and li

[TIGANCIC]

I have a question about probe barreling on the turn and river in both raised and limped pots.

Scenario 1: Raised Pot
Preflop: SB raises, BB calls.
Flop: SB checks, BB checks (check-check).
Turn: SB checks, BB bets, SB calls.
River: SB checks, BB bets.

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.amt_r_bet_made > 0
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.amt_r_bet_facing = 0
, 1, 0])

Scenario 2: Limped Pot

Preflop: SB limps, BB calls.
Flop: SB checks, BB checks (check-check).
Turn: SB checks, BB bets, SB calls.
River: SB checks, BB bets.

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.amt_r_bet_made > 0
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'C'
    AND tourney_hand_player_statistics.amt_t_bet_facing = 0
    AND tourney_hand_player_statistics.amt_t_bet_made > 0
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.amt_r_bet_facing = 0
, 1, 0])

[Flag_Hippo]

tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack

You are comparing the turn bet size with the preflop effective stack size and not the turn effective stack size.

AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'C'

This isn't what you described for the flop.

AND tourney_hand_player_statistics.amt_t_bet_made > 0
AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack

There is nothing in the columns that will restrict BB turn actions to a single bet. For example bet-calls, bet-folds when the BB faces a turn check raise will get counted. Note that if If you were using tourney_hand_player_statistics.flg_r_open_opp instead of tourney_hand_player_statistics.amt_r_bet_facing = 0 then the bet-folds wouldn't get counted.

[TIGANCIC]

Probe turn raise pot

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8 
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%' 
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2 
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing = 0
    AND tourney_hand_player_statistics.amt_f_bet_made = 0 
    AND tourney_hand_player_statistics.flg_t_open_opp
    AND tourney_hand_player_statistics.amt_t_bet_made  < tourney_hand_player_statistics.amt_t_effective_stack
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8 
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%' 
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2 
    AND lookup_actions_p.action = 'C'
    AND tourney_hand_player_statistics.amt_f_bet_facing = 0
    AND tourney_hand_player_statistics.amt_f_bet_made = 0 
    AND tourney_hand_player_statistics.flg_t_open_opp
, 1, 0])

Probe turn limp pot

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND lookup_actions_p.action = 'X'
    AND tourney_hand_player_statistics.amt_f_bet_facing = 0
    AND tourney_hand_player_statistics.amt_f_bet_made = 0 
    AND tourney_hand_player_statistics.flg_t_open_opp
    AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_t_effective_stack
, 1, 0])

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND lookup_actions_p.action = 'X'
    AND tourney_hand_player_statistics.amt_f_bet_facing = 0
    AND tourney_hand_player_statistics.amt_f_bet_made = 0 
    AND tourney_hand_player_statistics.flg_t_open_opp
, 1, 0])

[Flag_Hippo]

AND tourney_hand_player_statistics.amt_f_bet_facing = 0
AND tourney_hand_player_statistics.amt_f_bet_made = 0

For reasons I've covered before I recommend not using this. In place of that you can just use lookup_actions_f.action = 'X'.

AND tourney_hand_player_statistics.flg_t_open_opp
AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_t_effective_stack

You are not actually testing that a turn bet was made with this. If a player doesn't make a turn bet then tourney_hand_player_statistics.amt_t_bet_made will be zero and since zero will be less than the players effective stack as a result hands where bets are not made will still be counted. If a player is betting you don't need to test for the open opportunity since they could not have bet without it and if they are betting then they have bet an amount greater than zero:

Code: Select all

AND tourney_hand_player_statistics.amt_t_bet_made > 0
AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_t_effective_stack