PokerTracker

Good morning,

I was trying to create a statistic for cash games with short stacks of "Fold to PF 3Bet NAI After Raise." It turns out I have a problem that distorts the statistic. I can indicate in the stat to consider hands where the effective stack > 14BB for example, but it still filters this type of hands that I don't want it to count. Here's an example:

- There are 3 players at the table, P1: 28BB, P2: 5BB, Hero: 18BB. --> HERO OR - P2 3BET 5BB

Can I somehow exclude this type of situations? Could I somehow limit the stack of the player who makes the 3Bet?

Thanks in advance.


cnt_p_3bet_NAI_def_action_fold_when_FR_3

sum(if[cash_hand_player_statistics.enum_p_3bet_action='F'
AND cash_hand_player_statistics.flg_p_open_opp
AND cash_hand_player_statistics.flg_p_first_raise
AND (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb <= 3)
AND (cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb >= 14 )
AND ((cash_hand_player_statistics.amt_p_3bet_facing / cash_limit.amt_bb) + (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb)) <= ((cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb) / 3), 1, 0])

Querying the data of a player that the statistic is not written for will require the addition of a subquery (which is unable to use the database cache) like this:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, cash_limit cl where chps.id_player = p.id_player and chps.id_limit = cl.id_limit and chps.flg_p_3bet and (chps.amt_before / cl.amt_bb) between x and y)

For more on how SELECT works see here.

That seems to be complicated.

Thank you again, I will try to put it into practice in some statistics.