Open Opportunity and Behind Limpers filters

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: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Wed Mar 21, 2012 5:51 pm

Ok, we agree on that point ; so there is visibly no solution for my need.

In PT4 it will be possible to have a distinction between a 2bet all-in preflop, a 3bet all-in preflop etc etc ?

And for the field enum_face_allin, it takes the last all-in faced on the hand ? For example if the player face a all-in PF, and then a all-in F, the value of enum_face_allin will be "F" ?
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

Re: Open Opportunity and Behind Limpers filters

Postby kraada » Thu Mar 22, 2012 8:24 am

Let me try this again:

This is an all-in 2bet: flg_p_first_raise and not(flg_p_3bet or flg_p_4bet) and enum_allin = 'P'

This is an all-in 3bet: flg_p_3bet and enum_allin = 'P' and not(flg_p_4bet)

This is an all-in 4bet exactly : enum_p_3bet_action = 'R' and not(flg_p_4bet_def_opp) and enum_allin = 'P'

This is an all-in 5bet or higher: flg_p_4bet and flg_p_4bet_def_opp and enum_allin = 'P'

PT4's schema has other tools you can use but I think this covers all of the cases you need, yes?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Thu Mar 22, 2012 9:28 am

temp
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

Re: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Thu Mar 22, 2012 9:55 am

I think that you just opened my mind :-)

So, for my following need :

- Add the filter NOT"PF raise all-in" in addition of the filter flg_p_first_raise

The solution would be :

flg_p_first_raise AND NOT (flg_p_first_raise and NOT(flg_p_3bet OR flg_p_4bet) AND enum_allin ='P')

-> I select all 2bets, and then I exclude all 2bets allin.

Am I right ?
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

Re: Open Opportunity and Behind Limpers filters

Postby kraada » Thu Mar 22, 2012 12:07 pm

That should work.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Thu Mar 22, 2012 1:07 pm

Ok, cool !

And for my second need :

- Add the filter NOT "Facing all-in PF" in addition to the filter "flg_p_3bet_opp"

Here is a possible filter, on the same schema :

flg_p_3bet_opp AND NOT (flg_p_3bet_opp AND NOT flg_p_4bet_opp AND enum_face_allin='P')

When we are facing a 3bet we can't face a 4bet, but we can face a 5bet and more... So if I filter with "AND NOT flg_p_4bet_opp" I will lost hands where I faced a 3bet allin and then I faced a 5bet+ ?

And I still don't understand the behavior of the field "enum_face_allin", see my last question :

And for the field enum_face_allin, it takes the last all-in faced on the hand ? For example if the player face a all-in PF, and then a all-in F, the value of enum_face_allin will be "F" ?

Thanks
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

Re: Open Opportunity and Behind Limpers filters

Postby kraada » Thu Mar 22, 2012 3:08 pm

flg_p_4bet_opp is true if you have a chance to make any 4bet or higher (5bet, 6bet, etc).

I believe in your example enum_faced_allin = 'F'.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Fri Mar 23, 2012 6:28 am

Ok, so do you see a solution for this ?

- Add the filter NOT "Facing all-in PF" in addition to the filter "flg_p_3bet_opp"

The filter "flg_p_3bet_opp AND NOT (flg_p_3bet_opp AND NOT flg_p_4bet_opp AND enum_face_allin='P')" is not bad, but :

- Hands where the player faced a allin Flop, Turn or River will be not filtered out
- Hands where the player faced a 5bet, 6bet etc will be not taken in account

Thanks
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

Re: Open Opportunity and Behind Limpers filters

Postby WhiteRider » Fri Mar 23, 2012 10:14 am

BigBangTheory wrote:Hands where the player faced a allin Flop, Turn or River will be not filtered out

I don't know for sure because I can't find an example just now, but I would expect enum_face_allin to be the first all-in faced rather than the last. If you have an example hand history where this happened I'll be able to tell you for sure.

BigBangTheory wrote:Hands where the player faced a 5bet, 6bet etc will be not taken in account

I thought you didn't want to take those into account?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Open Opportunity and Behind Limpers filters

Postby BigBangTheory » Fri Mar 23, 2012 11:50 am

WhiteRider wrote:
BigBangTheory wrote:Hands where the player faced a 5bet, 6bet etc will be not taken in account

I thought you didn't want to take those into account?


Yes, that's right but with the following filter :

"flg_p_3bet_opp AND NOT (flg_p_3bet_opp AND NOT flg_p_4bet_opp AND enum_face_allin='P')"

1) I select hands where the player faced a 3bet, with "flg_p_3bet_opp"
2) I exclude from this selection all situations where the player faced a 3bet allin, with AND NOT (flg_p_3bet_opp AND NOT flg_p_4bet_opp AND enum_face_allin='P')

But for this last part, if the player faced a 3bet allin and then faced a 5bet, the condition AND NOT (flg_p_3bet_opp AND NOT flg_p_4bet_opp AND enum_face_allin='P') will be not verified because flg_p_4bet_opp will be set to TRUE...
BigBangTheory
 
Posts: 30
Joined: Tue Aug 23, 2011 3:31 pm

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 11 guests