Preflop 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

Preflop raise

Postby winneronline » Thu Jul 31, 2008 6:44 pm

Hi there guys. I have one simple question. I read the PT3 DB Schema and i d like to know how the preflop raise ( regardless the position of the player ) is calculated. There is the flg_p_first_raise which takes a value of true or false if a player raises first preflop. But shouldn't a stat exist to inform about the opportunities to raise first preflop? The division of those two would be the preflope raise.
winneronline
 
Posts: 11
Joined: Fri Jan 25, 2008 3:44 pm

Re: Preflop raise

Postby WhiteRider » Fri Aug 01, 2008 4:51 am

I think this is what you're looking for?
holdem_hand_player_statistics.flg_p_open_opp

PFR is the % of times the player made any raise preflop out of all hands. This stat does not count opportunities since you ALWAYS have the chance to raise PF (unless the betting is capped or all-in before it gets to you).

EDIT: RFI (raise first in) takes account of opportunites to act first.
In fact, RFI is how often you raised when you acted first.
(cnt_p_first_raise / (cnt_p_first_raise + cnt_first_limp)) * 100
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Preflop raise

Postby winneronline » Fri Aug 01, 2008 5:50 am

Thx mate. Your answer really helped.
winneronline
 
Posts: 11
Joined: Fri Jan 25, 2008 3:44 pm


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

Who is online

Users browsing this forum: No registered users and 15 guests

cron
highfalutin