stat: BB folds when SB opens

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

Re: stat: BB folds when SB opens

Postby WhiteRider » Wed Aug 06, 2008 4:51 pm

I was just about to come back and reply to this.
Yes, the raise aggressor position doesn't use 9 for the SB, it works on actual position off the button. I don't know if this is by design or not, but I'll try to find out.
Raise aggressor position is -1 when you (or rather, the current selected player) are the aggressor.

I've fixed it to work, though.
Aggressor is in the SB when their position is one less than the number of players in the hand.

sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

and

sum(if[holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stat: BB folds when SB opens

Postby WhiteRider » Wed Aug 06, 2008 4:57 pm

SaiYeN wrote:There's a lot of problems with the holdem_hand_player_detail.val_p_raise_aggressor_pos field.

1) SB position is NOT always 9 (off the button). Same for BB not always 8. In a 6max game, the SB is being counted as position 5 and BB position 4. In a 5 handed game, the SB is 4 and BB is 3. etc

2) a lot of hands have the that field as -1, i can't figure out why.

3) in 3bet pots, the value of it isn't consistent. Sometimes its the position of the 3better and others the opener.


1. Agreed.
2. I think it's -1 when you (the selected player) is the aggressor.
3. I'm going to experiment a little further, but I think this is to do with when you are involved in the aggression..
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stat: BB folds when SB opens

Postby SaiYeN » Wed Aug 06, 2008 5:20 pm

yeah you're right, when you open the value's -1 and when you get 3bet it's the position of the 3better but if you 3bet someone the value stays with the position of the opener. Makes sense. thanks for clearing this up.
SaiYeN
 
Posts: 34
Joined: Thu Jan 24, 2008 11:49 pm

Re: stat: BB folds when SB opens

Postby WhiteRider » Wed Aug 06, 2008 6:08 pm

No problem - I've asked Josh or Derek whether it is intentional to not use 8&9 - if I find out I'll let you know.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stat: BB folds when SB opens

Postby banshee » Thu Aug 07, 2008 4:37 am

yeah, great work ;)

Seems to work!
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: stat: BB folds when SB opens

Postby APerfect10 » Fri Aug 08, 2008 1:17 pm

This appears to be a bug which I have added to our bug list and we will get resolved.

9 should always be the SB
8 should always be the BB

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4465
Joined: Sat Dec 08, 2007 6:03 pm

Re: stat: BB folds when SB opens

Postby jockodundee » Sun Aug 17, 2008 3:28 am

Is the final verdict that there is no field to show when everyone folded to the SB?

In PT2 it was easy: small_blind_n = 1 and chance_to_steal = 1
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: stat: BB folds when SB opens

Postby WhiteRider » Sun Aug 17, 2008 4:46 am

holdem_hand_player_statistics.flg_blind_s
and
holdem_hand_player_statistics.flg_steal_opp
will both be true, similar to PT2.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stat: BB folds when SB opens

Postby jockodundee » Sun Aug 17, 2008 2:45 pm

by WhiteRider on Sun Aug 17, 2008 12:46 am

holdem_hand_player_statistics.flg_blind_s
and
holdem_hand_player_statistics.flg_steal_opp
will both be true, similar to PT2.


This is not true at all for my data. Please recheck and if you believe ths is so, I will make a ticket.
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: stat: BB folds when SB opens

Postby WhiteRider » Sun Aug 17, 2008 3:12 pm

If you have some hands [imported in Beta15] which are folded to you in the SB and those fields are not true, then yes please attach the hand histories to a ticket.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 5 guests

cron