How to correctly count SB limps in HU?

[TIGANCIC]

I want to accurately count how many times the SB limped in heads-up. I have three possible queries:

Using lookup_actions_p.action = 'C' to check for a limp:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND lookup_actions_p.action = 'C'
, 1, 0])


Using flg_p_open_opp, which should indicate an open-raise opportunity (and thus a limp when not raised):

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_player_statistics.flg_p_open_opp
, 1, 0])


An alternative approach using id_hand > 0, but I’m not sure if it's correct:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 2 
    AND tourney_hand_player_statistics.id_hand > 0
, 1, 0])


Which option is the best to use? Or is there a more accurate way to do this?

[Flag_Hippo]

I want to accurately count how many times the SB limped in heads-up. I have three possible queries:

The final two expressions are not counting limps - only the opportunities to limp but you can use either of those as the denominator for the first expression. I'd recommend the second one since that specifies an open opportunity which the last one doesn't. You don't want to count hands where the SB was forced all-in with a very short stack.