3bet Sizing Stat

[tobakudan]

I have a HU preflop 3bet sizing stat where the numerator seems to be misbehaving. The denominator is just the number of opportunities so it's not important (and I checked that it's not the one acting strangely). It is intended to find the 3bet size as a multiple of the total amount the previous raiser put in the pot (including his small blind). In the problem hand below, it should be returning a value of 3 but instead gives 7.25807... I tried to figure out how this number was even derived but couldn't figure it out. Here is the numerator column:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' AND tourney_hand_player_statistics.amt_p_effective_stack >= 9 * tourney_blinds.amt_bb, tourney_hand_player_statistics.amt_p_raise_made / (tourney_hand_player_statistics.amt_p_raise_facing + tourney_blinds.amt_bb), 0])

Here is the hand history that it acts strangely on:

Code: Select all

PokerStars Hand #164388073176: Tournament #1788410026, $6.71+$0.29 USD Omaha Pot Limit - Match Round I, Level IV (25/50) - 2017/01/11 16:35:37 JST [2017/01/11 2:35:37 ET]
Table '1788410026 1' 2-max Seat #1 is the button
Seat 1: tobakudan (2538 in chips)
Seat 2: BzNzSBoomN (462 in chips)
tobakudan: posts small blind 25
BzNzSBoomN: posts big blind 50
*** HOLE CARDS ***
Dealt to tobakudan [Td 7d 3h 9h]
tobakudan: raises 100 to 150
BzNzSBoomN: raises 300 to 450
tobakudan: raises 300 to 750
BzNzSBoomN: calls 12 and is all-in
Uncalled bet (288) returned to tobakudan
*** FLOP *** [Jc Jh 3s]
*** TURN *** [Jc Jh 3s] [4h]
*** RIVER *** [Jc Jh 3s 4h] [5d]
*** SHOW DOWN ***
BzNzSBoomN: shows [4d Qh Qd 6h] (two pair, Queens and Jacks)
tobakudan: shows [Td 7d 3h 9h] (two pair, Jacks and Threes)
BzNzSBoomN collected 924 from pot
*** SUMMARY ***
Total pot 924 | Rake 0
Board [Jc Jh 3s 4h 5d]
Seat 1: tobakudan (button) (small blind) showed [Td 7d 3h 9h] and lost with two pair, Jacks and Threes
Seat 2: BzNzSBoomN (big blind) showed [4d Qh Qd 6h] and won (924) with two pair, Queens and Jacks

[WhiteRider]

I believe that the issue with this hand is that amt_p_raise_facing is the last raise faced not the first.
If you always want the size of the 2bet faced (which it looks like you do since you're testing for facing a steal) you can use tourney_hand_player_statistics.amt_p_2bet_facing (instead of tourney_hand_player_statistics.amt_p_raise_facing).

[tobakudan]

Yeah that sounds like just what I needed. Thanks!