How to create: Pre-Flop All-in Stat for HUD?

[kakmic]

Hi.
I've spend plenty of time to find this one in "custom stats" section but unsuccesful. I apologize if I missed that.
How can I create this stat: "Pre-Flop All-in" for HUD statistics.
There is lots of players who play shortstack and they use to go all-in very often. I would like to have some stats that can show their range of hands. I belive "pre-flop allin times / out of hands played" will give me the stats I'm looking for, but don't know how to set it up correctly.
Any help much appreciated. Thank you.

[WhiteRider]

It sounds like you want this for cash tables ("There is lots of players who play shortstack and they use to go all-in very often.") so you'll want these columns (in the Holdem Cash Player Statistics section):

cnt_p_allin =
sum(if[holdem_hand_player_statistics.enum_allin = 'P', 1, 0])

cnt_p_acted =
sum( if[ NOT lookup_actions_p.action='', 1, 0 ] )

If it's for tournaments then you would use the Holdem Tournament Player Statistics section and the cnt_p_allin column would be this:
sum(if[tourney_holdem_hand_player_statistics.enum_allin = 'P', 1, 0])

Then build a stat:
All-In Preflop =
(cnt_p_allin / cnt_p_acted) * 100

See the Tutorial: Custom Reports and Statistics for a walkthrough of how to build a stat from these expressions.

[marvin]

sum( if[ NOT lookup_actions_p.action='', 1, 0 ] )
counts the times that the villain has the opportunity of something?
example, about this action preflop in hu: villain (SB) call, BB raise, villain 3bet, BB 4bet, villain goes all-in.

THEN....
sum( if[ NOT lookup_actions_p.action='', 1, 0 ] ) = 3?

sum(if[holdem_hand_player_statistics.enum_allin = 'P', 1, 0]) = 1?

[WhiteRider]

The column has a value for each player, so it depends who you are looking at.
For each hand the IF statement will be either 1 or 0 depending on whether the statement is true or false. The SUM then adds up the 1s and 0s to get a count of the number of hands where the condition was true.

In your example the columns will have either 1 or 0 value (because there is only one hand).
For villain both values will be 1 (because the condition in both columns is true for that hand).
For all other players the first column will be 1 (because they made an action), but the second column will be zero (unless BB gets all-in too with his 4-bet).

[kakmic]

Thank you very much. Looks like it works but how can I round the amount to decimal numbers becuase I'm having resluts like: 6.0030402 which looks very bad in HUD.

[WhiteRider]

Fill in the Format tab.
If you use:
/%.2f
..in the Format Expression it will display to that many decimal places in reports, and you can change the decimal places in the Statistic Properties.

[marvin]

sum( if[ NOT lookup_actions_p.action='', 1, 0 ] )
then is like (#hands played) - (#played and all fold to the villain that is BB)
(refered to count about villain).
is right?

[WhiteRider]

sum( if[ NOT lookup_actions_p.action='', 1, 0 ] )
then is like (#hands played) - (#played and all fold to the villain that is BB)
(refered to count about villain).
is right?

Yes, exactly right.
You only have an opportunity to go all-in if you have chance to act.

[kakmic]

Thank you very much WhiteRider. Thats what I was looking for.

[longfields]

Hi guys,

I'm new here, thanks to everyone for all this information - amazing.

I think I've followed the instructions above, but when I add the new stat to a report and run it, nothing appears (I'm doing this for tourneys, btw). Any ideas what I may be doing wrong?

Thanks again.