Custom Stat: Raise a F Float Bet in 3Bet+ Pot

[MikeOkhrimenko]

Hello!

Please check my logic. I want to create stat Raise a F Float Bet in 3Bet+ Pot.

Percentage of the time that a player raised a float bet when he was the aggressor and had 3bet or more preflop given that the player checked the flop out of position and faced the float bet.
Formula: Number of Times Player Raised a Float Bet on the Flop in a 3Bet or Higher Pot / Number of Times Player Could Raise a Float Bet on the Flop in a 3Bet or Higher Pot

(cnt_f_float_def_opp_action_raise_3bet_pot / cnt_f_float_def_opp_3bet_pot) * 100

cnt_f_float_def_opp_action_raise_3bet_pot
Number of times a player checked and raised when facing a bet while out of position on the flop after making a preflop 3bet or higher and being the preflop aggressor.

sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR', 1, 0])


cnt_f_float_def_opp_3bet_pot
Number of times a player checked and faced a bet when out of position on the flop after making a preflop 3bet or higher and being the preflop aggressor.

sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

Is this expression correct substring(lookup_actions_f.action from 1 for 2) = 'XR' and will it count all cases despite which actions follow player's raise? Or would it be better to use expression lookup_actions_f.action LIKE 'XR%'. Are these expression equal to each other?

[kraada]

substring(lookup_actions_f.action from 1 for 2) = 'XR' and lookup_actions_f.action LIKE 'XR%' are equivalent ways of writing the same thing. Your code looks good to me.

[MikeOkhrimenko]

Kraada, thank you for such quick answer!

[MikeOkhrimenko]

One more question I guess I found a more simple way. Please check my logic for this stat but for turn and river

So,

Raise T Float Bet in 3Bet+ Pot
(cnt_t_float_def_action_raise_3bet_pot/cnt_t_float_def_opp_3bet_pot) * 100

cnt_t_float_def_action_raise_3bet_pot
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.enum_t_float_action='R', 1, 0])

cnt_t_float_def_opp_3bet_pot
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_t_float_def_opp, 1, 0])


And the same for river

Raise R Float Bet in 3Bet+ Pot
(cnt_r_float_def_action_raise_3bet_pot/cnt_r_float_def_opp_3bet_pot) * 100

cnt_r_float_def_action_raise_3bet_pot
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.enum_r_float_action='R', 1, 0])

cnt_r_float_def_opp_3bet_pot
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_r_float_def_opp, 1, 0])

[WhiteRider]

Those will work, if you need the player to have raised preflop - none of the expressions here will count if the player just called a 3bet preflop for example.

[MikeOkhrimenko]

These stats are for preflop agressor like the stat from the first post of this topic

[kraada]

They will also count if you 3bet and call a 4bet - so you might want to specify that you had a flop cbet opportunity somewhere. But that's likely a very small percentage of opportunities as it would require a strange overall line and I expect it'd be quite rare.

[MikeOkhrimenko]

Thank you very much for your comments
I want to understand a logic) So If players 3bets and then calls 4bet he is not preflop agressor. And what actions must happen on flop to consider that player isn't PF agreessor but faces float on Turn?

Is such scenario true: player 3bets PF, calls 4bet. Plays XR Flop. Opponent calls. Player X turn and opponent bets. Will it be counted as player faces Float Bet on Turn?

[kraada]

If a player 3bets or 4bets he may be the preflop aggressor but isn't guaranteed to be so. He may have 3bet and someone else 4bet and he called the 4bet -- in which case the 4bettor is the aggressor (or even more rarely if he 4bet and called a 5bet).

You are defining the stat so you can make it match exactly how you want - the scenario you picked out would match the last definition you have of the stat.

[MikeOkhrimenko]

Excuse me) Maybe we didn't understand each other. I wanted to discuss another thing)

How does PokerTracker determine action "Float"? Is it a bet in position against missed Cbet? Or is it a bet in position against the aggressor of previous street, if he doesn't proceed his betting?

Because it's not clear for me from stat description in PT4
Float Turn - Percentage of the time that a player bets in position on the turn after the aggressor fails to continuation bet on the turn.

So what does "Turn Float" mean? Is it a bet in position against player who was PF agressor AND made Cbet on flop but missed Cbet on Turn? If it's true so I think only PF agressor can face float bet on Turn in HU pot, but maybe there are some variations for multiway pot

So it's better to add one of this expression to columns lookup_actions_p.action LIKE '%R' or flg_t_cbet_opp?