difference aggressor posi vs has posi

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

difference aggressor posi vs has posi

Postby js2002 » Fri Sep 17, 2010 5:19 am

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)

164 results

holdem_hand_player_detail.flg_f_open_opp
AND holdem_hand_player_statistics.flg_p_face_raise AND
(deleted f cbet opp here because already catched the PFA check by lookup and face raise)
holdem_hand_player_detail.flg_f_has_position AND
lookup_actions_p.action NOT LIKE '%R'

69 results

has posi is absolute position at all player in the hand, right?
so the first column has more result because we can have position vs the aggressor but still be not in posi, correct?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: difference aggressor posi vs has posi

Postby js2002 » Fri Sep 17, 2010 6:10 am

js2002 wrote: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)

152 results

holdem_hand_player_detail.flg_f_open_opp
AND holdem_hand_player_statistics.flg_p_face_raise AND
(deleted f cbet opp here because already catched the PFA check by lookup and face raise)
holdem_hand_player_detail.flg_f_has_position AND
lookup_actions_p.action NOT LIKE '%R'

68 results

has posi is absolute position at all player in the hand, right?
so the first column has more result because we can have position vs the aggressor but still be not in posi, correct?



FIXED MY POST
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: difference aggressor posi vs has posi

Postby kraada » Fri Sep 17, 2010 9:04 am

js2002 wrote:has posi is absolute position at all player in the hand, right?
so the first column has more result because we can have position vs the aggressor but still be not in posi, correct?


Correct on both counts.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: difference aggressor posi vs has posi

Postby js2002 » Fri Sep 17, 2010 9:18 am

This is a old Probe Bet in position Stat.
I found out that it can be the same as a Float Flop Stat.

In general, how does PT3 define flg_t_float ?
Does to use the relative or the absolute oder maybe a combination of both.
I ask because if I finally know that I can bring my definition in line with PT3 (if it makes sense 4 me and I want this at special stats).
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: difference aggressor posi vs has posi

Postby kraada » Fri Sep 17, 2010 9:37 am

I believe it's relative position but I'll double check just to be sure.
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