I am trying to create a stat, that displays the open-shove-percentage of a player in the small blind (in HU), but I struggle.
Stat Value Expression:
- Code: Select all
(cnt_p_os / cnt_p_os_opp) * 100
This is basically times player in sb open-shoves / times player is in sb *100.
cnt_p_os:
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND lookup_positions.flg_sb AND tourney_hand_player_statistics.amt_p_raise_made / tourney_hand_player_statistics.amt_p_effective_stack >= 0.7 , 1, 0])
As you see, I define open-shove as a raise of 0.7 times the effective stacks. I don't know a better way.
cnt_p_os_opp:
- Code: Select all
sum(if[lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_before - (tourney_hand_player_statistics.amt_blind + tourney_hand_player_statistics.amt_ante))), 1, 0])
I don't get this at all, but it works in other scenarios, so I assume the problem lies within cnt_p_os.
If you know a good guide on stat-making in pt4, I am all ears

Cheers,
George