Cbet Flop in Limped Pot BU vs BB

[nemonik]

Hi! I am trying to make a stat for spin&go that indicates he times that button does cbet againts bb in a limped pot. This is my code:
cnt_bu_v_bb_f_cbet_limped_pot

Code: Select all

sum(if[tourney_hand_summary.str_actors_p LIKE '0' AND tourney_hand_player_statistics.flg_f_open,1,0])

cnt_bu_v_bb_f_cbet_limped_pot_opp

Code: Select all

sum(if[tourney_hand_summary.str_actors_p LIKE '0' AND  tourney_hand_player_statistics.flg_f_open_opp,1,0])

Stat

Code: Select all

(cnt_bu_v_bb_f_cbet_limped_pot / cnt_bu_v_bb_f_cbet_limped_pot_opp) * 100

If the only actor preflop is button we are indicating that it is a limped pot between bu and bb, right?

It's not working.
Thanks.

[Flag_Hippo]

You need to specify that you want the bets and opportunities counted for the BTN only by adding tourney_hand_player_statistics.position = 0.

[nemonik]

I have selected that option in "Item Properties" "Position Button(BTN)"
Would this work?

[Flag_Hippo]

Yes that is fine. If the stat is not working as you originally mentioned can you please give more specific details on what the problem is.

[nemonik]

In this hand it takes the value "100(1/1)" and it's not a limped pot:

PokerStars - 10/20 NL (3 max) - Holdem - 3 players
Hand converted by PokerTracker 4

SB: 25.5 BB (VPIP: 53.19, PFR: 40.12, 3Bet Preflop: 14.29, Hands: 207)
Hero (BB): 24 BB
BTN: 25.5 BB (VPIP: 66.67, PFR: 33.33, 3Bet Preflop: 0.00, Hands: 3)

SB posts SB 0.5 BB, Hero posts BB 1 BB

Pre Flop: (pot: 1.5 BB) Hero has Q 6

BTN raises to 2 BB, fold, Hero calls 1 BB

Flop: (4.5 BB, 2 players) 9 7 4
Hero checks, BTN bets 3 BB, Hero calls 3 BB

Turn: (10.5 BB, 2 players) Q
Hero checks, BTN bets 6 BB, Hero calls 6 BB

River: (22.5 BB, 2 players) 2
Hero checks, BTN checks

Hero shows Q 6 (One Pair, Queens)
(Pre 62%, Flop 46%, Turn 70%)
BTN mucks 9 3 (One Pair, Nines)
(Pre 38%, Flop 54%, Turn 30%)
Hero wins 22.5 BB

[Flag_Hippo]

Ah yes - the actors string records the positions of the players who VPIP'd so tourney_hand_summary.str_actors_p LIKE '0' means that the BTN raised or called. You can specify a limped pot with this:

Code: Select all

char_length(tourney_hand_summary.str_aggressors_p) = 1

This says that there was only one aggressive action preflop (the BB being posted is effectively the first bet preflop).

[nemonik]

But we are saying that there is only one actor preflop (Button), if BB 'Calls' , would not he become an actor and cease to fulfill the condition?

[Flag_Hippo]

The expression is working fine for me so can you please attach the unformatted hand here, via PM or in a Support Ticket.

[nemonik]

It's working for me too with the new condition but i want understand how it works. If the actors string records the positions of players who put money in (voluntarily) in order, when Button 2bet and BB calls, would not be equal to '08'? and would "tourney_hand_summary.str_actors_p LIKE '0'" be false?

[Flag_Hippo]

If the actors string records the positions of players who put money in (voluntarily) in order, when Button 2bet and BB calls, would not be equal to '08'? and would "tourney_hand_summary.str_actors_p LIKE '0'" be false?

Yes tourney_hand_summary.str_actors_p LIKE '08' would be correct for the actors string in this case but I've tested the expressions and they are working fine for me meaning I do not see any hands like this one using tourney_hand_summary.str_actors_p LIKE '0' so can you please attach the unformatted hand here, via PM or in a Support Ticket so we can test it.