Constructing a Limp CBet Stat

[kraada]

substring(tourney_hand_summary.str_actors_p from 1 for 1)::int = substring(tourney_hand_summary.str_aggressors_f from 1 for 1)::int is the piece that specifies the first limper is the first aggressor on the flop. For multi-handed play it really is the best way to go since you can't rely on other flags to do this work - when the person was raising, you can check for cbet defenses, but here you can't do that.

[TapDancingSquid]

Pretty sure I made a mistake with all my stats then in min raise pot post flop

tourney_hand_player_statistics.flg_f_cbet AND tourney_hand_summary.cnt_players = 3


Used that for cbetting in MR pot


tourney_hand_player_statistics.flg_f_cbet_opp AND tourney_hand_summary.cnt_players = 3

And that for the oppurtunity.

Is there anyway to get a training session on how to make these type of stats?

[kraada]

When there's a raise things are different - a cbet is a special kind of bet that is only possible when you're the last preflop raiser. There is no such thing as a cbet when you limp because you're not "continuing" anything.

[TapDancingSquid]

Thanks again, figured it all out except for this last stat.

Check Raise on the flop in a limped pot where the original limper bet the flop 3 handed.

[WhiteRider]

What do you have so far? Is there a specific part you're stuck on?

[TapDancingSquid]

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 '(XR)'


^^ That for the the times he check raises



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

^^ That for oppurtunities

[TapDancingSquid]

Also is there an expression I can put for raise but not all in?

AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb > 6

^^ For example that but also another expression to say not all in.

[TapDancingSquid]

Also making a flatting stat preflop. This wasn't working for me for the SB flatting a Steal from the BU

lookup_actions_p.action = 'C' AND tourney_hand_summary.cnt_players = 3 and tourney_hand_player_statistics.position = 9 AND amt_p_2bet_facing / tourney_blinds.amt_bb <= 3.5 AND NOT(tourney_hand_player_statistics.flg_p_open_opp)

This didn't work for me because it still included the hands when the BU limps and the SB completes, which makes sense but I'm not sure what expression I need to add to represent that the BU raised to enter the pot.

[kraada]

You lost the % - lookup_actions_f.action SIMILAR TO '(XR)' means only check/raise and no further action. That may well be most check/raises but lookup_actions_f.action SIMILAR TO '(XR)%' covers everything.

Since you're looking at flop actions by definition the preflop action can't be all in or there would be no flop actions at all.

You don't need a custom stat for SB vs BTN steal - use Call vs Button Open and set the position to SB and you'll have what you want.

[TapDancingSquid]

Since you're looking at flop actions by definition the preflop action can't be all in or there would be no flop actions at all.

The stat I was talking about there was a preflop one. Limp fold to NAI raise but I wanted to make it so the NAI raise wasn't all in so far I have this.

sum(if[tourney_hand_player_statistics.flg_p_limp and tourney_hand_player_statistics.position = 9 AND tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action = 'CF' AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb < 6 AND tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb BETWEEN 20 AND 25, 1, 0])

Need it to be under 6bb but not all in.

Hope I explained that ok.