- Code: Select all
sum(if[tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'
AND (tourney_hand_player_statistics.cnt_p_call = 1 OR tourney_hand_player_statistics.cnt_p_raise > 0) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 9
AND tourney_hand_player_statistics.val_p_raise_aggressor_pos = 9 AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.cnt_p_face_limpers = 0
AND char_length(tourney_hand_summary.str_aggressors_p) <= 2, 1, 0])
seems to work as intended.
There is actually one thing I would like to optimize, but I dont have any idea how to implement it:
An "open shove" by Small Blind needs to count, if he is comitting at least 50% of the effective stack.
For example; SB 15bb, BB 8bb. If Small Blind is "openraising" 4 or 5bb this should als count as an openshove.
I think I have to modify this!?
- Code: Select all
tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(P|p)'
Could anybody help here?
kind regards
