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 May 04, 2009 4:25 pm

Your opportunities column is wrong.

You have:
sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND lookup_actions_p.action = 'CF'
, 1, 0])

What you want is:
sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise, 1, 0])

You add in that you don't 3-bet and that you do limp/fold -- that's not a chance to limp/fold, that IS a limp/fold.
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 pm

I see thx 4 finding that, I change it to:

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 <--- I think I need that because otherwise limp/raise would be counted
, 1, 0])

Whats with the Probe Bet Stat?
I think it a posisional problem since there a chance to that in newest beta. (lp,ep,mp)


HERE:
sum(if[holdem_hand_player_statistics.flg_f_bet and holdem_hand_player_statistics.flg_p_face_raise and not(holdem_hand_player_statistics.flg_f_cbet_opp) and (holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position), 1, 0])
____________
sum(if[flg_f_open_opp and flg_p_face_raise and not(flg_f_cbet_opp) and (holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position), 1, 0])

In a early beta that stat didnt work in the blinds and now it seems that theres a problem again.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Mon May 04, 2009 5:55 pm

How do you expect the probe bet to work? From the definition it looks very similar to donkbet - the prober is calling a preflop raise out of position and bets the flop.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Tue May 05, 2009 3:39 am

He floats directly the same street in position. He sees a missed CBet and bets.


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) CO
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 <-- me PFA
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 <----PFA misses CBet
harocarlos bets $0.10 <--- Villian Probe Bet in position
(its always in position, because u cant do that the same street, when u are oop. This would be a checkbehind by PFA)
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby js2002 » Tue May 05, 2009 9:45 am

cnt_f_probe_bet_raised_pot
sum(if[
holdem_hand_player_statistics.flg_f_bet AND
holdem_hand_player_statistics.flg_p_face_raise AND
NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position)
, 1, 0])
___________
cnt_f_probe_bet_raised_pot_opp
sum(if[
flg_f_open_opp AND
flg_p_face_raise AND
NOT(flg_f_cbet_opp) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position)
, 1, 0])

This I use. You have 3Bet Pot things.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Tue May 05, 2009 11:21 am

According to those definitions you're right that should be showing up as far as I can tell. I'll make sure this gets looked into further.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Tue May 05, 2009 11:23 am

the "ticket mike" ;) said that he imported it and it showed 1/1, so I ll test some hands again.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Tue May 05, 2009 11:35 am

That's good to hear; keep me posted.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby WhiteRider » Tue May 05, 2009 5:59 pm

js2002 wrote:the "ticket mike" ;) said that he imported it and it showed 1/1, so I ll test some hands again.

That was me, actually; but yes it imported as 1/1 for the probe bet stat/hand.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 10 guests

cron
highfalutin