how to exclude other players' cold call?

[cesko]

Hi,

I tried searching the forum but I couldn't find anything about this:

I want to write a cutom stat where villain limp-fold OOP.

I deifined one of the colum, the number of opportunities, like this:

sum(if[cash_hand_summary.cnt_players >= 3
and cash_hand_player_statistics.flg_p_limp
and cash_hand_player_statistics.flg_p_face_raise
and cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position, 1, 0])

but now I need to exclude hands where a third player cold called (because of course then the limper will be less prone to fold), but I can't find a way to achieve that.
I tried to add something like this:

and not exists
(select 1
from cash_hand_player_statistics villain
where villain.id_hand = cash_hand_player_statistics.id_hand
and villain.flg_p_ccall)

but it doesn't work, clearly I haven't understood how this works.

Any hint? Thanks

[Flag_Hippo]

Is this for just facing 2Bets or do you still want to count hands where the limper ends up facing a 3Bet+?

[cesko]

I want to filter only for facing 2bet, not 3bet+. I didn't mention that because I thought that once I figured out how to filter out the cold calls, it would be trivial to also filter out 3bet+.

anyway, yes; basically a limper facing a raise, without other players involved.

[Flag_Hippo]

If you do not want any other players involved (no other limpers, 2Bet callers and/or 3bettors+) then you can use this:

Code: Select all

sum(if[cash_hand_summary.cnt_players >= 3 and cash_hand_player_statistics.flg_p_limp
and cash_hand_player_statistics.amt_p_2bet_facing > 0 and not cash_hand_player_statistics.flg_p_squeeze_opp and char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_actors_p) >= 2 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int < substring(cash_hand_summary.str_actors_p from 1 for 1) ::int and substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int = substring(cash_hand_summary.str_actors_p from 2 for 1) ::int, 1, 0])

not cash_hand_player_statistics.flg_p_squeeze_opp for the limper means nobody else called the 2Bet (cash_hand_player_statistics.amt_p_2bet_facing > 0). The rest of the expression compares the actors and aggressors strings so that the 2bettors position is less than the limper and also that there are no other limpers.

[cesko]

great, thanks