Custom stat didnt work in HU

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

Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 6:06 am

This is the Probe Bet Turn (after seeing checkbehind previous street) Stat

sum(if[
flg_f_open_opp and flg_p_face_raise AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) AND
lookup_actions_f.action = 'X' AND
holdem_hand_player_detail.flg_t_open_opp AND
holdem_hand_player_statistics.flg_t_bet AND
holdem_hand_summary.cnt_players_f=2 AND holdem_hand_summary.cnt_players_t=2
, 1, 0])
________
sum(if[
flg_f_open_opp and flg_p_face_raise AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) AND
lookup_actions_f.action = 'X' AND
holdem_hand_player_detail.flg_t_open_opp AND
holdem_hand_summary.cnt_players_f=2 AND holdem_hand_summary.cnt_players_t=2
, 1, 0])

This stat did not count hands like:

***** Hand History for Game 8155803219 *****
$50 USD NL Texas Hold'em - Monday, June 15, 05:36:34 EDT 2009
Table Heads Up #1459593 (No DP) (Real Money)
Seat 2 is the button
Total number of players : 2
Seat 2: HeroHelmut ( $40.40 USD )
Seat 1: moby25555 ( $52.75 USD )
HeroHelmut posts small blind [$0.25 USD].
moby25555 posts big blind [$0.50 USD].
** Dealing down cards **
Dealt to HeroHelmut [ Jc Qc ]
HeroHelmut raises [$0.75 USD]
moby25555 calls [$0.50 USD]
** Dealing Flop ** [ 6s, 2c, Ad ]
moby25555 checks
HeroHelmut checks
** Dealing Turn ** [ 6c ]
moby25555 bets [$2 USD]
HeroHelmut calls [$2 USD]
** Dealing River ** [ 7h ]
moby25555 checks
HeroHelmut bets [$4 USD]
moby25555 folds
HeroHelmut does not show cards.
HeroHelmut wins $9.70 USD

***** Hand History for Game 8155792152 *****
$50 USD NL Texas Hold'em - Monday, June 15, 05:28:46 EDT 2009
Table Heads Up #1459593 (No DP) (Real Money)
Seat 2 is the button
Total number of players : 2
Seat 2: HeroHelmut ( $22.65 USD )
Seat 1: moby25555 ( $41.92 USD )
HeroHelmut posts small blind [$0.25 USD].
moby25555 posts big blind [$0.50 USD].
** Dealing down cards **
Dealt to HeroHelmut [ 3c Qc ]
HeroHelmut raises [$0.75 USD]
moby25555 calls [$0.50 USD]
** Dealing Flop ** [ Ks, 9h, Jd ]
moby25555 checks
HeroHelmut checks
** Dealing Turn ** [ 9d ]
moby25555 bets [$1.50 USD]
HeroHelmut raises [$4 USD]
moby25555 folds
HeroHelmut does not show cards.
HeroHelmut wins $7.25 USD

Platform = PartyGaming, HU Cashgame

Is it because BU = SB = 9 and BB = 8 ?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stat didnt work in HU

Postby kraada » Mon Jun 15, 2009 9:22 am

Yes, when you're playing heads up it's the only time someone with a higher position number is actually in position (as SB = 9, and 9 > 8, but 9 is in position here).

You can either build a specific HU stat (and HU you can just use flg_f_has_position, as you either are or aren't in position for sure), or add a check to see if cnt_players = 2.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 9:27 am

What?! I thought this was fixed! So that its -1 < 9

I dont get the cnt_player = 2 thing: When I add cnt_p_player = 2, the check "...<..." is still false.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stat didnt work in HU

Postby kraada » Mon Jun 15, 2009 9:36 am

val_p_raise_aggressor_pos was the field that was fixed.

What you want to do here with an extra check is replace "(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position)" with:
((holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.position = 9) OR (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position))
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 9:50 am

kraada wrote:val_p_raise_aggressor_pos was the field that was fixed.



This I meant. What do you mean? What was the error then? I thought the HU problems where part of the problems. So I thought until now that HU stats are now correct :(

thx 4 the code. I have to check all custom stats now :(
For SH the stats are ok I guess. because SB is never in posi and alwys larger number then any other posi...
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stat didnt work in HU

Postby kraada » Mon Jun 15, 2009 10:19 am

Right, it's only a problem for heads up.

The val_p_raise_aggressor_pos for a while would alternate between -1 and the value of your opponent who raised. It no longer does that; it's now the value of the position that your last opponent raised from and it's only -1 if you were the only preflop raiser. But 8 and 9 are absolute even for heads up games, which is what the problem is here.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 10:48 am

kraada wrote:Right, it's only a problem for heads up.

The val_p_raise_aggressor_pos for a while would alternate between -1 and the value of your opponent who raised. It no longer does that; it's now the value of the position that your last opponent raised from and it's only -1 if you were the only preflop raiser. But 8 and 9 are absolute even for heads up games, which is what the problem is here.


sry my english: 8 and 9 are even?!?!??! even = "==" ?! Im wierd now.

"and it's only -1 if you were the only preflop raiser" <---so my 2 hands (and generally for HU) it should be -1, I mean I was the ONLY preflop raiser!
-1 is smaller that the BB (the 8). So why does the check fail?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 11:20 am

I played 106 HU hands today:

val_p_raise_aggressor_pos = 9 -> 36 hands (SB)
val_p_raise_aggressor_pos = 8 -> 10 hands (BB)
val_p_raise_aggressor_pos = -1 -> 70 hands (part of both?!)

So I guess I made many hands to -1 by raising them some were in the BB.

As u can see the value gets -1 and the expression results in "-1<8" = true. So please answer me why it returns false and/or why my stat doesnt work.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stat didnt work in HU

Postby kraada » Mon Jun 15, 2009 12:26 pm

In heads up pots, whether or not you raise:

If HE raises preflop from the SB val_p_raise_aggressor_pos = 9.
If HE raises preflop from the BB val_p_raise_aggressor_pos = 8.
If YOU raise preflop (and he does NOT raise preflop), val_p_raise_aggressor_pos = -1.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stat didnt work in HU

Postby js2002 » Mon Jun 15, 2009 3:52 pm

kraada wrote:In heads up pots, whether or not you raise:

If YOU raise preflop (and he does NOT raise preflop), val_p_raise_aggressor_pos = -1.


Yes! so probet bet for HIM should be +1. because all is TRUE and the -1<8 also!!!!!! man get it and help me plz
Last edited by js2002 on Mon Jun 15, 2009 3:57 pm, edited 1 time in total.
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 0 guests