2bet then 3bet

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

2bet then 3bet

Postby iatracker » Thu Jul 09, 2020 12:36 pm

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
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby iatracker » Thu Jul 09, 2020 1:06 pm

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
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby iatracker » Thu Jul 09, 2020 3:58 pm

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'
iatracker
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby Flag_Hippo » Fri Jul 10, 2020 7:20 am

iatracker wrote: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

iatracker wrote:
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.
iatracker wrote:
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.
iatracker wrote:
Code: Select all
tourney_hand_player_statistics.enum_allin='P'

Delete this. If the SB is folding then they cannot go all-in.
iatracker wrote:
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'
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 2bet then 3bet

Postby iatracker » Tue Jul 14, 2020 5:31 pm

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 . :oops:
iatracker
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby Flag_Hippo » Wed Jul 15, 2020 3:08 am

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).
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 2bet then 3bet

Postby iatracker » Wed Jul 15, 2020 5:47 am

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
iatracker
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby Flag_Hippo » Thu Jul 16, 2020 7:04 am

iatracker wrote: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:
iatracker wrote: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 . :oops:


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
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 2bet then 3bet

Postby iatracker » Thu Jul 16, 2020 9:33 am

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 .
iatracker
 
Posts: 91
Joined: Thu Jul 20, 2017 1:44 am

Re: 2bet then 3bet

Postby Flag_Hippo » Thu Jul 16, 2020 11:42 am

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.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 18 guests

cron
highfalutin