Verify Call Steal in BB vs/from SB

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

Verify Call Steal in BB vs/from SB

Postby js2002 » Wed Aug 12, 2009 11:59 am

Is this stat ok? should I use flg_blind_b or better the "holdem_hand_player_statistics.position = 8" ??
Do you think this works correct?

NUM
sum(if[
holdem_hand_player_statistics.flg_blind_b AND
holdem_hand_player_statistics.flg_blind_def_opp AND
holdem_hand_player_statistics.cnt_p_call > 0 AND
cnt_p_raise = 0 AND NOT flg_p_fold AND
holdem_hand_player_detail.val_p_raise_aggressor_pos = 9
, 1 , 0 ])

OPPS
sum( if[
holdem_hand_player_statistics.flg_blind_def_opp AND
holdem_hand_player_statistics.flg_blind_b AND
holdem_hand_player_detail.val_p_raise_aggressor_pos = 9
, 1, 0])
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Verify Call Steal in BB vs/from SB

Postby kraada » Wed Aug 12, 2009 12:32 pm

You want to add holdem_hand_player_statistics.flg_blind_def_opp to both stats.

Reason being if the button opens, and the SB 3bets, val_p_raise_aggressor_pos will still be 9. But you won't be facing a steal any longer.

If you want these spots to count, though, you can leave flg_blind_def_opp out.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Verify Call Steal in BB vs/from SB

Postby js2002 » Wed Aug 12, 2009 1:40 pm

kraada wrote:You want to add holdem_hand_player_statistics.flg_blind_def_opp to both stats.

Reason being if the button opens, and the SB 3bets, val_p_raise_aggressor_pos will still be 9. But you won't be facing a steal any longer.

If you want these spots to count, though, you can leave flg_blind_def_opp out.


A steal is not a 3bet and so a call of a steal isnt either...

As you can see above, the value mentioned is in both columns.

So, everthing ok?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Verify Call Steal in BB vs/from SB

Postby kraada » Wed Aug 12, 2009 2:12 pm

Somehow I didn't see it there.

Yes everything looks proper now. My apologies for the oversight.
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