probe and delay stats for limped pots

[ZimZalabim]

Hey, I'm lost in trying to create stats for the following actions in heads up tournaments:
- Probe turn in limp pots
- Fold vs probe in limp pots
- Delay CB in limp pots
- Fold vs delay CB in limp pots

I have been trying some tips and expressions from old pt3 threads, but my expressions are invalid ("The statement is not valid SQL")

[kraada]

Nobody raised preflop so there's nobody who can make a continuation bet. Since Probe is also defined in relation to the preflop aggressor's actions again that's not going to make sense.

[ZimZalabim]

Well, maybe the names doesn't make perfect sense, but since there is no name for the lines, I choose what gives the most sense and doesn't take 12 words to describe the action.
These lines are crucial in HT HUSNG where limping becomes more and more common, and I would really appreciate any help with getting those stats on my HUD

[4StarGen]

you should post the expressions first, IMO

[kraada]

Then in order to help you we'll need to know what you're trying to build in more detail.

[ZimZalabim]

Ok, so here are the actions in order:
"Delay CB in limped pot": SB limps preflop, BB checks. BB checks flop, SB also checks. BB checks turn, SB bets.
"Probe turn in limped pot": SB limps preflop, BB checks. BB checks flop, SB also checks. BB bets turn.
So that is the aggressive actions. I'm also trying to build the stats that shows how often a player folds vs those actions.

-----------------

I don't know if it helps, but here are custom stats and columns for what many call "fold vs limp cb":

Action: SB call preflop, BB check. BB check flop, SB bets, BB folds.

Stat: (cnt_f_limpcbet_def_action_fold / cnt_f_face_limpcbet) * 100

Columns:
cnt_f_limpcbet_def_action_fold:
sum(if[lookup_positions.flg_bb AND NOT (tourney_hand_player_statistics.flg_p_face_raise) AND tourney_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO 'XF'), 1, 0])

cnt_f_face_limpcbet:
sum(if[lookup_positions.flg_bb AND NOT (tourney_hand_player_statistics.flg_p_face_raise) AND tourney_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

[kraada]

Two things:

(1) You can't use lookup_positions.flg_bb and have your stat compatible with our cache. Instead use tourney_hand_player_statistics.position = 8. Position 8 is always the big blind and position 9 is always the small blind).

(2) You don't rule out times the BB raises a limp and gets called - he won't face a raise preflop then, and the postflop situation is independent of preflop action as you've defined it. Adding in not(tourney_hand_player_statistics.flg_f_cbet_opp) will eliminate this case because if you raised preflop and were called you'd have a chance to cbet.

[dave2085]

i tried to build this stat:
"Probe turn in limped pot": SB limps preflop, BB checks. BB checks flop, SB also checks. BB bets turn.


this stat should count all situations when the BB checksback and other player limped in Position (only hu pots)

in HU: sb limps, bb checks, BB checks F, SB checks F, BB bets("probe") T

in 3handed: BU limps, bb checks, bb checks F, BU checks F, BB bets("probe") T


is this correct?

[Flag_Hippo]

That's fine except you need to change tourney_hand_summary.cnt_players = 2 to tourney_hand_summary.cnt_players_f = 2. Doing that means the stat will now count 3+ handed hands as well as HU hands and you won't get multiway limped pots.

[dave2085]

I build this stat today for Headsup Only: "Fold to T Probe (limp pot)"

2player dealt into hand,
Preflop: SB limps, BB checks
Flop: BB checks, SB checks behind
Turn: BB bets, SB folds

Is this correct?

here are the columns:

Code: Select all

sum(if[cash_hand_player_statistics.cnt_players = 2
and cash_hand_player_statistics.flg_p_limp
AND NOT(cash_hand_player_statistics.flg_p_face_raise)
AND cash_hand_player_statistics.amt_t_bet_facing > 0
and lookup_actions_f.action = 'X'
and not(cash_hand_player_statistics.flg_t_open_opp)
and lookup_actions_t.action = 'F', 1, 0])

divided by

Code: Select all

sum(if[cash_hand_player_statistics.cnt_players = 2
and cash_hand_player_statistics.flg_p_limp
AND NOT(cash_hand_player_statistics.flg_p_face_raise)
AND cash_hand_player_statistics.amt_t_bet_facing > 0
and lookup_actions_f.action = 'X'
and not(cash_hand_player_statistics.flg_t_open_opp) , 1, 0])

first stat i build this way, and want to be sure thats correct, thanks!