Fold to T 1BET MRP

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Fold to T 1BET MRP

Postby DANNI BASTOS » Thu Nov 23, 2023 1:15 am

I am creating a statistic that indicates the percentage of times that the player folds on the turn for a bet of up to 100% of the pot value.

being:
Expression: Fold to T 1Bet 10+ MRP = (cnt_t_bet_def_action_fold_10more_MRP / cnt_t_bet_def_opp_10more_MRP) * 100
position: HUBB
effective stack preflop: 10bb~100bb
PREFLOP = C versus raise 2bb
FLOP = X
TURN = XF

cnt_t_bet_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 char_length(tourney_hand_summary.str_aggressors_p) = 1 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_f.action = 'X' AND lookup_actions_p.action = 'C' AND tourney_hand_player_statistics.val_t_bet_facing_pct <=50) AND tourney_hand_player_statistics.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%'), 1, 0])

cnt_t_bet_def_opp_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND (tourney_hand_player_statistics.val_t_bet_facing_pct <=50) 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 lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND char_length(tourney_hand_summary.str_aggressors_p) = 1 AND tourney_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])

cnt_t_bet_def_action_fold_10more_MRP statistic 'not valid' by PT4

please what is happening in cnt_t_bet_def_action_fold_10more_MRP?
Furthermore, according to the description, the cnt_t_bet_def_action_fold_10more_MRP column is correct?
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Fold to T 1BET MRP

Postby Flag_Hippo » Thu Nov 23, 2023 7:14 am

DANNI BASTOS wrote:cnt_t_bet_def_action_fold_10more_MRP statistic 'not valid' by PT4

please what is happening in cnt_t_bet_def_action_fold_10more_MRP?

That is not validating because there is a bracket mismatch so if you tidy those up the expression will validate. Check all the open and close brackets in your expression making sure that there are the same number of each and that they are in the right places. I recommend using Notepad++ as this will automatically highlight matching/mismatched brackets automatically.
DANNI BASTOS wrote:Furthermore, according to the description, the cnt_t_bet_def_action_fold_10more_MRP column is correct?

This should not be included:

char_length(tourney_hand_summary.str_aggressors_p) = 1

This means the pot is limped which isn't what you want.
Flag_Hippo
Moderator
 
Posts: 14510
Joined: Tue Jan 31, 2012 7:50 am

Re: Fold to T 1BET MRP

Postby DANNI BASTOS » Thu Nov 23, 2023 12:10 pm

That is not validating because there is a bracket mismatch so if you tidy those up the expression will validate. Check all the open and close brackets in your expression making sure that there are the same number of each and that they are in the right places. I recommend using Notepad++ as this will automatically highlight matching/mismatched brackets automatically.


Thanks Flag_Hippo, I was just about to ask for a recommendation for a program to do this. I get really confused counting the parentheses.

I made the changes and they are all valid, can you check if they comply with the statement?

Fold to T 1Bet 10+ MRP = (cnt_t_bet_def_action_fold_10more_MRP / cnt_t_bet_def_opp_10more_MRP) * 100

cnt_t_bet_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.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_f.action = 'X' AND lookup_actions_p.action = 'C' AND (tourney_hand_player_statistics.val_t_bet_facing_pct <=50) AND tourney_hand_player_statistics.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%'), 1, 0])

cnt_t_bet_def_opp_10more_MRP
sum(if[tourney_hand_summary.cnt_players = 2 AND (tourney_hand_player_statistics.val_t_bet_facing_pct <=50) 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 lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'X' AND tourney_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Fold to T 1BET MRP

Postby Flag_Hippo » Fri Nov 24, 2023 6:39 am

That looks good.
Flag_Hippo
Moderator
 
Posts: 14510
Joined: Tue Jan 31, 2012 7:50 am

Re: Fold to T 1BET MRP

Postby DANNI BASTOS » Sat Nov 25, 2023 10:49 pm

tks ;)
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 19 guests

cron