2bet then 3bet

[iatracker]

Hello,
i tried to make a custom stat (without filter on active player) , i test it in filter expression. Scenario is simple :
SB open on BB 2.5x
BB 3bet all-in

What should add to specify 2.5x ?

Code: Select all

tourney_hand_player_statistics.cnt_players = 2 AND
tourney_hand_player_statistics.flg_p_3bet AND
(tourney_hand_player_statistics.position BETWEEN 8 and 9) AND
(tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack)

[iatracker]

Another try / version
How can i specify the amount of the first raise and the amount of the 3bet ?

Code: Select all

tourney_hand_player_statistics.flg_steal_att AND tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.enum_p_3bet_action='F'

[iatracker]

i finaly found this non elegant solution ? I guess there is better , you tell me please .

SB open raise BB (3x in this example)
BB 3bet shove
SB FOLD

Code: Select all

tourney_hand_player_statistics.flg_steal_att      AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
(tourney_hand_player_statistics.position >= 8     AND
tourney_hand_player_statistics.position <= 9   )AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 3 and 3 AND
(
tourney_hand_player_statistics.enum_allin='P' OR
tourney_hand_player_statistics.enum_face_allin = 'P'
) AND
tourney_hand_player_statistics.enum_face_allin_action = 'F'

[Flag_Hippo]

i finaly found this non elegant solution ? I guess there is better , you tell me please .

SB open raise BB (3x in this example)
BB 3bet shove
SB FOLD

Code: Select all

tourney_hand_player_statistics.position >= 8     AND
tourney_hand_player_statistics.position <= 9

If the statistic is for the SB just use tourney_hand_player_statistics.position = 9.

Code: Select all

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 3 and 3

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3 is neater.

Code: Select all

tourney_hand_player_statistics.enum_allin='P'

Delete this. If the SB is folding then they cannot go all-in.

Code: Select all

tourney_hand_player_statistics.enum_allin='P'

tourney_hand_player_statistics.enum_face_allin = 'P' will only count hands where the BB covers the SB so use tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' instead if you also want to count hands where SB covers BB.

Code: Select all

tourney_hand_player_statistics.flg_steal_att AND tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.position = 9 AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3 AND tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND tourney_hand_player_statistics.enum_face_allin_action = 'F'

[iatracker]

thanks but i also need to count when 3bet all-in without knowing action after that .
So the 3 bettor should be in BB position , ur code doesn't work when i specify
" tourney_hand_player_statistics.position = 8 " .

lets say statistic is 3bet all-in in HU

new column 3b_HU_AIlin_3x_opp (this one is ok)

Code: Select all

sum(if[
tourney_hand_player_statistics.cnt_players = 2 AND
tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3
, 1, 0])

new column 3b_HU_AIlin_3x_action (not ok)

Code: Select all

tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.position = 8 AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3 AND
tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'

And if i delete tourney_hand_player_statistics.position = 8 it works but result is wrong ..
We need to know pourcentage of time that athe 3better goes allin .
I don't find a way to specify 3bettor in BB position .

[Flag_Hippo]

Sorry but I don't understand exactly what you want to count as there are too many conflicting expressions/statements. I need clarification on who the statistic is being written for (the 2Bettor or the 3Bettor) and what for what position(s) (SB, BB or both).

[iatracker]

Statistic is for 3bettor in BB position .
How many times he goes 3bet allin when SB att to steal him with a 2bet size of 3x

[Flag_Hippo]

Statistic is for 3bettor in BB position .
How many times he goes 3bet allin when SB att to steal him with a 2bet size of 3x

Thank you. You need to bear in mind that when writing a custom statistic you need to use parts of the database schema that are relevant to the player you are writing the statistic for and your last expression examples are not doing that:

thanks but i also need to count when 3bet all-in without knowing action after that .
So the 3 bettor should be in BB position , ur code doesn't work when i specify
" tourney_hand_player_statistics.position = 8 " .

lets say statistic is 3bet all-in in HU

new column 3b_HU_AIlin_3x_opp (this one is ok)

Code: Select all

sum(if[
tourney_hand_player_statistics.cnt_players = 2 AND
tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3
, 1, 0])

new column 3b_HU_AIlin_3x_action (not ok)

Code: Select all

tourney_hand_player_statistics.flg_steal_att AND
tourney_hand_player_statistics.flg_p_3bet_def_opp AND
tourney_hand_player_statistics.position = 8 AND
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3 AND
tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'

And if i delete tourney_hand_player_statistics.position = 8 it works but result is wrong ..
We need to know pourcentage of time that athe 3better goes allin .
I don't find a way to specify 3bettor in BB position .

tourney_hand_player_statistics.flg_steal_att is true when the player makes a steal attempt.

tourney_hand_player_statistics.flg_p_3bet_def_opp is only true when the player has the opportunity to defend against a 3Bet.

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) = 3 means the first raise made by the player was 3BB.

tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' means the player faced an all-in.

All of these elements would be fine if you were writing the statistic for how the SB reacts to the 3Bet but you cannot use them if you are writing the statistic for the 3Bettor. It is impossible for all of the above to be true for the 3Bettor in this scenario and why you get no results when using tourney_hand_player_statistics.position = 8. For example the 3Bettor is facing a steal attempt - they are not stealing themselves. You need to be using these parts of the schema instead to write your custom statistic:

tourney_hand_player_statistics.flg_blind_def_opp

tourney_hand_player_statistics.flg_p_3bet

(tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) (this is the amount needed to call so if the BB is facing a 3x raise then they only need to call 2BB)

tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack

[iatracker]

It really would be an enormous gain of time to have at least a short description of the 238 columns of player/tourney_hand_player_statistics table.
Totaly win win i guess .
I didn't notice the flg_p_3bet_def_opp and others , this is helpfull , thanks you .

[Flag_Hippo]

We have not published the schema like we did for PokerTracker 3 however the meaning of database fields haven't changed in any significant way. Also forum member 'Bininu' made their own schema document for PokerTracker 4 available in this thread.