Active players and/or closing action

[pasita]

I'd like to see, on any particular street (starting preflop)
-how many players still had cards when hero acted (I know, hero can act several times... assume the first action to begin with)
-whether hero had a possibility to close the action (or the amount of such possibilities).

If there's a way of deriving this info from existing columns I'm all ears.

[kraada]

This should be doable as a custom stat but it's a bit tricky.

If you have the chance to 2bet and are facing limpers (cash_hand_player_statistics.cnt_p_face_limpers > 0) then it's the number of players left to act after your position (position + 2 if position <= 7, 1 if position = 9, 0 if position = 8) plus the number of limpers (cnt_p_face_limpers).

If you have a chance to 3bet and don't have a chance to squeeze it's the number of people who still haven't acted once + the number of limpers + 1 (the raiser). In this case though you'd need to use action strings to find out who limped by getting the position of the 2bettor (the second number in the string cash_hand_summary.str_aggressors_p) and finding out how many numbers come before it in cash_hand_summary.str_actors_p. If you do have a chance to squeeze it's that plus the number of callers (players who are in str_actors_p between your position and the aggressor's position).

For 4betting it gets even more complicated since you can be 4betting cold or 4betting after raising . . .

[pasita]

Ok, thanks, I try to take it from there.
The chance to close the action has to be determined from all of the above and hero's position, I guess.

[kraada]

Also you need to be careful to note that you can have opportunities to close the action and not to close the action in the same hand.

For example, if you open from the CO - that open couldn't close the action (with the BTN, SB and BB behind you), but if the BTN 3bets and all fold to you, now you can close the action.

[pasita]

yeah, I'd prefer a flg_close_action_opp or cnt_close_action_opp... if it was just a flag I think it would still be close enough, although obviously not exact.