by unfortunately, I wasn’t able to put together my call shove statistic, so I’d like to ask for some help. I’ve read through all the related threads, but I still couldn’t get it to work. I set the positions on the HUD interface.
The statistic I’d like to create is the following:
The player did not limp and did not open-raise, but called an all-in or re-raised an all-in — in other words, the player cold-called or cold 4-bet shoved against an all-in.
- Code: Select all
(cnt_p_ai_call / cnt_p_ai_opp) * 100
cnt_p_ai_call:
- Code: Select all
sum(
if[
tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'
AND NOT (tourney_hand_player_statistics.flg_p_limp)
AND NOT (tourney_hand_player_statistics.flg_p_first_raise)
AND (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'R'),
1, 0]
)
cnt_p_ai_opp:
- Code: Select all
sum(
if[
tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'
AND NOT (tourney_hand_player_statistics.flg_p_limp)
AND NOT (tourney_hand_player_statistics.flg_p_first_raise),
1, 0]
)
Example hands:
The database is new, one is the second hand, the other is the fifth hand.
#1:
It shows zero for the positional call when the player limped from the BTN and folded to an all-in, even though it shouldn’t be counting that situation..
PokerStars - 10/20 NL (3 max) - Holdem - 3 players
Hand converted by PokerTracker 4: http://www.pokertracker.com
SB: 20 BB (VPIP: 100.00, PFR: 0.00, 3Bet Preflop: 0.00, Hands: 2)
Hero (BB): 24.5 BB
BTN: 30.5 BB (VPIP: 100.00, PFR: 100.00, 3Bet Preflop: -, Hands: 2)
SB posts SB 0.5 BB, Hero posts BB 1 BB
Pre Flop: (pot: 1.5 BB) Hero has 2s 2c
BTN calls 1 BB, SB raises to 20 BB and is all-in, fold, fold
SB wins 3 BB
#2:
It counts the situation here, but still shows zero, even though it should be 100 since this was a button position call.
And if I add the following lines to the two codes above, it doesn’t even show zero, it simply doesn’t count it at all.
- Code: Select all
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 20
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) < 30,
PokerStars - 15/30 NL (3 max) - Holdem - 3 players
Hand converted by PokerTracker 4: http://www.pokertracker.com
BB: 14.67 BB (VPIP: 75.00, PFR: 25.00, 3Bet Preflop: 0.00, Hands: 4)
Hero (BTN): 14.33 BB
SB: 21 BB (VPIP: 75.00, PFR: 50.00, 3Bet Preflop: -, Hands: 4)
SB posts SB 0.5 BB, BB posts BB 1 BB
Pre Flop: (pot: 1.5 BB) Hero has 4s As
Hero raises to 14.33 BB and is all-in, SB raises to 21 BB and is all-in, fold
Flop : (29.67 BB, 2 players) 9s 9d 9h
Turn : (29.67 BB, 2 players) 3d
River : (29.67 BB, 2 players) 5h
SB shows Qh Kc (Three of a Kind, Nines)
(Pre 39%, Flop 27%, Turn 17%)
Hero shows 4s As (Three of a Kind, Nines)
(Pre 61%, Flop 73%, Turn 83%)
Hero wins 29.67 BB
