Fold to steal in BB

[beast9881]

and what are the columns in the denominator dont think I can take this one from the fold to steal stat sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

[beast9881]

think I got it:

for co denominator: sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '81%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

correct?

[kraada]

Right

[beast9881]

Could you please give me the column for the fold vs SB steal and explain how the positions of the stealer are defined in the columns think it is done by the p_like'80%' p_like'0%' for btn and p_like'81%' p_like'1%' for co but dont know what the percentages mean!

[WhiteRider]

Those aren't percentages - the % sign represents zero or more characters in a string.
Check out this post for information on the actors and aggressors strings.

Where the button uses position 0 and the cutoff uses position 1, the SB is position 9 so the expressions would be the same except that the 1 or 0 in the "LIKE" expressions would be replaced with 9.

[beast9881]

Now I have built some more stats can you tell me if they are correct? I think thea are but I am not sure!

1. 3Bet vs BTN Steal: cnt_steal_d_action_raise_vs_BU / cnt_steal_def_opp_vs_bu) * 100
column1: sum(if[lookup_actions_p.action = 'R' and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
column2: sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

2. 3Bet vs CO Steal: (cnt_steal_def_action_raise_vs_CO / cnt_steal_def_opp_vs_co) * 100
sum(if[lookup_actions_p.action = 'R' and cash_hand_summary.str_aggressors_p LIKE '81%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '81%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

3. Call vs BTN Steal: (cnt_steal_def_action_call_vs_BU / cnt_steal_def_opp_vs_bu) * 100
sum(if[lookup_actions_p.action = 'C' and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

4. Call vs CO Steal: (cnt_steal_def_action_call_vs_CO / cnt_steal_def_opp_vs_co) * 100
sum(if[lookup_actions_p.action = 'C' and cash_hand_summary.str_aggressors_p LIKE '81%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '81%' and cash_hand_summary.str_actors_p LIKE '1%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

for what does the 'R' stand a 3Bet or a 3Bet+ ?

[kraada]

lookup_actions_p.action = 'R' means your one and only action preflop was to raise. What you actually really want here is cash_hand_player_statistics.flg_p_3bet -- that specifies you made a 3bet and if there's a 4bet after it doesn't exclude the hands. When you do lookup_actions_p.action = 'C' it specifies you made one and only one call - which precludes squeeze spots. If you want squeezed hands to count also, you'd want instead lookup_actions_p.action LIKE 'C%' - that means that the player called first and then something may or may not happen afterwards.

[beast9881]

Ok is that right now?

1. 3Bet vs BTN Steal: cnt_steal_d_action_raise_vs_BU / cnt_steal_def_opp_vs_bu) * 100
column1: sum(if[cash_hand_player_statistics.flg_p_3bet and lookup_actions_p.action = 'R%' and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
column2: sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

2. Call vs BTN Steal: (cnt_steal_def_action_call_vs_BU / cnt_steal_def_opp_vs_bu) * 100
sum(if[lookup_actions_p.action = 'C%' and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])
sum(if[cash_hand_player_statistics.flg_blind_def_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' and cash_hand_player_statistics.flg_blind_def_opp, 1, 0])

isn 't it possible in 1. to do this without [cash_hand_player_statistics.flg_p_3bet] only with [ lookup_actions_p.action = 'R%' ] because a raise of mine is always a 3bet and so I dont see the sense of the [cash_hand_player_statistics.flg_p_3bet] column
there can be a call or a 4bet+

[kraada]

With flg_blind_def_opp and actions like 'R%', flg_p_3bet is not needed. But you could equally remove actions like 'R%' since flg_p_3bet does the exact same thing in this particular instance. It's really up to you.

[WhiteRider]

Note that this will not work:

lookup_actions_p.action = 'R%'

That says that the action string must have been EXACTLY 'R%', but it will never contain the percent sign literally - that is a wildcard symbol which can match any zero or more characters. When you use wildcards you need to use "LIKE" instead of equals, like this:

lookup_actions_p.action LIKE 'R%'