Average Raise/Bet Amount preflop / on flop

[merkur33]

I want to make two stats that show the average amount a player raises (first raise) preflop in terms of Big Blinds, and the average pot percentage he bets on the flop. Is this possible and which fields would i need in this case? And how do i compute the averages?

[kraada]

You'd need holdem_hand_player_detail.amt_p_raise_made and holdem_hand_player_detail.val_f_bet_made_pct. The former is in $, so you'd also need to divide by the big blind amount to get it in big blinds (holdem_limit.amt_bb). To get the average, after you make a column that sums up all of these values, divide in your statistic by the number of times they raised preflop (or the number of times a player bet the flop).

There's an Percent Bet on Flop stat which gives you the average that I built available in the repository that will give you that side of it (though practice building easy stats is a good thing).

[merkur33]

Great, thanks. Will do this. I just have to add a filter for an appropriate M, so he can pick the bet amounts of his liking...

Now i have another stat i made some time ago, but somehow it doesn't seam to work: Limpcall fold to flop bet. someone limped in, called a PFR and then folded to a flop bet (usually, but not nesessarily, a cbet). my columns are:
cnt_f_limp_call_face_bet: sum(if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.cnt_p_call=2 AND tourney_holdem_hand_player_detail.amt_f_bet_facing>0,1,0])
and cnt_f_limp_call_fold_to_bet: sum(if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.cnt_p_call=2 AND tourney_holdem_hand_player_detail.amt_f_bet_facing>0 AND tourney_holdem_hand_player_statistics.flg_f_fold,1,0])

Whats wrong with these?? It always seams to give me 0/0 for everyone, although this happens all the time... The idea was to check if someone limped and called two times (=the limp itself and the CallPFR) and then faced a flop bet amount (which, in my understanding, rules out that he himself bet out, for i want to look for weakness against a flop bet, not against a raise in these spots)

[kraada]

I'm not certain why that wouldn't work, but thankfully you can build these specific columns in multiple fashions.

Try this approach and see if it works better for you:

cnt_f_limp_call_face_bet: sum(if[tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CC' AND tourney_holdem_hand_player_detail.amt_f_bet_facing>0,1,0])
and cnt_f_limp_call_fold_to_bet: sum(if[tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CC' AND tourney_holdem_hand_player_detail.amt_f_bet_facing>0 AND tourney_holdem_hand_player_statistics.enum_folded = 'F',1,0])

[merkur33]

Thanks (again) :) I just have to make a recache before i can see if it works. This lookup-actions-thingie works like this for all streets (lookup_actions_f.action, lookup_actions_t.action and lookup_actions_r.action)? so you can check for all combinations of actions, like 'BCRC' (bet-call-raise-call, happens all the time...) and the like? Can you lookup also for checks and whats the shortcut for these?

[kraada]

Yes there's a lookup_actions for each street. I suspect BCRC is pretty rare though, or at least, it is in the stakes and games I play - it would require 3 players as hero Bets, then faces a raise and calls, then someone else (who didn't raise) had to 3bet, then hero had to 4 bet, and someone else had to 5 bet . . . that's at least rare where I come from :)

[merkur33]

you should play more often during european time frames </ironic>

But you didn't answer the "whats about check?"-part...

I made an average PFR stat for tourneys that tries to take into account only not-shortstacked situations (M>= 10) that comes out like this:
Av PFR: amt_avg_pfr_BB / cnt_pfr_not_shortstacked, with
amt_avg_pfr_BB: sum(if[(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante))) >= 10,(tourney_holdem_hand_player_detail.amt_p_raise_made / tourney_holdem_blinds.amt_bb),0]), and
cnt_pfr_not_shortstacked: sum(if[(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante))) >= 10 AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0,1,0])

I formatted it like this, as a first try:
if (cnt_pfr_not_shortstacked>9, format_number(amt_avg_pfr_BB / cnt_pfr_not_shortstacked,2,false,false),'-')

I can't remember what "2, false, false" does stand for, but i took it from my total AF stat, hoping to get a number with one decimal and no dollar sign, no sugar, and a little whipped cream. Curios what i get. Have to recache first. How does it look to you?

[kraada]

X is Check, B is bet, C is call, R is raise, F is fold.

In format_number the 2 is number of decimals, though if you want to see just 1 in the HUD you can override that value in the Configure HUD section (after adding the stat, see the properties box).

From the Tutorial: Using Custom Statistics & Reports:
format_number( value, decimals, commas, color )

* value - the value you want to display, typically copied from the Value Expression
* decimals - the number of decimal places to display
* commas - true if you want commas separators for thousands (e.g. 1,000 instead of 1000)
* color - true if you want positive values to be green and negative to be red. If you want the stat to be default color or if you want to define your own color ranges then you should set this to false.

[merkur33]

Thanks.

Now i tweaked my PF-Raise (BB) stat a little bit. i have Av PFR = amt_avg_pfr_BB / cnt_pfr_not_shortstacked

amt_avg_pfr_BB: sum(if[(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante))) >= 10 AND tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp=false,(tourney_holdem_hand_player_detail.amt_p_raise_made / tourney_holdem_blinds.amt_bb),0])

cnt_pfr_not_shortstacked: sum(if[(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante))) >= 10 AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp=false,1,0])

Although i check for 3bet_def_opp=false to rule out 3bets, the numbers i get are often very high. did i miss something stupid or are they really raising 5-11 BB in average??

[kraada]

That looks right. Can you find any players who you think are showing the wrong value? (E.g. a player who only 3bet once and the 3bet looks out of whack with this stat.)