Callin on Position

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

Callin on Position

Postby Dracco78 » Sun Apr 26, 2009 1:25 am

I created a stat to show the percetage of times a player raises first in and gets reraised. Now I want my stat to distinguish when the player has postion on the reraiser.
Dracco78
 
Posts: 18
Joined: Tue Jan 13, 2009 4:11 am

Re: Callin on Position

Postby kraada » Sun Apr 26, 2009 9:26 am

holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position if they have position on you. Change it to > and you have position on them.

(NOTE: If you play exclusively heads up, you need to flip that, because on heads up tables the SB has position on the BB.)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Callin on Position

Postby stevi3p » Fri May 01, 2009 3:25 am

But this will only work when there's no 4bet is that right? Depends on what you're using the stat for, but this could lead to some pretty biased results....

It would be really helpful to have a stat which shows the position of the 3bettor regardless of whether there's a 3bettor.
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Callin on Position

Postby WhiteRider » Fri May 01, 2009 4:32 am

stevi3p wrote:But this will only work when there's no 4bet is that right? Depends on what you're using the stat for, but this could lead to some pretty biased results....

Yes, that's right. The raise aggressor position is always the position of the final raiser (other than the active player).

It would be really helpful to have a stat which shows the position of the 3bettor regardless of whether there's a 3bettor.

Yes, I agree, and there is a suggestion/request for this in our bug tracker, but I don't know if/when this will be implemented.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Callin on Position

Postby stevi3p » Fri May 01, 2009 7:02 am

Great thanks. Worth thinking about including a position of the 4bettor stat as well. Thanks

And I'm looking forward to the new beta after all your hype! Any chance of it being released today? Or will it be after the weekend?

Steve
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Callin on Position

Postby kraada » Fri May 01, 2009 9:36 am

It's unclear, but several of the alpha bugs do appear to be solved, so I think we're a lot closer today than we were on Tuesday or Wednesday.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests