Bet turn as non aggressor after check check the flop

[french_rontana]

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

[Flag_Hippo]

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.

[french_rontana]

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

[Flag_Hippo]

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.

[french_rontana]

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

[Flag_Hippo]

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.

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.

[french_rontana]

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

[Flag_Hippo]

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.

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).

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

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.

[french_rontana]

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

'CC' what does it mean?

[Flag_Hippo]

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).