RFI

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

RFI

Postby js2002 » Sun Oct 12, 2008 6:02 pm

Hi WhiteRider,

do you know how the flag open_raise (and opp) is defined for the BigBlind? If the SB completes is it a opp to openraise or not because the complete is definited as limp?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby WhiteRider » Mon Oct 13, 2008 4:07 am

The BB can never open-raise because if they get chance to act then someone else must have already entered the pot.
(They could make the first raise, but it wouldn't be an open-raise).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI

Postby js2002 » Mon Oct 13, 2008 4:21 am

http://rapidshare.com/files/153516925/Desktop.rar.html

I put these into repository.
Since you mentioned the difference between open and first I have to check em, but I think they are alright.
If you are interested you can check em as well.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby js2002 » Mon Oct 13, 2008 4:24 am

Tought again,

so I just have to change the BB Stat and remove the "open" then it will be correct.

Is there a flag for firstraise opp ?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby WhiteRider » Mon Oct 13, 2008 4:48 am

No, there is no flag for first raise opp.

I built a column to count limp opportunities (which is the same thing - if you can limp, you can make the first raise):

cnt_p_limp_opp = sum( if[ (NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(holdem_hand_player_statistics.flg_blind_b), 1 , 0 ] )

Note: this is in the 'holdem cash player statistics' section, and includes a check for being in the BB where you can't limp, so actually to get a first raise opp you would need to remove the check for being in the BB.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI

Postby js2002 » Mon Oct 13, 2008 5:00 am

Hi,

thx a lot I understand, but why

"OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)"
Last edited by js2002 on Mon Oct 13, 2008 5:04 am, edited 1 time in total.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby js2002 » Mon Oct 13, 2008 5:04 am

Damn error again:

The question was:

Why do you check "did player limp?" in a counter for the opportunities?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby js2002 » Mon Oct 13, 2008 5:48 am

Tested and MY RFI stats say 20% in BB so they work but I dont now why because after your definition they "are not allowed" to show anything else then 0%.

Ur stat is also not usable because a chance to limp is != a chance to raise first

If theres 1 limper before me I have the chance to limp but NOT the chance to RFI.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: RFI

Postby WhiteRider » Mon Oct 13, 2008 8:36 am

You said you wanted to build a "first raise" stat, not a "raise first in" stat!
They are different. "Raise first in" means no-one has acted before you, "first raise" means no-one has raised before you.

You need the additional checks in the 'limp opportunity' column, because you can face a raise AFTER you limp (or raise) - so just checking for "NOT (face a raise)" misses some cases. You might have an opportunity to limp and still face a raise.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI

Postby js2002 » Mon Oct 13, 2008 8:41 am

WhiteRider wrote:You said you wanted to build a "first raise" stat, not a "raise first in" stat!
They are different. "Raise first in" means no-one has acted before you, "first raise" means no-one has raised before you.

Ah, we misunderstood here. I mean(t) RFI (no action before me)

You need the additional checks in the 'limp opportunity' column, because you can face a raise AFTER you limp (or raise) - so just checking for "NOT (face a raise)" misses some cases. You might have an opportunity to limp and still face a raise.

ok tu!
Do u get all opp with this stat?


js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Next

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

Who is online

Users browsing this forum: No registered users and 2 guests