min3bet stat

[4StarGen]

I've tried to make a min3bet stat, it works most of the times but it doesn't capture the instances where the hands goes, open > 3bet > 4bet > 5bet.
I mean, it min3bettor 5bets, the instance won't be counted. How can I do that

Code: Select all

(cash_hand_player_statistics.amt_p_2bet_facing) /(cash_limit.amt_bb) <= 3 AND ((cash_hand_player_statistics.amt_p_raise_made) /(cash_hand_player_statistics.amt_p_2bet_facing)) <= 1.71

[Flag_Hippo]

I've tried to make a min3bet stat, it works most of the times

Please note that cash_hand_player_statistics.amt_p_2bet_facing is the amount the player needs to call (not the total 2bet size made by the other player) so you would need to account for money already invested e.g. blinds. To do that whether the players are in the blinds or not you would need to use:

Code: Select all

cash_hand_player_statistics.amt_p_2bet_facing > 0 and ((cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind) /cash_limit.amt_bb) <= x

Code: Select all

cash_hand_player_statistics.flg_p_3bet and (cash_hand_player_statistics.amt_p_raise_made /(cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind)) <= x

but it doesn't capture the instances where the hands goes, open > 3bet > 4bet > 5bet.
I mean, it min3bettor 5bets, the instance won't be counted.

Do you have an example hand history? I don't see anything here that would prevent this being counted.

[4StarGen]

so you would need to account for money already invested e.g. blinds
cash_hand_player_statistics.amt_p_2bet_facing > 0 and ((cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind) /cash_limit.amt_bb) <= x

sorry, I don't understand, the expression you have posted will be different when the player is not on the blinds right?

Do you have an example hand history? I don't see anything here that would prevent this being counted.

4bet+ are counted as well

I've made a hand stat, using the a custom column

Code: Select all

(cash_hand_player_statistics.amt_p_raise_made)/(cash_hand_player_statistics.amt_p_2bet_facing + cash_limit.amt_bb )

In the hand below, the column shows 20 which shouldn't be the case since it was a 4b

Code: Select all

Bodog.com Hand #4346609086 TBL#27634639 HOLDEM No Limit - 2022-09-21 04:49:41
Table Info: Version: 1, Type: Ignition, Stakes: $0.50-$1
Seat 1: Big Blind ($289.76 in chips)
Seat 2: UTG ($99.50 in chips)
Seat 3: UTG+1 [ME] ($133.19 in chips)
Seat 4: UTG+2 ($29.91 in chips)
Seat 5: Dealer ($280.64 in chips)
Seat 6: Small Blind ($30.50 in chips)
Dealer : Set dealer [5]
Player Info: Seat1: P1-b289668937e3094d76d8a739e8cd1c6b, Seat2: P2-9c22f718f9d78459bc5680a556b88e2e, Seat4: P4-f662681fc25e2890aa16875a16c6f725, Seat5: P5-afca0d43db8b0fa31ebeeb71b8aeeef9, Seat6: P6-8a04d12e31564c0bb5cc3a37b1ece56c
Small Blind : Small Blind $0.50
Big Blind : Big blind $1
*** HOLE CARDS ***
Big Blind : Card dealt to a spot [Jc Qc]
UTG : Card dealt to a spot [9d 5d]
UTG+1  [ME] : Card dealt to a spot [4s 7d]
UTG+2 : Card dealt to a spot [Ad Qs]
Dealer : Card dealt to a spot [Kd Qd]
Small Blind : Card dealt to a spot [3d Ts]
UTG : Folds
UTG+1  [ME] : Folds
UTG+2 : Raises $4 to $4
Dealer : Raises $12 to $12
Small Blind : Raises $19.50 to $20
Big Blind : Folds
UTG+2 : All-in(raise) $25.91 to $29.91
Dealer : Folds
Small Blind : Calls $9.91
*** FLOP *** [8c 9s 2s]
*** TURN *** [8c 9s 2s] [8h]
*** RIVER *** [8c 9s 2s 8h] [3s]
UTG+2 : Showdown [8h 8c Ad Qs 9s] (One pair)
Small Blind : Showdown [8h 8c 3s 3d Ts] (Two pair)
Small Blind : Hand result $69.18
UTG+2 : Seat sit out
*** SUMMARY ***
Total Pot($72.82)
Board [8c 9s 2s 8h 3s]
Seat+1: Big Blind Folded before the FLOP
Seat+2: UTG Folded before the FLOP
Seat+3: UTG+1 Folded before the FLOP
Seat+4: UTG+2 lost with One pair [Ad Qs-8h 8c Ad Qs 9s]
Seat+5: Dealer Folded before the FLOP
Seat+6: Small Blind $69.18  with Two pair [3d Ts-8h 8c 3s 3d Ts]


[Flag_Hippo]

sorry, I don't understand, the expression you have posted will be different when the player is not on the blinds right?

No it will be the same. cash_hand_player_statistics.amt_blind is the blind amount posted by and if the player isn't in the blinds then cash_hand_player_statistics.amt_blind for that player will be zero.

I've made a hand stat, using the a custom column

Code: Select all

(cash_hand_player_statistics.amt_p_raise_made)/(cash_hand_player_statistics.amt_p_2bet_facing + cash_limit.amt_bb )

In the hand below, the column shows 20 which shouldn't be the case since it was a 4b

cash_hand_player_statistics.amt_p_raise_made for the small blind will be equal to the size of their 4Bet since that was their first preflop raise:

(20 / 0 + 1) = 20

If you don't want that counted you need to add cash_hand_player_statistics.flg_p_3bet which I included in my original reply.

[4StarGen]

Wonderful help, as usual

[Flag_Hippo]

You're welcome :)