PokerTracker

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.

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.

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?

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).

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.

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.

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?

marvin wrote: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.

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

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.