Custom Stat Help

[antneye]

anteye - if you want to check for exactly bet/call and rule out bet/raise/call (and for the other combinations) then using the actions strings as kraada suggests will get you what you want. That is the approach I would use.

mannue - please bear with us as we catch up with the tickets; we've had a large volume of support requests with the expansion of the PT4 beta program and we're not quite back on top of the tickets yet. If you post your ticket number here I'll check it's in the right place.

Thanks for all of the help guys. I've managed to totally recreate my HEM pop-up that I really depend on as a LHE player. One last Q and I will let this thread die. I used the action string for the Bet/Call line, but what are the other action strings? I don't know where I would look to find the possible strings. I would like to modify the other lines as well.

[WhiteRider]

Action strings are made up of characters which represent each action.

X = check
F = fold
C = call
B = bet
R = raise

The actions string can be any combination of these, depending on what actions the player took.

Check out string expressions and pattern matching in this tutorial for more information on working with these strings.

[skatemaza]

Hi, I wanna create a 4bet/fold stat using your columns Kradaa. But it doesnt work

I created:

cnt_p_5bet_def_action_fold_after_4b:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.position = substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and cash_hand_player_statistics.flg_p_fold, 1, 0])

cnt_p_5bet_def_opp_after_4b:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.position = substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and cash_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

the statistic "4bet/fold":
(cnt_p_5bet_def_action_fold_after_4b / cnt_p_5bet_def_opp_after_4b) * 100

As a result I got this:



There seems something is not ok with the oppertunities. It doesnt count the opertunities correctly...

So it isnt working at me too like at OP.
What is there wrong?

[kraada]

Try:

cnt_p_5bet_def_opp_after_4b:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 5 and cash_hand_player_statistics.position = substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int, 1, 0])

and see if that works better - it's not perfect but this will give us a good place to start.

[skatemaza]

works better. 27 times of 42 opportunities. Are these all opportunities?

What does this exaclty include?

[kraada]

That includes all hands where you made a 4bet and someone made a 5bet. If your 4bet was a shove you wouldn't have a chance to raise again but otherwise they would be opportunities. I will need to think about how to eliminate 4bet shoves but still leave 6bet shoves in - it's a bit tricky due to the way we store raise size data. If you're fairly certain that your 4bets won't be shoves then this will work properly for you as is though.

[skatemaza]

I dont really got it.

different cases:

normal case: I 4bet (not all in), somebody 5bets -> counts!
all in case: I 4betpush, someone raises over my push -> counts?
6bet case: I 4bet, someone 5bets, another guy 6bets -> counts?

did i miss other cases?

And another thing:

The value for all stakes summarized is 100.00. This is not working correctly.

If I had a Value of 75% at NL50 and 25% at NL25 with same samplesize it should show me 50% isnt it?
So why does it shows me here 100%
Have set the format and summary type to percentage.

[kraada]

All 3 of your cases count - the all-in case is the problem, it gives you an extra (missed) opportunity where it shouldn't.

About the summary value - check the summary type for your columns and make sure they're set to Sum not Count.

[skatemaza]

Another question:

I want to create a statistic that shows me how often someone is 4betting after trying to steal the blinds.

Therefore I created a new column:

cnt_p_stealThen4bet:

sum(if[cash_hand_player_statistics.flg_p_4bet AND cash_hand_player_statistics.flg_steal_att, 1, 0])

The statistic is:

4bet after Steal:

(cnt_p_stealThen4bet / cnt_steal_reraise_def_opp) * 100


Have I done it correctly?

[kraada]

That should work yes.