Raise BB behind SB open-limp

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

Raise BB behind SB open-limp

Postby MachtiSonni » Wed Jul 13, 2011 12:32 pm

Hey there,

I'd like to make a stat to see how often BB raises when the action is folded to the SB and the SB decides to open-limp. I checked out the database-schema but didn't come up with good spots where to start. Any help would be appreciated!

Thanks!

-MachtiSonni
MachtiSonni
 
Posts: 18
Joined: Tue Dec 15, 2009 4:07 am

Re: Raise BB behind SB open-limp

Postby kraada » Wed Jul 13, 2011 12:57 pm

As it turns out, due to the way the database is constructed this is a particularly tricky situation to define well.

We've fixed this particular deficiency for PT4 and this stat will be easy to build in PT4 though.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raise BB behind SB open-limp

Postby MachtiSonni » Wed Jul 13, 2011 2:39 pm

Yeah...

I shuffled through the database-schema and figured out the same thing. I'll wait for PT4, then :)

-MachtiSonni
MachtiSonni
 
Posts: 18
Joined: Tue Dec 15, 2009 4:07 am

Re: Raise BB behind SB open-limp

Postby kraada » Wed Jul 13, 2011 2:45 pm

You might be able to get reasonably close to accurate though by comparing val_p_raise_made_pct, amt_p_raise_made and the size of the big blind. If you're in the BB and the SB limps the pot is only 2BBs. The only other way that can happen is with a dead SB and a poster who checks - which seems fairly rare.

If you don't raise and instead check then you can check that you're only against the small blind by using flg_f_has_position.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raise BB behind SB open-limp

Postby js2002 » Sun Jun 22, 2014 12:35 pm

Is there a stat already or a 2014 way to do it more easy?
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Raise BB behind SB open-limp

Postby WhiteRider » Sun Jun 22, 2014 2:58 pm

You can do this with the actors and aggressors strings in PT4.

If the SB is the first to enter the pot the actors string will start with '9'.
If the SB did not raise then the aggressors string will either be 1 char long (if the BB checked) or the 2nd char will not be '9' (it will be 8 if the BB 2Bet).

cash_hand_summary.str_aggressors_p
cash_hand_summary.str_actors_p

I'm sure you've used these strings before, but they are described here. Remember to test the lengths before you test specific characters.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raise BB behind SB open-limp

Postby js2002 » Sun Jun 22, 2014 5:09 pm

found out, thx
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


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

Who is online

Users browsing this forum: No registered users and 10 guests

cron