Pot bet stat

[kingreigns]

What if i just done this, the expression for cnt_f_overbet is:
sum(if[cash_hand_player_statistics.val_f_bet_made_pct > 100, 1, 0])

so if i just change the greater than sign after percent to equals and have this
sum(if[cash_hand_player_statistics.val_f_bet_made_pct = 100, 1, 0])


What will the expression for the other colums be? Say i duplicate cnt_f_ovgerbet_opp, what do i adjust here?
sum(if[cash_hand_player_statistics.flg_f_open_opp and cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f, 1, 0])

When i made the overbet stat i just copied and pasted in the info that kraada gave me, he wrote this:
"for cnt_f_overbet: sum(if[cash_hand_player_statistics.val_f_bet_made_pct > 100, 1, 0])
for cnt_f_overbet_opp: sum(if[cash_hand_player_statistics.flg_f_open_opp and cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f, 1, 0])

We need a specific opportunity column to catch those cases where the effective stack is less than the size of the pot.

To make turn and river versions change _f_ to _t_ and _r_ and to make a total just add all of the various columns up."


And once i had that i just change the ltter to make each one fro different streets. Sorry about all this but i'm useless at making stats

[kingreigns]

How about this, cnt_f_potbet:
sum(if[cash_hand_player_statistics.val_f_bet_made_pct = 100, 1, 0]

cnt_f_potbet_opp:
sum(if[cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f, 1, 0])

[WhiteRider]

You're getting there now! I would suggest testing "cash_hand_player_statistics.amt_f_effective_stack >= cash_hand_summary.amt_pot_f" (greater than or equals) since you could make a pot size bet if the stack was the same as the pot.

Personally I would allow a little leeway, like testing "cash_hand_player_statistics.val_f_bet_made_pct BETWEEN 90 and 110", but if you want exact pot size bets you're there once you've made the above change.

[kingreigns]

I might make a separate stat so to for the between 90 and 110. The reason i wanted to make this stat is there seems to be plenty of players who potbet alot, be handy to know how often they do this.
So this is what i have now:
cnt_f_potbet
sum(if[cash_hand_player_statistics.val_f_bet_made_pct = 100, 1, 0])

cnt_f_potbet_opp
sum(if[cash_hand_player_statistics.amt_f_effective_stack >= cash_hand_summary.amt_pot_f, 1, 0])



Then i just duplicated the overbet stat, changed the name to potbet flop and put this in the value expression:
(cnt_f_potbet / cnt_f_potbet_opp) * 100

[kingreigns]

I put it on my Hud and then looked for someone who has done it a few times and looked at their hands to make sure it was working. and it looks like it is.
The player i was looking at when i went to player summary ,his name came up twice for two different limits, is that normal?Heres a photo

http://i.imgur.com/wM7hlMr.jpg

[kingreigns]

Just to check, i made ones for the turn and river by just changing anywhere the is an "f" to "t" and "r". So the turn ones are:
cnt_t_potbet_
sum(if[cash_hand_player_statistics.val_t_bet_made_pct = 100, 1, 0]

cnt_t_potbet_opp
sum(if[cash_hand_player_statistics.amt_t_effective_stack >= cash_hand_summary.amt_pot_f, 1, 0])

And the river one is:
cnt_r_potbet
sum(if[cash_hand_player_statistics.val_r_bet_made_pct = 100, 1, 0])

cnt_r_potbet_opp
sum(if[cash_hand_player_statistics.amt_r_effective_stack >= cash_hand_summary.amt_pot_f, 1, 0])

[kingreigns]

Would the fold to flop overbet stat i have also take a pot size bet into consideration or do i have to make a new one for that?
The expressions in the columns for fold to flop overbet is:
cnt_f_overbet_def_action_fold
sum(if[cash_hand_player_statistics.val_f_bet_facing_pct > 50 and cash_hand_player_statistics.cnt_f_call = 0 and cash_hand_player_statistics.cnt_f_raise = 0 and cash_hand_player_statistics.enum_folded = 'F', 1, 0])

cnt_f_overbet_def_opp
sum(if[cash_hand_player_statistics.val_f_bet_facing_pct > 50, 1, 0])

[WhiteRider]

Just to check, i made ones for the turn and river by just changing anywhere the is an "f" to "t" and "r". So the turn ones are:
cnt_t_potbet_
sum(if[cash_hand_player_statistics.val_t_bet_made_pct = 100, 1, 0]

cnt_t_potbet_opp
sum(if[cash_hand_player_statistics.amt_t_effective_stack >= cash_hand_summary.amt_pot_f, 1, 0])

And the river one is:
cnt_r_potbet
sum(if[cash_hand_player_statistics.val_r_bet_made_pct = 100, 1, 0])

cnt_r_potbet_opp
sum(if[cash_hand_player_statistics.amt_r_effective_stack >= cash_hand_summary.amt_pot_f, 1, 0])

You also need to change "amt_pot_f" to the turn or river version as appropriate by switching _f to _t or _r.

Would the fold to flop overbet stat i have also take a pot size bet into consideration or do i have to make a new one for that?
The expressions in the columns for fold to flop overbet is:
cnt_f_overbet_def_action_fold
sum(if[cash_hand_player_statistics.val_f_bet_facing_pct > 50 and cash_hand_player_statistics.cnt_f_call = 0 and cash_hand_player_statistics.cnt_f_raise = 0 and cash_hand_player_statistics.enum_folded = 'F', 1, 0])

cnt_f_overbet_def_opp
sum(if[cash_hand_player_statistics.val_f_bet_facing_pct > 50, 1, 0])

That looks fine.

[kingreigns]

Sweet thanks for pointing that out!!