Probe Turn hubb

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Probe Turn hubb

Postby DANNI BASTOS » Sat Jan 06, 2024 5:05 pm

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.
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Probe Turn hubb

Postby WhiteRider » Sat Jan 06, 2024 5:27 pm

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
Moderator
 
Posts: 54000
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Probe Turn hubb

Postby DANNI BASTOS » Sun Jan 07, 2024 4:58 am

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!!!! ;)
DANNI BASTOS
 
Posts: 43
Joined: Mon Aug 07, 2023 4:09 pm

Re: Probe Turn hubb

Postby WhiteRider » Sun Jan 07, 2024 10:02 am

You're welcome - that's good to hear!
WhiteRider
Moderator
 
Posts: 54000
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 5 guests

cron