PokerTracker

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 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.

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])

That looks good.

tks