BB folds SB Steal (Size 3,50-3,99 BB)

[hotrocket]

( cnt_p_bb_v_sb_fold_350_399 / (cnt_p_bb_v_sb_fold_350_399 + cnt_p_bb_v_sb_call_350_399+cnt_p_bb_v_sb_3bet_350_399) ) * 100

cnt_p_bb_v_sb_fold_350_399=

sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' AND cash_hand_summary.str_actors_p LIKE '9%' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9 AND (cash_hand_player_statistics.amt_p_2bet_facing / cash_limit.amt_bb) BETWEEN 2.00 and 2.49, 1, 0])

cnt_p_bb_v_sb_call_350_399=

sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9 AND cash_hand_summary.str_actors_p LIKE '9%' AND (cash_hand_player_statistics.amt_p_2bet_facing / cash_limit.amt_bb) BETWEEN 2.50 and 2.99, 1, 0])

cnt_p_bb_v_sb_3bet_350_399=

sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9
AND cash_hand_summary.str_actors_p LIKE '9%'
AND (cash_hand_player_statistics.amt_p_2bet_facing / cash_limit.amt_bb) BETWEEN 2.50 and 2.99, 1, 0])

There should be somethimg wrong in the columns. Please check. TY

[hotrocket]

"BETWEEN 2.00 and 2.49" is wrong of course. But is it guranteed that it is a steal situation?

[kraada]

Yes, it's a guaranteed steal.

[xRhythm]

Hi.
My question is , can we group these 3 stats : (cnt_p_bb_v_sb_fold + cnt_p_bb_v_sb_call+cnt_p_bb_v_sb_3bet) into one stat like cnt_p_bb_sb_face_raise;

cnt_p_bb_sb_face_raise: sum(if[cash_hand_player_statistics.position=8 AND cash_hand_player_statistics.flg_blind_def_opp AND (lookup_actions_p.action='C|F' OR lookup_actions_p.action LIKE 'R%') AND cash_hand_summary.str_actors_p LIKE '9%' AND cash_hand_player_statistics.val_p_raise_aggressor_pos=9,1,0])

Would it be in bold and underlined correct?

Thank you.

[WhiteRider]

For the opportunities column you don't care what the action of the player was, so you don't need the bold underlined part at all - you can just omit that because you're testing for every possible action (which is the same as not testing what the action is at all).
Facing a steal is enough to define the situation, because if you face a steal then you must make one of those three actions.

--
I'd like to point out that this:
(lookup_actions_p.action='C|F' OR lookup_actions_p.action LIKE 'R%')
..won't work though.

lookup_actions_p.action='C|F'
..tests for the actions string being exactly 'C|F', and that isn't possible. That says the actions were C then | then F, and | isn't a valid action character. To use | you need to use "similar to" instead of =. So you could do this:
(lookup_actions_p.action SIMILAR TO '(C|F)' OR lookup_actions_p.action LIKE 'R%')