BB call BTN open shove stat

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

BB call BTN open shove stat

Postby PetarM » Tue Feb 15, 2022 3:43 pm

Hello,

I am trying to build a stat where BB calls BTN open shove.

I use as an example the stat where BB calls SB preflop open shove:

BB call SB preflop open shove = ( cnt_p_BB_call_SB_openshove / cnt_p_BB_face_SB_openshove ) * 100

where "cnt_p_BB_call_SB_openshove" column expression is:
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.val_p_raise_aggressor_pos=9 AND tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])

and "cnt_p_BB_face_SB_openshove" expression is:
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])

The result from "BB call SB preflop open shove" is correct, however when I try to change the SB position with BTN position (from 9 to 0), the result is no longer correct.

Can someone take a look and try to find out what is wrong

Thank you
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: BB call BTN open shove stat

Postby Flag_Hippo » Wed Feb 16, 2022 4:03 am

Changing the val_p_raise_aggressor_pos from 9 to 0 works fine for me. If you are seeing incorrect results have you rebuilt your custom database cache? Please provide specific details as to how it is not working for you and if there's hand that's being counted that shouldn't (or vice versa) then attach it here or send it privately to me in a PM.
Flag_Hippo
Moderator
 
Posts: 17136
Joined: Tue Jan 31, 2012 7:50 am

Re: BB call BTN open shove stat

Postby PetarM » Wed Feb 16, 2022 12:47 pm

Hello,
- I have rebuilt the cache: still the same
- what I do is to compare the custom stat percentage with the percentage I calculate using filters. I have a perfect match when SB vs BB but not the same when BTN vs BB.

The filters i use are the following:
- BB faces BTN open shove: Simple filters "Position of Active Player Position of Selected Exactly 8" and "Faced All-In Preflop", combined with expression filter "tourney_hand_summary.str_actors_p like '0%'"
- BB calls BTN open shove: Simple filters "Position of Active Player Position of Selected Exactly 8" and "Faced All-In Preflop", combined with expression filter "tourney_hand_summary.str_actors_p like '0%8%'"

The ratio should be the sames and yet it is different...
Can you try this out?
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: BB call BTN open shove stat

Postby PetarM » Wed Feb 16, 2022 1:10 pm

I understood my error: "tourney_hand_summary.str_actors_p like '0%'" doesn't necessarily mean that BTN is shoving, it could be raise from BTN and shove from SB.

In this case how can I simulate these situations with filters: "BB faces BTN open shove" and "BB calls BTN open shove"
PetarM
 
Posts: 58
Joined: Wed Oct 18, 2017 4:25 pm

Re: BB call BTN open shove stat

Postby Flag_Hippo » Thu Feb 17, 2022 7:55 am

PetarM wrote:- I have rebuilt the cache: still the same
- what I do is to compare the custom stat percentage with the percentage I calculate using filters. I have a perfect match when SB vs BB but not the same when BTN vs BB.

The filters i use are the following:
- BB faces BTN open shove: Simple filters "Position of Active Player Position of Selected Exactly 8" and "Faced All-In Preflop", combined with expression filter "tourney_hand_summary.str_actors_p like '0%'"
- BB calls BTN open shove: Simple filters "Position of Active Player Position of Selected Exactly 8" and "Faced All-In Preflop", combined with expression filter "tourney_hand_summary.str_actors_p like '0%8%'"

The ratio should be the sames and yet it is different...
Can you try this out?

Built-in filters, expression filters and custom statistics all use the same language so if you have a custom column and then build a simple filter that does the same thing as the column the results will match. The problem with your method here for testing is that:

a) Your built-in filter is not replicating what's going on in your custom column.

b) You can do things in custom columns that you can't do with built-in filters such as comparing the players effective stack to the size of a bet faced.
PetarM wrote:In this case how can I simulate these situations with filters: "BB faces BTN open shove" and "BB calls BTN open shove"

If you want to check your statistic I recommend testing the expressions from your columns directly in an expression filter with the method described in this post.
Flag_Hippo
Moderator
 
Posts: 17136
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 1 guest