Advanced Steal Stats for NLHE

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Advanced Steal Stats for NLHE

Postby kydechuk01 » Mon Jun 20, 2011 1:35 am

Hi! I trying to build good advanced popup for steals (and when upload it to the site if this somebody will have interest) and need some help.

Now it looks like this:

[ img ]

And some stats I using now are just common and not specified by stealing position or situation (Fold to resteal, 4Bet vs resteal for example only for LatePos, but it very need to be separated by CO & BU positions).

I thought to build those stats by myself but it looks hard for me. So i make a list of wanted stats for Steal and would be happy if somebody can help to make the formulas for it.

Preflop Steals statistics:

1. If player ATS:
1.1) Fold Steal to Blind Reraise (CO)
1.2) Fold Steal to Blind Reraise (BU)
1.3) Call Blinds Reraise (CO)
1.4) Call Blinds Reraise (BU)
1.5) Call BB Reraise (SB)
1.6) 4-Bets vs Blind Reraise (CO)
1.7) 4-Bets vs Blind Reraise (BU)
1.8) 4-Bets vs BB Reraise (SB)

2. If player defends in Blinds:
2.1) Fold to Preflop 4Bet after Steal Reraising (SB)
2.2) Fold to Preflop 4Bet after Steal Reraising (BB)

Postflop in Stealed pots:

3. If player Steals (Flop/Turn/River):
3.1) CBet
3.2) Fold CBet to Raise
3.3) Fold to Float
3.4) Fold to Donkbet

4. If player defends in Blinds (Flop/Turn/River):
4.1) Fold to CBets
4.2) Raise vs CBets
4.3) Float

Also I hope these stats are seems useful not only for me and can appear in the PT releases by default in the future.
kydechuk01
 
Posts: 174
Joined: Sat Jun 27, 2009 4:30 am
Location: Russia

Re: Advanced Steal Stats for NLHE

Postby WhiteRider » Mon Jun 20, 2011 3:35 am

I think some of these are in kraada's Advanced HUD so before I build any of these specifically, let's see what he already has.

I'll give you a few starting points, though.
The Tutorial: Custom Reports and Statistics has a section on making position-specific versions of existing stats, so that should get you most of (1).
You can check for 4-betting using the database field "holdem_hand_player_statistics.flg_p_4bet" (see the columns cnt_p_4bet & cnt_p_4bet_opp). For actions facing 4-bet see the stat "Fold to 4Bet" (for 2).
(3) and (4) are combinations of existing stats too - you can take the check for stealing or defending from the existing stats and make new versions of the cbet/float/donk stats, as described in the Tutorial: Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Advanced Steal Stats for NLHE

Postby kydechuk01 » Sat Jun 25, 2011 8:01 am

Thank you for guides! Now I almost made preflop, 1.1 - 1.8 are done.

[ img ]

New stats here:
Fold Steal to Blind Reraise (CO)
Fold Steal to Blind Reraise (BU)
Att to Steal & Call 3-Bet
Att to Steal & Call 3-Bet (BU)
Att to Steal & Call 3-Bet (CO)
Att to Steal & Call 3-Bet (SB)
Att to Steal & 4-Bet
Att to Steal & 4-Bet (BU)
Att to Steal & 4-Bet (CO)
Att to Steal & 4-Bet (SB)


And now need some help with 2.

2) Fold to Preflop 4Bet after Restealing

New stat: Fold Resteal to 4-Bet
New stat: Fold Resteal to 4-Bet (SB)
New stat: Fold Resteal to 4-Bet (BB)
New stat: Fold Resteal to 4-Bet (BB vs SB)

I took the old stat for example: 3Bet Preflop And Fold to 4Bet
It's exp: (cnt_p_3bet_fold / cnt_p_3b_face_4b) * 100

So I made these columns for new stats:

new column: cnt_steal_3bet_face_4b
new column: cnt_steal_3bet_face_4b_SB
new column: cnt_steal_3bet_face_4b_BB
new column: cnt_steal_3bet_fold
new column: cnt_steal_3bet_fold_SB
new column: cnt_steal_3bet_fold_BB

Expressions for them:
column: cnt_steal_3bet_face_4b
exp: sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

column: cnt_steal_3bet_face_4b_SB
exp: sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

column: cnt_steal_3bet_face_4b_BB
exp: sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

column: cnt_steal_3bet_fold
exp: sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

column: cnt_steal_3bet_fold_SB
exp: sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

column: cnt_steal_3bet_fold_BB
exp: sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

Can you check it above, am I correct?

And now I'm still cant understand how to make the last stat: Fold Resteal to 4-Bet (BB vs SB)

How to use this expressions like lookup and action correctly? (sum(if[lookup_actions_p.action LIKE 'R%' AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0]))
kydechuk01
 
Posts: 174
Joined: Sat Jun 27, 2009 4:30 am
Location: Russia


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests