vs missed CB

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

Re: vs missed CB

Postby kraada » Mon Apr 20, 2009 12:34 pm

You've got some extraneous information:
in
sum(if[
flg_p_face_raise AND
holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.enum_p_3bet_action='C' AND
flg_f_open_opp AND
NOT(flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position) AND
holdem_hand_player_statistics.flg_f_bet
, 1, 0])

you can remove "flg_p_face_raise" as you must face a 3 bet to have a 3bet_action of call. You can remove flg_f_open_opp as you must have an open opportunity to have made the first raise (flg_p_first_raise). Since you just call the 3bet you can never have a flop cbet opp, so NOT(flg_f_cbet_opp) is extraneous.

In

sum(if[
flg_p_face_raise AND
holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.enum_p_3bet_action='C' AND
flg_f_open_opp AND
NOT(flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position)
, 1, 0])

you can remove flg_p_face_raise for the reasons previously described, as well as the not(flg_f_cbet_opp).

Otherwise it looks good.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Mon Apr 20, 2009 12:43 pm

kraada wrote:You've got some extraneous information:
in
sum(if[
flg_p_face_raise AND
holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.enum_p_3bet_action='C' AND
flg_f_open_opp AND
NOT(flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position) AND
holdem_hand_player_statistics.flg_f_bet
, 1, 0])

you can remove "flg_p_face_raise" as you must face a 3 bet to have a 3bet_action of call. You can remove flg_f_open_opp as you must have an open opportunity to have made the first raise (flg_p_first_raise). Since you just call the 3bet you can never have a flop cbet opp, so NOT(flg_f_cbet_opp) is extraneous.

flg_f_open_opp is flop and flg_p_first_raise is preflop. Everything else I understand.

In

sum(if[
flg_p_face_raise AND
holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.enum_p_3bet_action='C' AND
flg_f_open_opp AND
NOT(flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position)
, 1, 0])

you can remove flg_p_face_raise for the reasons previously described, as well as the not(flg_f_cbet_opp).

Otherwise it looks good.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Mon Apr 20, 2009 1:01 pm

Sorry, I misspoke.

You must have an open opportunity on the flop in order to bet (flg_f_bet). If you were facing a bet then it would be a raise/call/fold, not a bet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Mon Apr 20, 2009 1:05 pm

well many redundant things and very helpfull answers thx!
I my PC uses too much resources on pt3 Ill make performance tweaks, but atm the developing of stats takes much time hat is missing for playing poker.
finally I got most of the stats I need for NL SH cashgame.

have anice day, jürgen
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Mon Apr 20, 2009 5:26 pm

Enjoy, if you have any other ideas, you know how to find me :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Mon May 04, 2009 4:58 am

Made a ticket, the following hand didnt count "Probe Bet Flop" +1 at my Villian.

Full Tilt Poker Game #12020108441: Table Alturas (6 max, speed) - $0.10/$0.20 - Limit Hold'em - 4:51:31 ET - 2009/05/04
Seat 2: HeroHelmut ($15.32)
Seat 3: Wieb84 ($3.96)
Seat 4: buras ($0.94)
Seat 5: harocarlos ($1.84)
Seat 6: graider ($7.24)
HeroHelmut posts the small blind of $0.05
Wieb84 posts the big blind of $0.10
The button is in seat #6
*** HOLE CARDS ***
Dealt to HeroHelmut [Kh Jd]
buras folds
harocarlos has been disconnected
harocarlos calls $0.10
harocarlos has reconnected
graider has 8 seconds left to act
graider folds
HeroHelmut raises to $0.20
Wieb84 has 8 seconds left to act
Wieb84 folds
harocarlos calls $0.10
*** FLOP *** [6h 3d Qc]
HeroHelmut has 8 seconds left to act
HeroHelmut checks
harocarlos bets $0.10
HeroHelmut calls $0.10
*** TURN *** [6h 3d Qc] [5s]
HeroHelmut checks
harocarlos bets $0.20
HeroHelmut folds
Uncalled bet of $0.20 returned to harocarlos
harocarlos mucks
harocarlos wins the pot ($0.67)
*** SUMMARY ***
Total pot $0.70 | Rake $0.03
Board: [6h 3d Qc 5s]
Seat 2: HeroHelmut (small blind) folded on the Turn
Seat 3: Wieb84 (big blind) folded before the Flop
Seat 4: buras didn't bet (folded)
Seat 5: harocarlos collected ($0.67), mucked
Seat 6: graider (button) didn't bet (folded)
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Mon May 04, 2009 9:58 am

Thanks we'll look into it and get back to you via the ticket.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Mon May 04, 2009 2:27 pm

What up with ne new beta? All custom stats broken?
SB limp / fold is now broken. The hand below. Its not funny anymore I need turbo fast support!!!!!!


Full Tilt Poker Game #12025648277: Table Vote (6 max) - $0.25/$0.50 - Limit Hold'em - 14:20:58 ET - 2009/05/04
Seat 1: musical69 ($6.50)
Seat 2: HeroHelmut ($17.10)
Seat 3: l35534 ($9.55)
Seat 4: pokerbandit ($11.95)
Seat 5: VO PRESS ($2.50)
Seat 6: TheGunAAA ($36.85)
musical69 posts the small blind of $0.10
HeroHelmut posts the big blind of $0.25
The button is in seat #6
*** HOLE CARDS ***
Dealt to HeroHelmut [9s Qc]
l35534 folds
pokerbandit folds
VO PRESS folds
TheGunAAA folds
musical69 calls $0.15
HeroHelmut raises to $0.50
musical69 calls $0.25
*** FLOP *** [5c Js 3s]
musical69 checks
HeroHelmut bets $0.25
musical69 raises to $0.50
HeroHelmut folds
Uncalled bet of $0.25 returned to musical69
musical69 mucks
musical69 wins the pot ($1.45)
*** SUMMARY ***
Total pot $1.50 | Rake $0.05
Board: [5c Js 3s]
Seat 1: musical69 (small blind) collected ($1.45), mucked
Seat 2: HeroHelmut (big blind) folded on the Flop
Seat 3: l35534 didn't bet (folded)
Seat 4: pokerbandit didn't bet (folded)
Seat 5: VO PRESS didn't bet (folded)
Seat 6: TheGunAAA (button) didn't bet (folded)
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Mon May 04, 2009 2:33 pm

Which stat are you looking at? The SB limped but he didn't fold; he called the raise in the hand you pasted.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Mon May 04, 2009 2:59 pm

kraada wrote:Which stat are you looking at? The SB limped but he didn't fold; he called the raise in the hand you pasted.


http://rapidshare.com/files/229160592/S ... _.rar.html

He open limped and folded to a raise from BB fe.
But in the hand I posted he didnt fold so it must be 0/1, so he had the opp to fold.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 4 guests

cron