Preflop raise % in the SB

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

Preflop raise % in the SB

Postby Uiko » Wed May 21, 2008 5:20 pm

I want the preflop raise % in the SB in my HUD.

So I made this:

sum(if[holdem_hand_player_statistics.flg_p_first_raise = true AND holdem_hand_player_statistics.position = 9 , 1, 0])

But thats only the % of his open raise.

I want the PFR stats for exactly the SB like its displayed in PT3.

Whats the code for that?
Uiko
 
Posts: 50
Joined: Sat Jan 26, 2008 7:22 pm

Re: Preflop raise % in the SB

Postby WhiteRider » Wed May 21, 2008 5:21 pm

Isn't there a flg_p_raise too?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Preflop raise % in the SB

Postby Uiko » Wed May 21, 2008 5:25 pm

yeah, but

sum(if[holdem_hand_player_statistics.flg_raise_p = true AND holdem_hand_player_statistics.position = 9 , 1, 0])


isnt a valid expression apparantly according to PT3.
Uiko
 
Posts: 50
Joined: Sat Jan 26, 2008 7:22 pm

Re: Preflop raise % in the SB

Postby WhiteRider » Wed May 21, 2008 6:22 pm

Got it!
You need to use cnt_p_raise > 0.
This field tells you how many times you raised preflop.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Preflop raise % in the SB

Postby Uiko » Wed May 21, 2008 7:12 pm

Yes thats it!

Thank you. :D
Uiko
 
Posts: 50
Joined: Sat Jan 26, 2008 7:22 pm


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

Who is online

Users browsing this forum: No registered users and 1 guest