Custom Stat Help

[antneye]

Where can I go to figure out how to make a custom stat. I found some stats missing from the program that I use quite often in my hud as a LHE player so I would like to try to create them.

1) Bet/Fold,: By street, % of times villain bet and then folded to a raise. There are a ton of stats in the program but none that I can see for this basic scenario. Same for B/C and B/3!
2) Won at showdown after check raising a given street. Another one that I find to be important as a LHE player in gauging how string villain is when he C/R's depending on the street he is playing.

Edited to add more that I need but don't see and would like to create.

3) Check/Fold by street,
4)Check/Call by street

Maybe I am missing something because these seem like basic stats one would want to see in a hud. When villain checks, is he giving up? going into call down mode? for lhe these are big

[mannue]

would like to have an special stat too. But for NLH

Does anyone now how i could get to an stat, which shows me, the percentage oh 4b/f in a typical Reg Bu vs. Blinds battle.

Like Reg on Bu openraises, SB or BB 3bets, Bu 4bets small and i want an stat which shows me, how often he 4b/f in this spot.

Could be very usefull!

[kraada]

Anteye:

(1) How exactly do you want some of these stats to work? For example, for Bet/Call if you want how often you call the first raise given that you face one, that's Call 2Bet. You could make a custom statistic out of this which is more specific - Call 2Bet After Bet and restrict it to times you made the first bet.

(2) This statistic can be built and is definitely much more applicable to limit than no limit as you get to showdown much more in limit. The easiest place to start here would be with the check raise stats and duplicate the check raise column and use it to build two new versions - one for check raise and get to showdown, one for check raise and win at showdown (see WSD for how those work), then use those two new columns to build your stat.

(3 & 4) There are Fold to <Street> Bet stats which are probably the closest default statistic that you would want. If you're facing a bet and a raise cold that's different enough you might in fact prefer it split out. There are also Call <street> Bet stats which is for calling the bet on a given street. You can't exactly force a check but you can set the statistic to be out of position in the Item Properties which may be close enough for your purposes.

mannue:

You could use Fold to PF 4Bet After 3Bet set to the specific positions you want in late - those are going to be mostly filled with the data you're looking for.

[mannue]

You could use Fold to PF 4Bet After 3Bet set to the specific positions you want in late - those are going to be mostly filled with the data you're looking for.

No I´m looking for "Fold to Preflop 5bet after 4betting from BU "

[kraada]

Then what you want to build is fold to 5bet after 4betting - then set it to button in the HUD.

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

Use those two columns to build your stat - put the former over the latter and multiply by 100 in the value expression to get the numbers you desire.

[mannue]

Hi,
Thank you for your help!

took me a long time to understand where i should paste the code.

Am i right, that i have to click in the Coloumn tab on the top, then an "new"
Name: (I "took 4b_f_bu")
Expression: The first line of your code
Descripton: (Doesn´t matter!?)

If i click on "save" there is a message "The statement is no vali SQL"

If i get this both columns saved, what should i do next?
Go to Stat Tab i suppose, and then?

[WhiteRider]

Kraada's expressions validate for me - make sure you've selected "$" and "Players" then "Columns", and only paste in the bit after the :
"cnt_p_5bet_def_action_fold_after_4b" is Kraada's recommended column name, and the expression is:
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])

If you're doing this for tournaments you'll need to replace cash_ with tourney_

Once you have both columns saved click "Stats" and create a new stat. On the Definition tab give it a name, description and title and use your two new column names in the Value Expression.
In Kraada's example this would be:

(cnt_p_5bet_def_action_fold_after_4b / cnt_p_5bet_def_opp_after_4b) * 100

Have a look at how the other stats are constructed to get the general idea.

[mannue]

Yeah, i allready had a look on the other stats and tried to find out how the format is, but it was very difficult for me.
Now it worked to creat the stat and i put it into my hud, but when i looked up at player with over 5k hands (And I´m sure, they 4b/f alot) the stat says something like " - (1/0)"

Are u sure u got the right coloumns?

I have also an improvement for one stat in the standart HUD.
The Stat "4bet + After Raising" Isn´t really usefull in Percent, because u have to combine the Stat with his PFR
The Stat would be much better if it would be Multiplicated with the PFR and then as "4bet Range+ After raising"

[kraada]

If you want to see the 4bet number times PFR the stat you want is 4Bet Ratio - we don't call it "range" as it is not a range in the normal poker sense as it is not an amalgamation of hole card holdings.

Regarding the columns, they should work properly and I'll break it down piece by piece so you see why:

In cnt_p_5bet_def_action_fold_after_4b we add up times that the following are all true: char_length(cash_hand_summary.str_aggressors_p) >= 4 - the pot was at a minimum 4bet (this could be 5 as well but it won't make a difference for our purposes)

cash_hand_player_statistics.position = substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int - the current active player's position is the same as the position of the 4bet - so this player made the 4bet exactly.

cash_hand_player_statistics.flg_p_fold - and he folded preflop.

This implies that there was at least a 5bet as he had to face another raise and fold to it.


In cnt_p_5bet_def_opp_after_4b we add up times that the following are all true:

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 - again that there was at least a 4bet and the active player made it

cash_hand_player_statistics.flg_p_4bet_def_opp - and that he then defended against a 4bet or higher - meaning someone must have 5bet.

Note that the latter should be the denominator - are you sure you put them in the right order in your stat?

[mannue]

Hi Kraada,

thanks for the detailted explanation. Nice too understand how this works!

I just made some screenshots. Take a look if u can find some mistakes!







Find the custom stat one below fold to cbet!