Fold to R BXB 10+ MRP

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Fold to R BXB 10+ MRP

Postby DANNI BASTOS » Sat Feb 03, 2024 4:18 am

Hello,

I'm creating a statistic for the percentage of times a player folds on River, under the following conditions:

effective stack: 10bb+
player position: HUBB
preflop: C in raise2bb
flop: X and C in cbet up to 1.6bb
turn: X
river: Fold to bet up to 9.6bb


Fold to R BXB 10+ MRP = (cnt_r_BXB_def_action_fold_10more_MRP / cnt_r_BXB_def_opp_10more_MRP) * 100

cnt_r_BXB_def_action_fold_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=30) AND tourney_hand_player_statistics.enum_f_cbet_action='C' and tourney_hand_player_statistics.position=8 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) AND lookup_actions_t.action = 'X' AND (tourney_hand_player_statistics.val_r_bet_facing_pct <=43) AND tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])

cnt_r_BXB_def_opp_10mais_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND (tourney_hand_player_statistics.val_r_bet_facing_pct <=43) AND tourney_hand_player_statistics.position=8 AND (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=30) AND lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'C' AND lookup_actions_t.action = 'X' AND tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])

Could you please evaluate this statistic I created?
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Fold to R BXB 10+ MRP

Postby WhiteRider » Sat Feb 03, 2024 5:46 am

Most of the elements of these expressions look good, but there are a couple of small mistakes.

I would recommend having everything in the same order in both expressions. That will make it much easier to spot any differences.
You will want the expressions to be identical apart from the river action/opportunity part right at the end.

For example you haven't included the preflop call in your action column (lookup_actions_p.action = 'C').

You also have the flop action defined differently in the two expressions:
Code: Select all
tourney_hand_player_statistics.enum_f_cbet_action='C'

vs
Code: Select all
lookup_actions_f.action = 'C'

The latter (in the opportunities column) will not work correctly because the BB will check/call here, not just call.

The opportunities column will need to define just the opportunity to fold, not the action of folding.
You currently have:
Code: Select all
(lookup_actions_r.action SIMILAR TO '(F|XF)%')

..in both expressions. You should remove this from the opportunities column, but keep:
Code: Select all
tourney_hand_player_statistics.amt_r_bet_facing > 0
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to R BXB 10+ MRP

Postby DANNI BASTOS » Sat Feb 03, 2024 1:30 pm

I organized the expressions and replaced lookup_actions_f.action='C' with tourney_hand_player_statistics.enum_f_cbet_action='C' in the opportunities column:

cnt_r_BXB_def_action_fold_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.position=8 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) AND (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=30) AND tourney_hand_player_statistics.enum_f_cbet_action='C' AND lookup_actions_t.action = 'X' AND (tourney_hand_player_statistics.val_r_bet_facing_pct <=43) AND tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])


cnt_r_BXB_def_opp_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.position=8 AND (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=30) AND tourney_hand_player_statistics.enum_f_cbet_action='C' AND lookup_actions_t.action = 'X' AND (tourney_hand_player_statistics.val_r_bet_facing_pct <=43) AND tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])


however I was unsure of what I should do with the other flagged actions: tourney_hand_player_statistics.amt_r_bet_facing > 0 and (lookup_actions_r. action SIMILAR TO '(F|XF)%'). Can you explain it to me another way?
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Fold to R BXB 10+ MRP

Postby WhiteRider » Sat Feb 03, 2024 1:53 pm

Your columns now look as if they are identical, so they will always have the exact same value. That means that your stat will always be 100%.

What you need to do is to remove:
Code: Select all
 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%')

..from the opportunities column "cnt_r_BXB_def_opp_10more_MRP", so that it counts hands where a bet is faced on the river regardless if the player folded or not.
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to R BXB 10+ MRP

Postby DANNI BASTOS » Sat Feb 03, 2024 3:14 pm

Thank you for the patience

Now the opportunities column is:

cnt_r_BXB_def_opp_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.position=8 AND (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=30) AND tourney_hand_player_statistics.enum_f_cbet_action='C' AND lookup_actions_t.action = 'X' AND (tourney_hand_player_statistics.val_r_bet_facing_pct <=43) AND tourney_hand_player_statistics.amt_r_bet_facing > 0, 1, 0])

the other column remained as it was.

is it correct now?
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Fold to R BXB 10+ MRP

Postby WhiteRider » Sat Feb 03, 2024 3:26 pm

Yes, I think that looks good now.

Remember to rebuild the custom cache so that the cached data updates to the fixed expressions.
Database > Database Management > Rebuild Cache > Custom Cache rebuild.

If you want to check which hands will be counted you may want to take a look at this post which explains how you can test column expressions using My Reports.
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 3 guests

cron