Bet turn as non aggressor after check check the flop

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Bet turn as non aggressor after check check the flop

Postby french_rontana » Fri Aug 04, 2023 8:59 am

hello guys, I would like to know if and how is it possible to create a stats that considers a bet on the turn as a non-aggressor (e.g. BB vs SB) after SB opens and on the flop goes check check, on the turn SB does not bet and BB non-aggressor bets. thanks for understanding
french_rontana
 
Posts: 18
Joined: Sat Sep 16, 2017 8:39 am

Re: Bet turn as non aggressor after check check the flop

Postby Flag_Hippo » Sun Aug 06, 2023 6:36 am

Yes that can be done with a custom statistic - see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. While the latter was written for PokerTracker 3 and the user interface is different the techniques still apply to PokerTracker 4. There may also be some examples if you search this forum or the Download Warehouse.
Flag_Hippo
Moderator
 
Posts: 15232
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet turn as non aggressor after check check the flop

Postby french_rontana » Tue Aug 15, 2023 2:47 pm

Flag_Hippo wrote:Yes that can be done with a custom statistic - see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. While the latter was written for PokerTracker 3 and the user interface is different the techniques still apply to PokerTracker 4. There may also be some examples if you search this forum or the Download Warehouse.

Thank you for your response. I am not very practical unfortunately, could I have some help in creating this statistic?
Thank you very much
french_rontana
 
Posts: 18
Joined: Sat Sep 16, 2017 8:39 am

Re: Bet turn as non aggressor after check check the flop

Postby Flag_Hippo » Thu Aug 17, 2023 5:29 am

Where are you having trouble? Do you need something from the guides clarified? If you post what you have created so far we can give guidance on how to proceed.
Flag_Hippo
Moderator
 
Posts: 15232
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet turn as non aggressor after check check the flop

Postby french_rontana » Thu Aug 17, 2023 7:23 am

Flag_Hippo wrote:Where are you having trouble? Do you need something from the guides clarified? If you post what you have created so far we can give guidance on how to proceed.

Perhaps the statistic I am looking for is the float turn OOP, or does the float imply that there was a continuation bet on the flop? Thanks
french_rontana
 
Posts: 18
Joined: Sat Sep 16, 2017 8:39 am

Re: Bet turn as non aggressor after check check the flop

Postby Flag_Hippo » Thu Aug 17, 2023 12:24 pm

kaisefranz8 wrote:Perhaps the statistic I am looking for is the float turn OOP

Floats are IP bets which sounds like what you wanted based on your original post.
kaisefranz8 wrote:or does the float imply that there was a continuation bet on the flop?

Turn float bets are only possible if there was a flop continuation bet and the turn continuation bet is not made. If you look at the expression for cnt_t_float statistic it just uses sum(if[cash_hand_player_statistics.flg_t_float, 1, 0]) so it's not suitable for what you want as that will only includes hands where there was a continuation bet on the flop. What you can do instead is start with the expression for having the opportunity to float the flop (cnt_f_float_opp) and use that as a basis for new columns:

Code: Select all
sum(if[ (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.flg_f_open_opp AND char_length(tourney_hand_summary.str_aggressors_p) = 2 AND ((tourney_hand_summary.cnt_players > 2 AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int > tourney_hand_player_statistics.position) OR (tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.flg_f_has_position)), 1, 0])

If you add lookup_actions_f.action = 'X' to this (the player only checked the flop with no second action) then that means the flop got checked through. You can then use cash_hand_player_statistics.flg_t_bet or cash_hand_player_statistics.flg_t_open_opp to establish whether the player bet the turn or had the opportunity to bet the turn.
Flag_Hippo
Moderator
 
Posts: 15232
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet turn as non aggressor after check check the flop

Postby french_rontana » Sun Aug 20, 2023 4:39 pm

is there a guide to understanding each part of the code that makes up the column? also so I can create other statistics.
if this meanwhile can be simplified just to be used for cash. finally i did not understand if i need to add or replace lookup_actions_f.action = 'X' and what does the last sentence mean "You can then use cash_hand_player_statistics.flg_t_bet or cash_hand_player_statistics.flg_t_open_opp to establish whether the player bet the turn or had the opportunity to bet the turn. thank you very much
french_rontana
 
Posts: 18
Joined: Sat Sep 16, 2017 8:39 am

Re: Bet turn as non aggressor after check check the flop

Postby Flag_Hippo » Mon Aug 21, 2023 7:19 am

kaisefranz8 wrote:is there a guide to understanding each part of the code that makes up the column? also so I can create other statistics.

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.
kaisefranz8 wrote:if this meanwhile can be simplified just to be used for cash.

You can change all instances of 'tourney' to 'cash' or go to 'Configure -> Statistics -> Columns' and copy the expression for the cash version of the same column (cnt_f_float_opp).
kaisefranz8 wrote:finally i did not understand if i need to add or replace lookup_actions_f.action = 'X'

You need to add this to the expression to specify that the player checked the flop:

Guide: How to make a new version of a stat

kaisefranz8 wrote:and what does the last sentence mean "You can then use cash_hand_player_statistics.flg_t_bet or cash_hand_player_statistics.flg_t_open_opp to establish whether the player bet the turn or had the opportunity to bet the turn.

The statistic you want has the player betting the turn. cash_hand_player_statistics.flg_t_bet is true if the player bet the turn while cash_hand_player_statistics.flg_t_open_opp is true if the player had the opportunity to bet the turn. You will need two custom columns (use cnt_f_float_opp as the base) and one of them will need to count the turn bets and the second column will need to count the opportunities to bet the turn. Then both of the created columns are used to create the custom statistic.
Flag_Hippo
Moderator
 
Posts: 15232
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet turn as non aggressor after check check the flop

Postby french_rontana » Sun Sep 24, 2023 2:20 pm

Flag_Hippo wrote:sum(if[ (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC')

'CC' what does it mean?
french_rontana
 
Posts: 18
Joined: Sat Sep 16, 2017 8:39 am

Re: Bet turn as non aggressor after check check the flop

Postby Flag_Hippo » Mon Sep 25, 2023 5:08 am

lookup_actions_p.action = 'CC' means that the players first preflop action was call and they took a second preflop action which was also a call (for example a player limps and then subsequently calls when facing a preflop raise).
Flag_Hippo
Moderator
 
Posts: 15232
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 14 guests

cron