help to make "4bet/fold to push" stat

[PokerOkk]

Hello people! )
I try all week to make "4bet/fold to push"stat , but it no works. I dont understand how to make it right. Help me plz.

[kraada]

Is this stat for preflop action only?

[PokerOkk]

Is this stat for preflop action only?

ohh sorry. yes, preflop only.

[kraada]

Create the following two columns:

cnt_p_4b_fold: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_folded = 'P', 1, 0])

cnt_p_4b_face_shove: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_face_allin = 'P', 1, 0])

Put the former over the latter in the statistic and multiply by 100 to get a percentage.

[skatemaza]

Put the former over the latter in the statistic and multiply by 100 to get a percentage.

what do you mean with that?
I do not understand what to do after creating the two columns

thx

greets Martin

[WhiteRider]

The Tutorial: Custom Reports and Statistics has a walkthrough of how to build a stat from column expressions.

[skatemaza]

Create the following two columns:

cnt_p_4b_fold: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_folded = 'P', 1, 0])

cnt_p_4b_face_shove: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_face_allin = 'P', 1, 0])

Put the former over the latter in the statistic and multiply by 100 to get a percentage.

can we include something, that the shove is bigger than 90bb for example?!

because 4bet/calling for 50bb is always a call


edit:

will try out this solution:

cnt_p_4b_face_shove: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_face_allin = 'P', 1, 0 AND holdem_hand_summary.amt_p_effective_stack>=80])

edit2: my solution did not work

[WhiteRider]

You would need to build your column like this:

cnt_p_4b_face_shove: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_face_allin = 'P' AND holdem_hand_summary.amt_p_effective_stack>=80, 1, 0])

Have a look at the Tutorial: Custom Reports and Statistics for how to construct column expressions.

You could also check for your own stack rather than the effective stack (which could be significantly smaller even if the short stack is not involved in the 4-bet action). That is stored in:
holdem_hand_player_detail.amt_before

That value is in monetary value, so you would need to divide by "holdem_limit.amt_bb" if you want the value in BB.

[skatemaza]

Hi,
I have made this stat and i think it works.
But i cannot see how many times a player folded to how many times this appears.

Example: should be: 40% (4/10)
but is: 40% ()

[kraada]

The Value Expression in the Stat needs to be pretty exactly formatted; you want: (a / b) * 100 in that order, where a and b are the columns you've built.