How to create a custom average 3bet size stat?

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

How to create a custom average 3bet size stat?

Postby Qwaserd » Sat Nov 25, 2023 10:40 am

I created a player column stat
val_p_total_3bet
sum(if[cash_hand_player_statistics.flg_p_3bet, cash_hand_player_statistics.amt_p_raise_made_2 / cash_limit.amt_bb, 0])
and a custom player stat
Avg 3Bet Size
if( cnt_p_3bet > 0, (val_p_total_3bet / cnt_p_3bet), 0 )

It gives an output but not the one I expected. Any idea what I am doing wrong?

I did similar for average rfi size
val_p_total_rfi
sum(if[cash_hand_player_statistics.flg_p_first_raise, cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb, 0])
Avg RFI Size
val_p_total_rfi / cnt_p_raise_first_in

This works as expected.
Qwaserd
 
Posts: 10
Joined: Wed Aug 12, 2009 12:10 pm

Re: How to create a custom average 3bet size stat?

Postby Flag_Hippo » Sat Nov 25, 2023 2:09 pm

Qwaserd wrote:I created a player column stat
val_p_total_3bet
sum(if[cash_hand_player_statistics.flg_p_3bet, cash_hand_player_statistics.amt_p_raise_made_2 / cash_limit.amt_bb, 0])
and a custom player stat
Avg 3Bet Size
if( cnt_p_3bet > 0, (val_p_total_3bet / cnt_p_3bet), 0 )

It gives an output but not the one I expected. Any idea what I am doing wrong?

You need to use cash_hand_player_statistics.amt_p_raise_made which is the size of the first preflop raise made by the player. cash_hand_player_statistics.amt_p_raise_made_2 is the size of the second raise made by the player which at minimum will be a 4bet.
Qwaserd wrote:I did similar for average rfi size
val_p_total_rfi
sum(if[cash_hand_player_statistics.flg_p_first_raise, cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb, 0])
Avg RFI Size
val_p_total_rfi / cnt_p_raise_first_in

This works as expected.

This isn't going to give you correct numbers. Based on the definition in PokerTracker 4 a 'Raise First In' means that the player opened the pot for a raise (i.e. no limpers) but you are summing the size of all 2bets regardless of whether it was first in or not. See the expression used for the cnt_p_raise_first_in column which also uses cash_hand_player_statistics.flg_p_open_opp.
Flag_Hippo
Moderator
 
Posts: 14355
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 3 guests

cron