Custom statistic not working as intended

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Custom statistic not working as intended

Postby Joop59 » Thu Oct 31, 2024 4:46 am

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!
Joop59
 
Posts: 10
Joined: Wed Apr 15, 2020 9:14 am

Re: Custom statistic not working as intended

Postby Flag_Hippo » Thu Oct 31, 2024 7:55 am

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.
Flag_Hippo
Moderator
 
Posts: 15169
Joined: Tue Jan 31, 2012 7:50 am

Re: Custom statistic not working as intended

Postby Joop59 » Thu Oct 31, 2024 3:09 pm

I see! thank you very much.
Joop59
 
Posts: 10
Joined: Wed Apr 15, 2020 9:14 am

Re: Custom statistic not working as intended

Postby Joop59 » Thu Oct 31, 2024 3:26 pm

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.
Joop59
 
Posts: 10
Joined: Wed Apr 15, 2020 9:14 am

Re: Custom statistic not working as intended

Postby Flag_Hippo » Fri Nov 01, 2024 7:12 am

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.
Flag_Hippo
Moderator
 
Posts: 15169
Joined: Tue Jan 31, 2012 7:50 am

Re: Custom statistic not working as intended

Postby Joop59 » Sat Nov 02, 2024 8:53 am

Ah, I see.

Thanks a lot! I'm very new to making custom statiscs. I managed to fix it now :)
Joop59
 
Posts: 10
Joined: Wed Apr 15, 2020 9:14 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 4 guests

cron