Probe Turn hubb

[DANNI BASTOS]

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.

[WhiteRider]

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.

[DANNI BASTOS]

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

[WhiteRider]

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