PokerTracker

Hi, I'm trying to do a turn probe statistic considering the number of times the player bets on the turn out of position after the pre-flop aggressor checks the flop.
Probe Turn hubb 10+
cnt_t_probe_hubb_10more/cnt_t_probe_opp_hubb_10more

position: HUBB
effective stack: 10bb+
preflop action: C on a 2bb bet
flop action: X
turn action: bet

cnt_t_probe_hubb_10more
sum(if[tourney_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action LIKE 'C' AND tourney_hand_player_statistics.flg_p_face_raise 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_summary.cnt_players = 2 AND and (tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 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.flg_blind_b, 1, 0])

cnt_t_probe_opp_hubb_10more
sum(if[tourney_hand_player_statistics.flg_t_open_opp AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action LIKE 'C' AND tourney_hand_player_statistics.flg_p_face_raise 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 (tourney_hand_summary.cnt_players = 2 and tourney_hand_player_statistics.flg_blind_b), 1, 0])

Please check for me if everything is ok?

For some reason I am unable to identify the 'cnt_t_probe_hubb_10more' column, it is not valid, I have already checked the parentheses and found no errors.

You don't need this part at the end of either column (because you have already tested for being in the big blind position with "tourney_hand_player_statistics.position=8"):
" and tourney_hand_player_statistics.flg_blind_b"
..so you should remove that.

Your parentheses are mismatched, and you have an extra "and" in there.

I think this should do it:

cnt_t_probe_hubb_10more =
sum(if[tourney_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action LIKE 'C' AND tourney_hand_player_statistics.flg_p_face_raise 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_summary.cnt_players = 2 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 and tourney_hand_player_statistics.position=8 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100), 1, 0])

You may find that using an exernal editor helps for more complex expressions. For example, Notepad++ will highlight matching brackets and that makes finding this type of error much easier.

Other than that it looks good though.

WhiteRider wrote:You may find that using an exernal editor helps for more complex expressions. For example, Notepad++ will highlight matching brackets and that makes finding this type of error much easier.

I'm grateful for the tip

apparently everything went well.

cnt_t_probe_opp_hubb_10more
sum(if[tourney_hand_player_statistics.flg_t_open_opp AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action LIKE 'C' AND tourney_hand_player_statistics.flg_p_face_raise 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 tourney_hand_summary.cnt_players = 2, 1, 0])

cnt_t_probe_hubb_10more
sum(if[tourney_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action LIKE 'C' AND tourney_hand_player_statistics.flg_p_face_raise 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_summary.cnt_players = 2 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 and tourney_hand_player_statistics.position=8 AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100), 1, 0])

Thank you very much!!!!

You're welcome - that's good to hear!