PT4 Database Schema

[Mr Tiger]

Please, explain new fields (or, maybe, there is a thread with new fields explanation):

cash_hand_summary.str_aggressors_p LIKE '80%'
cash_hand_summary.str_actors_p LIKE '0%'

3bet vs BTN/CO open includes 3bets-squeezes (for example, BTN opens, SB calls, BB 3bets), right?

[WhiteRider]

This thread explains the actors and aggressors fields.

3bet vs BTN/CO open includes 3bets-squeezes (for example, BTN opens, SB calls, BB 3bets), right?

Yes - all that is specified is that the BTN or CO opened and the player made a 3bet (or had an opportunity to).

[Mr Tiger]

Thanks for explanation.
I want to create "3bet vs Isolate" (3bet vs raise vs limp) stat. I've written this numerator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '_%0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_limp), 1, 0])

and denominator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet_opp AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '_%0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze_opp or cash_hand_player_statistics.flg_p_open_opp), 1, 0])

But, looks like, it doesn't work as I expect Can I use "_" in cash_hand_summary.str_actors_p LIKE field? By typing "_" i mean, somebody made action before BTN. As BTN is the first raiser, this somebody is limper.

[Mr Tiger]

One more short question.

Code: Select all

cash_hand_player_statistics.flg_p_3bet_def_opp AND cash_hand_player_statistics.enum_p_3bet_action='F'

I saw this string in one of default stats. "cash_hand_player_statistics.flg_p_3bet_def_opp" is not mandatory here, right?

[kraada]

How is it not working? That looks like it should work.

[Mr Tiger]

The HUD shows very high values. For example, when I tick SB position: 14% vs steal, 44% vs isolate; 18% vs steal, 60% vs isolate; 10% vs steal, 28% vs isolate. Sample size 10k-60k hands. Checked 5 players in SB and BB.

[kraada]

Look in My Reports by creating an All Players report. Is that true for everybody?

[Mr Tiger]

Yes, for everybody.

3bet vs BTN Open 1vs1 numerator and denominator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze), 1, 0])

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze), 1, 0])

3bet vs BTN Isolate 1vs1 numerator and denominator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '_%0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_limp), 1, 0])

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet_opp AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '_%0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze_opp or cash_hand_player_statistics.flg_p_open_opp), 1, 0])

[kraada]

I still don't see any problems with it as written. Maybe I'm missing something but it doesn't seem obvious whatever it is.

What you can do to make sure this is picking out the right spots though is to add a filter expression in the blue Filters link in a custom Hand report and then you can see what hands match your stat. To do this, just pull off the "sum(if[" at front and ", 1, 0])" at the end. So one filter would be:

cash_hand_player_statistics.flg_p_3bet AND cash_hand_summary.str_aggressors_p LIKE '80%' AND cash_hand_summary.str_actors_p LIKE '_%0%' AND NOT(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_limp)

If you could find a hand that was matching that shouldn't or vice versa the details of that hand would be a big help in deciphering what is going on here.

[Mr Tiger]

Done. There are many situations, where I just resteal SBvsBTN. But not all resteals fit. Examples:
(FALSE/TRUE means numerator doesn't fit, denominator fits)

TRUE/TRUE:

partypoker - $2 NL (6 max) - Holdem - 6 players
Hand converted by PokerTracker 4

BB: 175.42 BB
UTG: 40.45 BB
MP: 150.59 BB
CO: 129.03 BB
BTN: 43.25 BB
Hero (SB): 147.94 BB

Hero posts SB 0.5 BB, BB posts BB 1 BB

Pre Flop: (pot: 1.5 BB) Hero has J K

fold, fold, fold, BTN raises to 2 BB, Hero raises to 5.5 BB, fold, BTN calls 3.5 BB

Flop: (12 BB, 2 players) 8 K A
Hero checks, BTN checks

Turn: (12 BB, 2 players) Q
Hero bets 6 BB, BTN calls 6 BB

River: (24 BB, 2 players) 4
Hero checks, BTN bets 11.4 BB, fold



FALSE/FALSE:

partypoker - $4 NL - Holdem - 9 players
Hand converted by PokerTracker 4

BTN: 105.05 BB
Hero (SB): 100 BB
BB: 100 BB
UTG: 134.02 BB
UTG+1: 111.63 BB
UTG+2: 109.75 BB
MP: 135.36 BB
MP+1: 100 BB
CO: 100 BB

Hero posts SB 0.5 BB, BB posts BB 1 BB

Pre Flop: (pot: 1.5 BB) Hero has 5 6

fold, fold, fold, fold, fold, fold, BTN raises to 3 BB, fold, BB calls 2 BB

Flop: (6.5 BB, 2 players) A J 2
BB checks, BTN checks

Turn: (6.5 BB, 2 players) 9
BB checks, BTN checks

River: (6.5 BB, 2 players) 3
BB bets 4.63 BB, fold



FALSE/TRUE:

partypoker - $2 NL (6 max) - Holdem - 5 players
Hand converted by PokerTracker 4

BB: 110 BB
UTG: 100 BB
CO: 143.37 BB
BTN: 162.83 BB
Hero (SB): 115.44 BB

Hero posts SB 0.5 BB, BB posts BB 1 BB

Pre Flop: (pot: 1.5 BB) Hero has 2 Q

fold, fold, BTN raises to 3 BB, fold, BB raises to 7 BB, BTN calls 4 BB

Flop: (14.5 BB, 2 players) 4 A 8
BB bets 10.33 BB, fold



There are also many "right" situations, where both numerator and denominator works as they should.
All TRUE/TRUE situations I saw includes reisolates and simple resteals (Hand 1 - resteal).
All FALSE/TRUE situations I saw includes reisolate and resteal opportunities. But, as you can see from Hand 1, not all resteal opportunities count (I've seen many). And I've seen no FALSE/FALSE hands, where I have opportunity to reisolate.

So, not only reisolates, but also resteals count (can't say, all or not all). And not all resteal opportunities count. This explains high values. But I have no clue, why some resteal opportunities count and some don't