Questions about PFR

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

Questions about PFR

Postby bloodndef » Fri Apr 17, 2009 4:52 pm

'holdem_hand_player_statistics.cnt_p_raise > 0' counts all raises pf, so it is my understanding it is including 3-bets, 4-bets, etc.

and 'holdem_hand_player_statistics.flg_p_first_raise' is the same as a 2-bet

Is this correct?

Therefore if I wanted to make a stat depicting how often a player raised on the button (either first in or with previous callers) but the raise was not a 3-bet or 4-bet, I would make this column:

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

Correct?

Thank you!
bloodndef
 
Posts: 99
Joined: Fri Feb 27, 2009 1:28 am

Re: Questions about PFR

Postby kraada » Fri Apr 17, 2009 6:17 pm

That would be correct, yes.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests