open push stat

[joker]

Hi,

it is possible to create a hud stat that shows how often player openpush for ex. from sb to bb ?

[kraada]

Yes, it is. I created a few stats like this for the tournament version of my HUD, which may be useful to look at. Otherwise, I'd recommend reading the Tutorial: Using Custom Reports and Statistics for more on how to create custom statistics.

[joker]

i found this expression in your tournament push stat : tourney_holdem_hand_player_statistics.enum_allin = 'P'

does exist the same expression for cash game named: cash_holdem_hand_player_statistics.enum_allin = 'P' ? If yes, than I will have to just add it to the columns in "att to steal from sb" stat and I should have stat I want, am I right ?

[kraada]

holdem_hand_player_statistics.enum_allin = 'P' is what you want for cash games, for tournies you want tourney_holdem_hand_player_statistics.enum_allin = 'P', and yes you can just add that to flg_steal_att in the column definition (you'll want to make a new column) and then filter to blinds but that should be all you need to do.

[joker]

I created this stat :

(cnt_steal_att_sb_push / cnt_steal_opp_sb_push) * 100

with these columns :

cnt_steal_att_sb_push:
SUM(if[holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.enum_allin = 'P' AND holdem_hand_player_statistics.position = 9,1,0])

cnt_steal_opp_sb_push:
SUM(if[holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.enum_allin = 'P' AND holdem_hand_player_statistics.position = 9,1,0])

but it looks like that I did something wrong, because It shows me really weird numbers. Can you pls help me with building this stat ?

[WhiteRider]

You need to remove the check for going all-in preflop from your 'opportunities' column.

cnt_steal_opp_sb_push:
SUM(if[holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.position = 9,1,0])

..which really makes is just cnt_sb_steal_opp (since you are checking for steal opportunites from the SB, and you always have an opportunity to go all in).

[joker]

Thank you.

My next question is about positional 3 bet stats. I already have 3bet from position stat, but it will be also great to have stat showing 3bet vs position, like 3 bet vs utg raise. It si possible to create somethink like this ?

[WhiteRider]

Unfortunately you can't build those kind of stats accurately as there is no way of knowing the position of the open raiser in all cases.
What we do have is "holdem_hand_player_detail.val_p_raise_aggressor_pos" which records the position of the last player to raise, other than the active player - so this will work for you as long as there is only one other raiser but not if someone else gets involved.

For example: let's say we're looking at 3-bets by player X..
If A open-raises UTG and X 3-bets and everyone folds except A; then the preflop aggressor position (PFA) will be A's position (UTG) whether A folds, calls or raises.
If A open-raises UTG and X 3-bets but then B 4-bets and A folds then the PFA position will be B's position (because they were the last player to raise).

So - you can build an accurate 3-bet vs position stat if the 3-bet is the last bet, but of course that will be incomplete.

[joker]

Hi,

I had to create this stat again and when I was checking if it shows right values and I it seems that this stat shows not only openshoves, but also counts situations when sb raises, bb 3bets all in and sb calls. Can you help me with adding another condition like "sb not facing raise" to improve this statistic?

Thank you.

[kraada]

You could add not(holdem_hand_player_statistics.flg_p_3bet_def_opp) to remove all times you faced a 3bet (or flg_p_4bet_def_opp to remove 4bet defenses).