Cold Call Isolation Raise

[kraada]

You also need to add something to indicate that there was a raise - right now it's true that the first aggressor wasn't the first actor as there was no first actor.

[murmanman]

maybe

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 lookup_actions_p.action LIKE 'C%' AND cash_hand_player_statistics.amt_p_2bet_facing > 0

??

[kraada]

That would work.

[murmanman]

thank you for help

[justforfun]

I tried to use below custom stat, but it counts me also the cases when everybody folds and SB complete the blind and then call the BB raise.
What should I add to exclude this cases?

cnt_p_ccall_limp:
sum(if[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 cash_hand_player_statistics.amt_p_2bet_facing > 0 AND lookup_actions_p.action LIKE 'C%' , 1, 0])

cnt_p_ccall_limp_opp:
sum(if[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 cash_hand_player_statistics.amt_p_2bet_facing > 0 , 1, 0])

[kraada]

Do you want to exclude all cases where the active player limps and calls a raise from the big blind or only the SB completion situation? Do you want times the SB overlimps with limpers in earlier position to count when the BB raises all of them?

[justforfun]

Actually I want to count the overcalls of the isolation raiser only, I dont care of the limper itself - e.g. UTG limps , CO raise, SB call, UTG call --> I want to see only the cold call for SB. (for UTG I already have limp/call stat and I dont want to mixed these t stats)
I dont want to count cold calls from the limper - UTG from previous case, nor cases like everybody fold and SB limp/call

[kraada]

Then add that not(cash_hand_player_statistics.flg_p_limp) - you don't want situations where this player limped in any way.

[justforfun]

greate thx!!