Opponent 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

Opponent Position

Postby pr1mo » Fri Dec 26, 2008 11:59 pm

I know it's possible to set our position by using for example: holdem_hand_player_statistics.position = 9 being us in the SB. But if I add holdem_hand_summary.cnt_players_f = 2 for players in the hand being 2... is it possible to set our opponent position? i had a look through the insert option inside custom stats but didn't see anything. I'm looking to use this in a BB vs. SB stats situations.
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: Opponent Position

Postby pr1mo » Sat Dec 27, 2008 12:46 am

is it better to use: holdem_hand_player_statistics.position = 9 to describe us in the SB or is it better to use: holdem_hand_player_statistics.flg_blind_s

or are they the same thing?
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: Opponent Position

Postby WhiteRider » Sat Dec 27, 2008 6:54 am

pr1mo wrote:is it better to use: holdem_hand_player_statistics.position = 9 to describe us in the SB or is it better to use: holdem_hand_player_statistics.flg_blind_s

or are they the same thing?

They are the same thing.

To get your opponent's position is tricky. There are a few fields which will help.
holdem_hand_player_detail.flg_f_has_position (for each street _t_, _r_)
holdem_hand_player_detail.val_f_bet_aggressor_pos (etc)
holdem_hand_player_detail.val_f_raise_aggressor_pos (etc)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Opponent Position

Postby pr1mo » Wed Dec 31, 2008 4:27 am

when using holdem_hand_player_detail.val_p_raise_aggressor_pos = does that equal the same positions as usually used with the holdem_hand_player_statistics.position = stat.

ie:
sb=1
bb=2
button=0
cutoff=1
hijack=2
utg 10 handed=3
utg 9 handed=4

i seem to remember either WR or Kraada posting saying that position numbers are different with some special different pt3 stats. if the positions for val_p_raise_aggressor_pos are different could you please post the numbers, thanks
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: Opponent Position

Postby kraada » Wed Dec 31, 2008 10:37 am

The numbers start from the button and count up:

Button = 0
Cutoff = 1
Hijack = 2
and so on.

What is supposed to happen is that BB is always 8 and the SB is always 9 regardless of how many players there are at the table.

I believe what is happening is that the SB and BB are just counted up normally, so on a 9 handed table there'd be no difference but on an 8 handed table instead of 8 and 9 it'd be 7 and 8.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Opponent Position

Postby WhiteRider » Wed Dec 31, 2008 11:05 am

Yes, that's how it works at the moment, if I remember correctly.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests