SB+BB Combined Call vs Steal and C-bet Success vs 1 and 2

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

SB+BB Combined Call vs Steal and C-bet Success vs 1 and 2

Postby guitarizt » Sat Nov 12, 2011 4:36 am

For my hud I'd love to have a call vs steal stat that combines the SB and BB so I can just look at one number instead of two. I have call vs steal and 3-bet vs steal next to each other so I can just add them up and figure out quickly about how often they're folding.

For the reports tab it'd save me a lot of time to have a flop c-bet success vs 1 player and a flop c-bet success vs 2 players stat. Then I can add the stat to the positions tab and get an overall feel for how often people are folding. I know I can filter for this, but it's really cumbersome especially when I'm filtering by flop texture types. I have to keep changing the filters constantly.

I looked at the tutorials in the forum but I'm afraid that this stuff is beyond me unless I dedicate a ton of time to it. I really just need these two stats so far.
guitarizt
 
Posts: 90
Joined: Fri Mar 07, 2008 5:18 pm

Re: SB+BB Combined Call vs Steal and C-bet Success vs 1 and

Postby guitarizt » Sat Nov 12, 2011 5:31 am

You know what I actually like having the call sb and call bb separate. I had no idea people's ranges would vary so much so I'm gonna leave it up. I guess that just leaves the c-bet success stat for the reports tab.
guitarizt
 
Posts: 90
Joined: Fri Mar 07, 2008 5:18 pm

Re: SB+BB Combined Call vs Steal and C-bet Success vs 1 and

Postby WhiteRider » Sat Nov 12, 2011 6:04 am

To make a version of a stat for exactly two players seeing the flop (so "against 1 player") you need to add this to the column expressions:

holdem_hand_summary.cnt_players_f = 2

So if the "cnt_f_cbet_success" column is:

sum(if[holdem_hand_player_statistics.flg_f_cbet AND NOT(holdem_hand_player_statistics.flg_t_saw) AND NOT(holdem_hand_player_statistics.flg_f_face_raise), 1, 0])

..duplicate it (click "Dup") and add the above so that your new version looks like:

sum(if[holdem_hand_player_statistics.flg_f_cbet AND NOT(holdem_hand_player_statistics.flg_t_saw) AND NOT(holdem_hand_player_statistics.flg_f_face_raise) AND holdem_hand_summary.cnt_players_f = 2, 1, 0])

Do the same for the opportunities column by duplicating "cnt_f_cbet" and changing your copy to:

sum(if[holdem_hand_player_statistics.flg_f_cbet AND holdem_hand_summary.cnt_players_f = 2, 1, 0])

Duplicate the CBet Success stat and change the copy to use your new columns (and update the name, description and title) and you're there.

For other versions with different numbers of players to the flop just replace the "2" with other numbers, or use " > 2", for instance.

Tutorial: Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: SB+BB Combined Call vs Steal and C-bet Success vs 1 and

Postby guitarizt » Sat Nov 12, 2011 3:30 pm

Wow definite learning curve as this still took me about an hour to get everything in there, but the numbers check out and it works now ty! I think I'm starting to get it. I can easily do a combined call vs steal now if I wanted to.
guitarizt
 
Posts: 90
Joined: Fri Mar 07, 2008 5:18 pm

Re: SB+BB Combined Call vs Steal and C-bet Success vs 1 and

Postby WhiteRider » Sat Nov 12, 2011 4:19 pm

Great!
There is a bit of a learning curve to building custom stats, but it's well worth persevering with - it really opens up the possibilities of PokerTracker. If you have any questions as you start to build other stats we'll be happy to help you.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 2 guests