CB IP/OOP and Float

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

CB IP/OOP and Float

Postby parraka » Fri Feb 18, 2011 11:35 am

Hi again, if you send me to the hell i ll understand, i ask you for another stats, the lasts:

CB Flop IP, CB Flop OOP, CB Turn IP, CB Turn OOP, Fold to CB Flop iP, Fold to CB Flop OOP, Fold to CB Turn IP, Fold to CB Turn OOP, Raise CB Flop IP, Raise CB Flop OOP, Raise CB Turn IP, Raise CB Flop OOP, Float Turn in 3bet Pots, Call 3bet IP and Call 3bet OOP.

I would try to make them if i had more time and i knew what I do. I am afraid to crush the Database again and lose my custom stats and my hud. If you make me the favour i ll be so thanked you.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: CB IP/OOP and Float

Postby kraada » Fri Feb 18, 2011 12:48 pm

Hi,

I can't make all of those stats for you right now but I can explain what you need to do in order to build them yourself.

Click Configure --> Configure Statistics, click on Holdem Cash Player Statistics and go to the Statistics tab. Find the stat you want to make (say Flop Cbet), then click on it. Look in the Value Expression - that's what calculates the stat. Now go to the Columns tab. Look for the first column you saw in the numerator of the value expression (in this case cnt_f_cbet), and click on it. Click Dup (which duplicates it), and change the name to something slightly different depending on what you're making (for example, Cbet Flop In Position).

All of these stats will have the structure sum(if[X, 1, 0])

What we want to change is the X. To make it 'in position' add:

AND holdem_hand_player_detail.flg_f_has_position

to the X before the , and after the end of whatever is there.

For out of position it's:

AND not(holdem_hand_player_detail.flg_f_has_position)

Then go back to the stats tab, click Dup on the stat that you've been working from, change the columns to their new names, change the name and description appropriately and on the Format tab change the Title as well. Then save your stat.

Repeat for all stats you want to build based on standard ones. Then update the cache from the Database --> Housekeeping section and you should be good to go.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CB IP/OOP and Float

Postby parraka » Fri Feb 18, 2011 1:37 pm

Thx, this looks like easy. Do i have to use always "AND holdem_hand_player_detail.flg_f_has_position"?
Or i have to change flg_"f/t/r"_has_position if the action is in flop, turn or river?
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: CB IP/OOP and Float

Postby WhiteRider » Fri Feb 18, 2011 4:26 pm

Exactly: _f_ is flop, _t_ is turn and _r_ is river.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: CB IP/OOP and Float

Postby parraka » Fri Feb 18, 2011 4:31 pm

Kaadra doesnt explain me nothing...

Nah its a joke, thanks both, i made the stats, I only have to change this.
Edit: One thing, it works me with f, t and r. How i make it for preflop? P dont works xd.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: CB IP/OOP and Float

Postby WhiteRider » Fri Feb 18, 2011 5:42 pm

You are not in or out of position preflop since everyone is involved. You can use "holdem_hand_player_statistics.position" preflop - this is the number of seats away from the button. 0 is the button, 1 is the cutoff, etc. The BB is always 8 and the SB is always 9, regardless of the number of players involved.
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 0 guests