Call open raise

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

Call open raise

Postby ArcaneX » Mon Aug 30, 2010 11:29 pm

Hey.

I am looking for a stat that tells me how often a player calls an open raise. IE not when there has been any 3betting, or he is in the blinds. Only when there has been a raise and he has no money invested and calls outside of the blinds.

Hope u get what i mean ;)

Thanks in advance.
ArcaneX
 
Posts: 5
Joined: Wed Aug 13, 2008 5:10 pm

Re: Call open raise

Postby WhiteRider » Tue Aug 31, 2010 4:45 am

The stat that you want is very similar to the built-in stat "CCPF", which is "Cold Call Preflop". The only difference which you want is that the player is facing only a single raise.
To do that you can make a copy of the stat and change it.

The change you need to make is to add in a check for the opportunity to make a 3-bet - this means that they are facing the first raise.
The existing "cold call" part of the stat will do the rest.
To check for a 3-bet opportunity you use: holdem_hand_player_statistics.flg_p_3bet_opp

Have a look at the tutorial How To: Make a New Version of a Statistic.

For instance, your new version of the cnt_p_ccall column would be this (with the bit you need to add in bold):

sum(if[holdem_hand_player_statistics.flg_p_ccall AND holdem_hand_player_statistics.flg_p_3bet_opp, 1, 0])
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Call open raise

Postby ArcaneX » Tue Aug 31, 2010 10:38 pm

Allright thanks i will try it out.

But when player1 raises, player2 3bets and player 3 calls <-- isnt that also a coldcall? Or am i mistaken?
ArcaneX
 
Posts: 5
Joined: Wed Aug 13, 2008 5:10 pm

Re: Call open raise

Postby kraada » Wed Sep 01, 2010 8:40 am

Yes it is, but in that situation the player cannot 3-bet as someone else already has.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Call open raise

Postby ArcaneX » Tue Sep 07, 2010 1:49 pm

Ah yeah ofcourse :)

Thanks for your help
ArcaneX
 
Posts: 5
Joined: Wed Aug 13, 2008 5:10 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests