Skip to forum
PT4: How often does...
 
Notifications
Clear all

PT4: How often does the pool fold to different 3Bet Sizes

5 Posts
2 Users
0 Reactions
3,615 Views
mazurholdem
Joined: 18.01.2015

Hello everyone,

I have another sizing-related question.

I would like to know how often the pool folds to 3bets in different sizes (e.g. 2 times the openraise-sizes,3 times the openraise-size etc.).

I can easily do that by running a player report on me, adding the stat "3Bet PF Success" and then adding the filter "Actions and Opportunities->Preflop->Preflop Bet Sizing->3Bet-Size Between X and Y". The problem is, this only catches the situations where I was the preflop 3-bettor. That is only 1/6 of the data available and it is not even the interesting part of the data, because I use pretty standard raise sizes.

Another solution I tried is this:
1. Running an all players report on my pool.
2. Adding the stat "Fold to PF 3Bet After Raise".
3. Adding the same filter as above.
Problem: The stat "Fold to PF 3Bet After Raise" shows a blank, apparently because the above filter filters for situations when the active player himself 3betted with a Sizing between X and Y. And if the active player was the 3bettor, he will of course never fold to a 3bet in that hand.

The same problem occurs when I use the filter "Actions and Opportunities->Preflop->Actions Encountered With Sizes->Preflop Action Faced With Size->3Bet Preflop Between X and Y. That one I find especially mean, because you would expect the filters under the heading "Preflop Actions Faced With Size..." to be Facing-Action-Stats only.X(

The last thing that I've tried is this:
1. Running an all players report on my pool again.
2. This time adding the stat "3Bet PF Success".
3. Again using one of the two above sizing filters.
Problem: The results include hands where I was the preflop 2bet-folder. This messes up the results. And if I filter for "NOT(Player is Hero)", I only remove the hands where I was the active player (e.g. the 3-bettor). If anything, I would have needed a filter that removes the hands where someone else was the 3-bettor and I was the 2bet-folder.

Now, this is where I'm stuck. Is there someone who knows how to find out how often my pool folds to 3bets of different sizes including the hands where someone else was the 3bettor and excluding the hands where I was the 2bettor?

Thank you in advance

Edit: I have the same problem when I try to figure out how much the pool folds their blinds to different preflop-openraise-sizes. Only here I can't even get 1/6 of the data because there is no preflop-openraise-success-stat. If someone knows a solution for that, it would already help a lot and maybe building on that I can figure out something for the 3bet-problem.


Reply
Quote
4 replies
PokerTracker
Joined: 07.06.2011

Depending on the filter you are using you can filter out the hands you 3bet OR the hands you 2bet using "NOT(Player is Hero)" but you cannot filter out both at the same time using simple filters and something like that would require a complex subquery. The easiest solution is to use the following filter expression via the blue Filters link so you can filter out the hands where you VPIP'd:

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps where chps.flg_hero and not(chps.flg_vpip))

- Rob


Reply
Quote
mazurholdem
Joined: 18.01.2015

Hello Rob,

thank you for your answer. This solves a big part of the problem. Now I can run a working report on a very big part of the database (probably about 75%).

The only problem remaining is that the hands where I was the 3bettor are missing. I have a feeling this can be easily corrected by changing the last expression (chps.flg_vpip) into something like chps.flg_2betted. (which doesn't exist, of course)

This brings me to a different question: Where do I learn to use these "expression filters" like you did? I can't find anything on the internet but forum entries where a guy has one specific problem and someone else on the forum solves it for him using expression filters. On the PT4-Websites, there are guides on how to configure a report, how to use the simple filters and how to create custum stats. None of that is what I'm looking for. But if there isn't a tutorial, there must at least be some kind of documentation about the objects of that mysterious coding language that you used. For exemple: what other variables does the object "cash_hand_player_statistics" contain? So far the only thing I know is, that there are "id_hand" and "flg_vpip".

Where can I find information like this apart from asking detail questions in forums or looking for forum entries of other people who had the same questions before me? That would probably solve all my problems ;)

Regards
mazur


Reply
Quote
PokerTracker
Joined: 07.06.2011

Originally posted by mazurholdem
The only problem remaining is that the hands where I was the 3bettor are missing. I have a feeling this can be easily corrected by changing the last expression (chps.flg_vpip) into something like chps.flg_2betted. (which doesn't exist, of course)

Try this instead:

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps where chps.flg_hero and not(chps.flg_p_first_raise))

Originally posted by mazurholdem
This brings me to a different question: Where do I learn to use these "expression filters" like you did? I can't find anything on the internet but forum entries where a guy has one specific problem and someone else on the forum solves it for him using expression filters. On the PT4-Websites, there are guides on how to configure a report, how to use the simple filters and how to create custum stats.

Custom statistics are built using columns and these columns contain the same expressions with some extra formatting so they can be used in the HUD and/or PokerTracker 4 reports. This guide covers the basics on custom statistics creation and this guide has a deeper walkthrough. The latter was written for PokerTracker 3 but the techniques all apply to PokerTracker 4, the interface is just slightly different. While we have not published the schema like we did for PokerTracker 3 the meaning of database fields haven't changed in any significant way. Also PokerTracker forum member 'Bininu' made their own schema document for PokerTracker 4 available in this thread.

- Rob


Reply
Quote
mazurholdem
Joined: 18.01.2015

Thank you!!


Reply
Quote