BB Isod SB Limp between 1-4x and Folded to shove.
I'm not sure what formula to use to specify that BB raised a limp and then faced a limp shove and he folded to that.
(Number of times player raised a limp and folded to shove ) / (Number of times player raised a limp and faced a shove )
(cnt_p_raise_SBlimp_foldedtoLshove) / (cnt_p_facedshove_afterisoNAI1-4x)
cnt_p_raise_SBlimp_foldedtoLshove
condition 1. hand was folded to SB who limped:
tourney_hand_summary.str_actors_p LIKE '9%'
C2. BB made the first raise (iso)
tourney_hand_player_statistics.flg_p_first_raise
C3. BB isod between 1-4bb:
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4
C4. BB raise folded to shove:
lookup_actions_p.action = 'RF'
....and not sure what else
cnt_p_facedshove_afterisoNAI
C5. Player is BB
tourney_hand_player_statistics.position = 8
C6. raise size faced is shove
(tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack
If you can advise me as to
1. what conditions are required for each column, and
2. what conditions i am missing and what they are
that would be great! Thank you.