Cbet % vs, 1 and more opponents

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

Cbet % vs, 1 and more opponents

Postby Lativijus » Wed May 11, 2011 12:14 pm

hi, is there stats that would show villains cbet% headsup and cbet% vs multiple opponents, out and in position in full ring?
Lativijus
 
Posts: 19
Joined: Tue Sep 28, 2010 8:13 am

Re: Cbet % vs, 1 and more opponents

Postby kraada » Wed May 11, 2011 12:22 pm

Not by default but these could certainly be built as custom statistics. See the Tutorial: Using Custom Statistics and Reports for details on how to create custom statistics.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet % vs, 1 and more opponents

Postby gazavat » Sun May 29, 2011 11:09 pm

i am interested in these stats as well
gazavat
 
Posts: 88
Joined: Sat Feb 05, 2011 2:04 am

Re: Cbet % vs, 1 and more opponents

Postby WhiteRider » Mon May 30, 2011 4:50 am

You can build a new version of the CBet stat that you're interested in to check for the number of players seeing the flop. The database field you'll need for that is:

holdem_hand_summary.cnt_players_f

See the Tutorial: Custom Reports and Statistics for a walkthrough of how to create a new version of a stat.

If you need further help setting this up, please give us an example stat you'd like to see and describe exactly what circumstances you'd like to count.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet % vs, 1 and more opponents

Postby SillyMe » Tue Jan 10, 2012 12:00 pm

Hi,

I'm interested in examining how raise percentages vary depending on the number of players after the acting player.

For example, I would like to make a stat called cnt_pfr_3plyrs_after that would count the number of times a preflop raise was made with 3 opponents after the raising player.

And I would like to make a stat called cnt_pfr_3plyrs_after_opps to count the number of opportunities that a preflop raise with 3 opponents after the raising player could be made.

What fields should I be querying in order to compose the above stats?

I've made some custom stats before so I'm familiar with the process and the tutorial mentioned in this thread.
SillyMe
 
Posts: 8
Joined: Tue Jun 21, 2011 11:41 pm

Re: Cbet % vs, 1 and more opponents

Postby kraada » Tue Jan 10, 2012 12:50 pm

If you just mean players left to act who have not yet acted you can check the player's position - if their position is between 1 and 7 there are always 3 or more players left to act after them (position 1 is the cutoff so there is button, sb, bb).

If you mean to include limpers you wouldn't be able to get a completely accurate count using PT3 - we don't store the number of limpers in the database in a way you can easily access it (we have rectified this for PT4). You can get fairly close though by at least checking for any limpers when you're on the button - if there are any limpers there are at least 3 opponents left to act (SB, BB, 1 or more limpers). The only times you really have trouble are in the blinds. See the built in stat RWPC's opportunities column for a column that counts up hands where you have limpers in front of you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet % vs, 1 and more opponents

Postby SillyMe » Tue Jan 10, 2012 11:12 pm

Thanks for the reply.

So if I understand correctly, I can get a number for "Players After Me Yet To Play" in the form:

Code: Select all
2 + holdem_hand_player_statistics.position

where the 2 is to count the blinds.

I want to make the same queries on the flop, turn and river. On the flop, for example, let's say a player in first position raised, I want to investigate how many opponents that player was facing. Is there a ready-made stat for that too? I assume the the 'position' stat discussed above is the same for the entire hand and doesn't update for subsequent streets as players fold. So in this case some new idea will be required.
SillyMe
 
Posts: 8
Joined: Tue Jun 21, 2011 11:41 pm

Re: Cbet % vs, 1 and more opponents

Postby WhiteRider » Wed Jan 11, 2012 4:35 am

That will work except when you are in the blinds - when you're in the SB your position is 9, for example (the BB is 8). So you'll need to check for position < 8 as well - if position = 8 then players after you = 1.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet % vs, 1 and more opponents

Postby SillyMe » Wed Jan 11, 2012 4:59 am

Ok cool, I understood the blinds being 8 and 9, I just didn't include it in my description but thanks for pointing it out regardless.

More importantly though is the second part of my question - does querying position work beyond preflop?

If not, how can I find out the number of players yet to play after a raise post-flop?
SillyMe
 
Posts: 8
Joined: Tue Jun 21, 2011 11:41 pm

Re: Cbet % vs, 1 and more opponents

Postby kraada » Wed Jan 11, 2012 9:28 am

Postflop you won't be able to intuit which of the positions called just by using position number. We do have some tools to help you though - holdem_summary.cnt_players_f is the number of players that reached the flop (and _t is turn and _r is river).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 18 guests