new* stat "steal unraised pot"

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

new* stat "steal unraised pot"

Postby js2002 » Tue Mar 31, 2009 1:41 pm

Hi,

I´d like to have a stat that say how aggro villian is in unraised pots.

1. How do I recognize unraised pots? "not callpfr and not raise pf" f.e. ?!

2. definition question: what shoulb be in the actions: the bets the raises? dont know / not sure yet
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat "steal unraised pot"

Postby WhiteRider » Tue Mar 31, 2009 2:29 pm

Is this different to the built-in RWPC (Raise With Previous Callers) stat, which shows the percentage of times someone raises when there is at least one limper in the pot before them, but no raise?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat "steal unraised pot"

Postby js2002 » Tue Mar 31, 2009 2:47 pm

yes, I mean steal pot like the one of HEM. f.e. at flop
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat "steal unraised pot"

Postby WhiteRider » Tue Mar 31, 2009 4:19 pm

So you want to know how often a player opens the betting on the flop when they have the chance?
holdem_hand_player_detail.flg_f_open
holdem_hand_player_detail.flg_f_open_opp
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat "steal unraised pot"

Postby js2002 » Tue Mar 31, 2009 5:37 pm

thats a good hint, but how do I check the unraised pot, so how do I reconize that the pot is not raised?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat "steal unraised pot"

Postby WhiteRider » Wed Apr 01, 2009 7:14 am

If you're talking about the flop then it's either un-opened (which the DB fields I gave you will work) or someone has already bet (in which case they won't).
If you want a stat that says how often they raise on the flop when someone has bet that's different and there is already a stat for "Raise F Bet" which shows how often someone raises when facing a bet on the flop.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat "steal unraised pot"

Postby js2002 » Wed Apr 01, 2009 8:24 am

at first I build thesteal pot thing with a simple open bet.
but I still dont get it: How do I find out that the pot is unraised? a preflop stat like p_notopened, does this exist?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat "steal unraised pot"

Postby WhiteRider » Wed Apr 01, 2009 10:01 am

Preflop and flop have slightly different naming convention, so it confuses things a bit when you talk about both at once.
On any street "unopened" means no-one has yet put any money in on this street (other than blinds).
"Unraised" is a slightly different case since you can't "bet" preflop, you can only call or raise so unraised might mean someone has called which is a passive action; but on the flop "unraised" could mean that someone has "bet" which is an aggressive action.

As I said in my first reply, RWPC is how often someone made the first raise preflop when at least one player has already called.
RWPC has a column 'cnt_p_facing_limpers'.

There is also a column 'cnt_p_first_raise', built from the database field 'holdem_hand_player_statistics.flg_p_first_raise', which counts the number of times the player was the first to raise preflop.

As well as
holdem_hand_player_detail.flg_f_open
holdem_hand_player_detail.flg_f_open_opp
there are the same fields for every street, so preflop it is:
holdem_hand_player_detail.flg_p_open
holdem_hand_player_detail.flg_p_open_opp
which indicate whether the player was (or had the opportunity to be) the first to enter the pot (other than the blinds).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* stat "steal unraised pot"

Postby js2002 » Wed Apr 01, 2009 10:17 am

It think you dont understand what I want. I need the preflop things and the flop things in ONE stat!

Which flop is seen unraised? The one where Villian did not call a preflop raise or did not raise self.
NOT callpfr AND not ccpf AND saw_flop
would be the part I can do.
adding AND f_open AND f_bet this would be the first agressive action at flop
BUT: I need to check if the pot is "unraised" !!!
I cant use p_limp, because villian could also complete the SB or be in the BB.

So this doesnt cover all for the stat "Steal (unraised) Pot":
(NOT callpfr AND not ccpf AND saw_flop AND f_open AND f_bet)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat "steal unraised pot"

Postby WhiteRider » Wed Apr 01, 2009 10:34 am

Ah, I think I see what you're after.

You mean how often a player bets on the flop (i.e. opens the action) in a pot that wasn't raised preflop.
Yes?

So:
Unraised preflop is just NOT raise-PF AND NOT face-raise-PF AND saw-flop (better safe than sorry..)
Opens the action on the flop is just "bet flop" (because you can't "bet" if someone else already has).

NOT holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.flg_f_saw AND holdem_hand_player_detail.flg_f_open

(or you could use holdem_hand_player_statistics.flg_f_bet instead of flg_f_open; and in the opportunities column you could use "flg_f_open_opp" or "holdem_hand_player_statistics.flg_f_check OR holdem_hand_player_statistics.flg_f_bet").
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests