Question about custom stat

[jaxx]

Hello,

Is it possible to make a tourney stat 'Average Open raise size (in bb) for the last N blind levels'?

Thanks

[kraada]

The "last N blind levels" part is the difficult part. If you play all SnGs with a standard structure it's vaguely possible that it'd be doable, but we'd need the complete blind structure for the event and it would still be quite complicated.

[jaxx]

Ok. What about stat - 'average open raise size in BB' ? (without - last n hands)

[WhiteRider]

Yes, that's pretty easy.
You'll need a new column to add up the total amount bet as open-raises:

amt_p_open_raise_ttl_bb =
sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open, (holdem_hand_player_detail.amt_p_raise_made / holdem_limit.amt_bb), 0])

..then we can create a new stat to divide that column by the number of open raises, which is the built-in column cnt_p_raise_first_in, so the stat expression would be:

amt_p_open_raise_ttl_bb / cnt_p_raise_first_in

Tutorial - Custom Reports and Statistics

[jaxx]

I need the statistic for tournaments

is this ok:

sum( if[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open, (tourney_holdem_hand_player_detail.amt_p_raise_made / tourney_holdem_blinds.amt_bb), 0])

is tourney_holdem_blinds what I need instead of holdem_limit?

[kraada]

Yes, that should work.

[jaxx]

Thanks. Another question: Is there a way a given statistic (or all statistics) to use data only from the last X thousand hands for the given player? or only from the last 3 months? or something like this

[kraada]

Yes. Click Configure --> Configure HUD, go to the Hud Options tab and use the Last X hands option there. Note though that this will slow things down so if you have a large database you may experience nontrivial amounts of lag (queries done in this way take a lot longer to complete).

[jaxx]

Thanks
another question:
how can we exclude the all-in bets from the stat above?

[WhiteRider]

One way to do it would be to check for:
holdem_hand_player_statistics.enum_allin != 'P'
..which says the player didn't go all-in preflop.

However, that would also rule out hands where the player open-raised but not all-in, then re-raised all-in.
To just avoid all-in first raises you could check for:
tourney_holdem_hand_player_detail.amt_before != tourney_holdem_hand_player_detail.amt_p_raise_made
..which says that the amount of chips the player had before the hand does not match the size of their first raise.