Page 1 of 1

Custom statistic not working as intended

PostPosted: Thu Oct 31, 2024 4:46 am
by Joop59
Hi, I'm sure this type of post is very common, but I can't seem to understand what I'm doing wrong... Maybe someone could help me?

I tried creating a custom statistic that should count the % of times BB folds vs a SB open between 2 and 2.5bb specifically. I tried it in game and it counts folds vs bigger bets too.

The statistic is: ( cnt_p_bb_v_sb_fold / (cnt_p_bb_v_sb_fold+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_3bet) ) * 100

The collums are default to PT4, except for

cnt_p_bb_v_sb_call_NAI
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2 AND 2.5 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9, 1, 0])

If anyone could give me some clarity, it'd be very appreciated. Thanks in advance!

Re: Custom statistic not working as intended

PostPosted: Thu Oct 31, 2024 7:55 am
by Flag_Hippo
This custom column you have is only for the calls and since you are still using default columns for the folds (and 3bets) then they will be counting hands versus all raise sizes.

Re: Custom statistic not working as intended

PostPosted: Thu Oct 31, 2024 3:09 pm
by Joop59
I see! thank you very much.

Re: Custom statistic not working as intended

PostPosted: Thu Oct 31, 2024 3:26 pm
by Joop59
Okay, so I made a few changes.

I made a custom collumn for the folds:

cnt_p_bb_v_sb_fold_nai
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2 AND 2.5 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9, 1, 0])

So, now the statistic goes:
( cnt_p_bb_v_sb_fold_nai / (cnt_p_bb_v_sb_fold_nai+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_call+cnt_p_bb_v_sb_3bet) ) * 100

Do you think it will work as intended now? Thanks again!

Edit: actually, i got something wrong and edited the post.

Re: Custom statistic not working as intended

PostPosted: Fri Nov 01, 2024 7:12 am
by Flag_Hippo
Joop59 wrote:So, now the statistic goes:
( cnt_p_bb_v_sb_fold_nai / (cnt_p_bb_v_sb_fold_nai+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_call+cnt_p_bb_v_sb_3bet) ) * 100

Do you think it will work as intended now? Thanks again!

Edit: actually, i got something wrong and edited the post.


That's still not going to calculate correctly for two reasons:

1. For the calls you are using the custom column and the default column.

2. You are still using the default column for the 3bets.

Re: Custom statistic not working as intended

PostPosted: Sat Nov 02, 2024 8:53 am
by Joop59
Ah, I see.

Thanks a lot! I'm very new to making custom statiscs. I managed to fix it now :)