3bet >10bb vs 2.5 open (want to exclude SB)

[ttesone]

Hi, I made this column to account for the following scenario: first raise opens to 2-2.5bb from EP-BU (I want to exclude SB), BB 3bets (not squeeze) to >10bb. I made the same stat for SB without restricting any opening position (didn't need to) and it works. But when I add the "cash_hand_summary.str_aggressors_p NOT LIKE '9%'" it doesn't work. Tested it and it returns 0 even though there are cases that should be counted. What am I doing wrong? Thanks!

sum(if[cash_hand_player_statistics.flg_p_3bet AND NOT(flg_p_squeeze_opp) AND cash_hand_summary.str_aggressors_p NOT LIKE '9%' AND cash_hand_player_statistics.position = 8 and cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 10 AND cash_hand_player_statistics.amt_p_2bet_facing / cash_limit.amt_bb between 2 and 2.5, 1, 0])

[ttesone]

Realized it's not working without filtering out SB either. So I guess the mistake is somewhere else. It works from SB but not BB

[Flag_Hippo]

1. The aggressors string always starts with the big blind so you would need to be using:

Code: Select all

cash_hand_summary.str_aggressors_p NOT LIKE '89%'

This post has more information on how the actors and aggressors strings work.

2. The size of the 2bet faced is the amount the player needs to call so the player in the big blind is facing a 2bet of between 1bb and 1.5bb if the original 2bet was between 2bb and 2.5bb. I recommend adding the amount any blind the player posted to the calculation which will work for any player in any position:

Code: Select all

((cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind) / cash_limit.amt_bb) between 2 and 2.5

3. You should be using cash_hand_player_statistics.flg_p_squeeze_opp and not just flg_p_squeeze_opp.