Constructing a Limp CBet Stat

[TapDancingSquid]

*Facepalm

I knew that too just couldn't remember it. Thanks a lot!

[TapDancingSquid]

Another question. Sorry for asking so many.

lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'BF' AND tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.flg_p_open_opp


I have this for bet the flop now and fold to a raise, what would be the same expression for the opportunity to fold after being check raised on the flop?

[kraada]

lookup_actions_f.action LIKE 'B_%'

[TapDancingSquid]

Thanks again last question I hope

lookup_actions_p.action = 'X' AND lookup_actions_f.action 'XF' AND tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.flg_p_open_opp

Fold vs bet after the preflop action was a limped pot. Both for the folding part and the oppurtunity to fold. This is what I have for the folding part but I'm getting an error.

[kraada]

lookup_actions_p.action = 'X' is only true when your only preflop action is check, which requires being in the big blind or having posted a blind in position and checking -- but when in the big blind you never have an open opportunity (if everyone folds, the hand is over). So this will only trigger when you have someone posting in position and checking and someone limps behind them and then bets the flop when checked to - it's going to be exceedingly rare.

Do you want to limit it to the big blind here or not?

[TapDancingSquid]

No I don't want to limit it to the big blind. I'd like to have it to count all players in the pot except the original limper. Hope that makes sense

[kraada]

This is times then opportunities for someone who limps preflop, the pot remains limped, and they fold to a flop bet:

tourney_hand_player_statistics.flg_p_limp and char_length(tourney_hand_summary.str_aggressors_p) = 1 and lookup_actions_f.action SIMILAR TO '(F|XF)'

and

tourney_hand_player_statistics.flg_p_limp and char_length(tourney_hand_summary.str_aggressors_p) = 1 and tourney_hand_player_statistics.amt_f_bet_facing > 0

In the first case we check for limping, that nobody raised (if someone had raised the aggressors string would be longer), and that the flop action was fold or check fold (if you want in or out of position only you can modify that). The latter case we check the same first two, but then that the player was facing a bet.

[TapDancingSquid]

That doesn't seem to work.

This is counting the times the original limper(first person in the pot) folds to a bet in a limped pot.

I'm looking to find the times people fold to a bet postflop in a limp pot when the original limper bets.

For ex.

PRE: BU limps, SB folds, BB checks back

POST: BB checks, BU Bets, BB Folds

or

PRE: BU Limps, SB flats, BB checks

Post: SB Checks, BB Checks, BU Bets, SB Folds, BB Folds

Basically want to count the times the SB and BB folds post to a bet from the orginal limper, and then also the oppurtunities they have to fold.

Is this possible?

Thanks

[kraada]

Yes, you can do it but you'd want to do it differently.

For times facing a bet from the first preflop limper I'd use:

sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 and tourney_hand_player_statistics.amt_f_bet_facing > 0 and substring(tourney_hand_summary.str_actors_p from 1 for 1)::int = substring(tourney_hand_summary.str_aggressors_f from 1 for 1)::int, 1, 0])

and then for folds:

sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 and tourney_hand_player_statistics.amt_f_bet_facing > 0 and substring(tourney_hand_summary.str_actors_p from 1 for 1)::int = substring(tourney_hand_summary.str_aggressors_f from 1 for 1)::int and lookup_actions_f.action SIMILAR TO '(F|XF)', 1, 0])

[TapDancingSquid]

Thanks.

I've only ever constructed stats from a Heads Up perspective so this is pretty complicated for me I'm also trying to construct the stats to contain Turn Barrel, River Barrel, and Raise the initial bet from the original limper.

The ones I've made before have all been for HU

lookup_actions_p.action = 'C' AND lookup_positions.flg_sb AND lookup_actions_f.action = 'X' AND lookup_actions_t.action LIKE 'B%'

^^ For example I've used this lots to make a delay cb stat here for HU

Obviously using it your way is no problem but I have no idea how to now construct the other stats in that format. Can you set it up the way I was doing it before or because it's 3 handed it becomes too complex?