Fold to R BXB 10+ MRP

[DANNI BASTOS]

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?

[WhiteRider]

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

[DANNI BASTOS]

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?

[WhiteRider]

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.

[DANNI BASTOS]

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?

[WhiteRider]

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.