PokerTracker

Hello,

I've been struggling for a while with this stat because I thought it was working fine but I noticed the numbers are not good when leakfinding with my database.

So here is how it looks:

Value expression:

(cnt_p_mr_call / cnt_p_mr_call_opp) * 100

Columns:

sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 AND lookup_actions_p.action LIKE 'C', 1, 0])

sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 AND lookup_actions_p.action LIKE '_', 1, 0])

I can't figure out why it doesn't work properly but I think some hands are missing when I use it...

1. If there was a minraise 2Bet preflop then the players behind will be facing a raise of 2BB and not 1BB unless they are in the blinds. The amount of the raise faced is the amount the player needs to call so the player in the SB will be facing a raise of 1.5BB and the BB will be facing a raise of 1BB. Also tourney_hand_player_statistics.amt_p_raise_facing is the size of the last raise faced by the player (which might not be a 2Bet and I am assuming you only want preflop 2Bets) so in these cases it is better to use tourney_hand_player_statistics.amt_p_2bet_facing. To account for all of the above regardless of whether the player was in the blinds or not you can use:

Code: Select all

((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2

tourney_hand_player_statistics.amt_blind is the amount of any blind posted by the player so if the player hasn't posted a blind it will be zero for them.

2. With both columns you are restricting the hands which are counted to those in which the player made only one single preflop action so hands where they made more than action (e.g. subsequently facing a squeeze) are not going to get counted. To count those hands you will need to use this in the first column:

Code: Select all

lookup_actions_p.action LIKE 'C%'

For more detail on pattern matching in PostgreSQL see this guide. For the second column you don't need to test the players actions - you only need to know they faced the minraise and had the opportunity to call.

I didn't think it was useful to specify the position because I just edit it in the HUD (I put BB so I assume it would work fine)

So I went with this :

sum(if[((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2 AND lookup_actions_p.action LIKE 'C' AND lookup_actions_p.action LIKE 'C%', 1, 0])

sum(if[((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2 AND lookup_actions_p.action LIKE '_', 1, 0])

It still doesn't work properly... I think I missed something

So I tried to use the stat from this thread:
https://www.pokertracker.com/forums/vie ... 5&start=10

but i get the same issue, the stats is lower than it should be. It display the wrong numbers.

What I don't understand is the stat seems to work fine 3way but not correctly in heads up.

I think I may have understood what was going on.

The problem seems to be with with the <2bb effective stack allin that were counted as minraise. It is a situation I wanted to exclude so I added

and (tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack )

and it seems to be okay. What do you think?

Naeco wrote:I didn't think it was useful to specify the position because I just edit it in the HUD (I put BB so I assume it would work fine)

So I went with this :

sum(if[((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2 AND lookup_actions_p.action LIKE 'C' AND lookup_actions_p.action LIKE 'C%', 1, 0])

sum(if[((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2 AND lookup_actions_p.action LIKE '_', 1, 0])

It still doesn't work properly... I think I missed something

1. You should be replacing lookup_actions_p.action LIKE 'C' with lookup_actions_p.action LIKE 'C%' and not using both.

2. You should remove lookup_actions_p.action LIKE '_' otherwise you will be restricting the column to only count hands where the player only took one preflop action. As I mentioned for this column you don't need to test the players actions - you only need to know they faced the minraise and had the opportunity to call.

Naeco wrote:So I tried to use the stat from this thread:
https://www.pokertracker.com/forums/vie ... 5&start=10

but i get the same issue, the stats is lower than it should be. It display the wrong numbers.

What I don't understand is the stat seems to work fine 3way but not correctly in heads up.

You need to make the changes I've suggested. I also covered this subsequently in that thread in this post although there I explain that lookup_actions_p.action LIKE '_%' can be used instead of lookup_actions_p.action LIKE '_'. It doesn't matter whether you use lookup_actions_p.action LIKE '_%' or don't test for the players actions at all in the second column but if you are using lookup_actions_p.action LIKE '_' it's not going to work correctly.

Naeco wrote:I think I may have understood what was going on.

The problem seems to be with with the <2bb effective stack allin that were counted as minraise. It is a situation I wanted to exclude so I added

and (tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack )

and it seems to be okay. What do you think?

As per my original reply tourney_hand_player_statistics.amt_p_raise_facing is the size of the last raise faced by the player so in non-heads up hands that might not give you what you want. If you want to compare the size of the preflop 2Bet to the players effective stack you should again use tourney_hand_player_statistics.amt_p_2bet_facing.