3Bet Preflop (AI) -3Bet Preflop (NAI)

[blindax48]

Hello
I am currently working on the stat of 3BET Allin preflop and 3bet not Allin preflop but I can not. could you help me please. thinks

[Flag_Hippo]

See this thread and/or this thread for examples. If you have any further trouble please specify where and post the code you have so far.

[blindax48]

I thank you for your quick answer and would like to ask you again about another stat: CBet Flop in 2Bet Pot (BvB, BB)
Thanks again for the previous stats.

[Flag_Hippo]

The 'Advanced Search' link in the top right is very useful for searching thread titles in a specific forum.

[potamito]

CBet Flop in 2Bet Pot

For this just take the built-in stat Cbet Flop in non-3bet+ pots as the based for this. Or just take the Cbet Flop, duplicate it and edit the columns by adding this piece of expression to both columns...

Code: Select all

char_length(tourney_hand_summary.str_aggressors_p) = 2

That will isolate just single raised pot.

Going further remember that piece of code when you´re trying to isolate limped, pots from single raised pots and from 3bet pots because...

char_length(tourney_hand_summary.str_aggressors_p) = 1 (Isolates limped pots)
char_length(tourney_hand_summary.str_aggressors_p) = 2 (Isolates single raised pots)
char_length(tourney_hand_summary.str_aggressors_p) = 3 (Isolates 3bet pots)

(BvB, BB)

This is where I'm confused. Because apparently, you´re trying to build a Cbet Flop stat in a single raised pot on BvB when the active player is in the BB then you´re assuming SB limped and the BB ROL, right? Is this the scenario you´re trying to isolate?
If that´s the case then the expression above might not help you as it takes down the possibility of a limp.
Either way, the expressión you´re looking for to isolate BvB battles is...

Code: Select all

tourney_hand_summary.str_aggressors_p LIKE '89%' and tourney_hand_summary.str_actors_p LIKE '8%'

Cheers!