1. The expression I gave needs to go inside a sum(if[, 1, 0])
statement - see the second page
in the guide I linked you to. While it was originally written for PokerTracker 3 the techniques all apply to PokerTracker 4.
2. You need two columns for the statistic - one that counts how often the player squeezes with less than 50% of their stack and another that counts how often they have the opportunity to squeeze. When you have the two columns you create the custom statistic in this format to calculate the percentages from the columns:
- Code: Select all
(a / b) * 100
where 'a' and 'b' are your custom column names.
3. You can use the default column for the opportunities (cnt_p_squeeze_opp
) although you may want to create a custom column where you can set a minimum amount of BB's for the player so opportunities are not counted when they have a small stack (and add that to the actions column). You can use:tourney_hand_player_statistics.amt_before
which is the players stack at the beginning of the hand
which is the effective stack and for each player it is determined at their first action in the hand and it's the amount they could lose in a pot as of that first action in the hand so you can use this to exclude situations where the player had a large stack but the remaining players in the hand were short stacked.
These reference the players actual stack/effective stack in chips so to convert to BB's you will need to divide by tourney_blinds.amt_bb
4. While it doesn't affect functionality for you custom column names I suggest following the default conventions (see this post
in the guide) so use something like cnt_p_squeeze_nai
for your actions column instead of what you are using (sqznai
pocarr24 wrote:Will this work if I create it for cash and then convert to tournament stat?
Yes or you can just change all instances of 'cash' to tourney when creating it:
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_squeeze and (tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_before / 2))
, 1, 0])