Page 1 of 1

Check Raise Flop in 3Bet Pot.

PostPosted: Sun Aug 12, 2018 10:45 am
by acesjohn
What am I missing?

sum(if[(cash_hand_player_statistics.flg_f_check_raise AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_3bet_def_opp), 1, 0])

I would like a stat that shows total check raise in a 3Bet+ pot. It is possible to be the one who 3bets due to the possibility of a cold call behind.

Or will I have to do a collective sum

Times we are the 3better + the times our opponent is the 3better?

Re: Check Raise Flop in 3Bet Pot.

PostPosted: Sun Aug 12, 2018 2:40 pm
by Flag_Hippo
That could also include 4bet+ pots and it sounds like you do not want that so as I mentioned to you here you can use char_length(cash_hand_summary.str_aggressors_p) = 3 to specify that it's a 3bet pot and this will count flop check raises whether the player made the 3bet or called the 3bet:

Code: Select all
sum(if[cash_hand_player_statistics.flg_f_check_raise AND char_length(cash_hand_summary.str_aggressors_p) = 3, 1, 0])

Re: Check Raise Flop in 3Bet Pot.

PostPosted: Sun Aug 12, 2018 8:22 pm
by acesjohn
Flag_Hippo wrote:That could also include 4bet+ pots and it sounds like you do not want that so as I mentioned to you here you can use char_length(cash_hand_summary.str_aggressors_p) = 3 to specify that it's a 3bet pot and this will count flop check raises whether the player made the 3bet or called the 3bet:

Code: Select all
sum(if[cash_hand_player_statistics.flg_f_check_raise AND char_length(cash_hand_summary.str_aggressors_p) = 3, 1, 0])


Sure, that is more clear now, thank you.

To clarify would that also work with:
"= 2" for a standard pot
"= 4" for a 4bet only pot
"=5" for a 5bet only pot (not that its relevant unless i'm playing deep)

Re: Check Raise Flop in 3Bet Pot.

PostPosted: Mon Aug 13, 2018 5:34 am
by Flag_Hippo
Yes that's correct. The aggressors string records the positions of the aggressive actions in order (BB posted -> 2bet -> 3bet e.t.c) so the length of this correlates to whether the pot was limped, 2bet and so on - this post has more information on how the aggressor and actor strings work .