Page 1 of 2

Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 3:18 am
by evanski
Im not sure if this is possible, but if it is, I havent been able to figure out how to do it. Im playing around with the stack size filters for 6m SNGs and I want be able to set a specific stack for myself, say between 8-10 BB's, and then set another filter that removes any hand where anyone left to act (or anyone at the table if this isnt possible) has less than X number of BBs. I was hoping the effective stack size filter would do this, but setting that to X only ensures that AT LEAST one player has >X, not everyone.

Any other way to go about this?

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 3:21 am
by evanski
I think my explanation was needlessly complex. I want a minimum stack filter that tosses out any hand where ANY player at the table has less than X # of BBs. Does this exist?

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 4:20 am
by WhiteRider
No, the stack filters are based on the player's current stack (actually their stack based on information from the end of the previous hand).

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 1:39 pm
by evanski
WhiteRider wrote:No, the stack filters are based on the player's current stack (actually their stack based on information from the end of the previous hand).


That would be more than adequate. Does a filter exist to throw out any hand where someone at the table starts the hand with less than X # of BBs?

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 2:12 pm
by kraada
Not in our default filter set, but you can filter for effective stack size (in Hand Details -> Pot Size and Stack Depth) which you can use to make sure that at least one person to act after you had at least the stack size you specify - would that be sufficient?

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 2:18 pm
by evanski
kraada wrote:Not in our default filter set, but you can filter for effective stack size (in Hand Details -> Pot Size and Stack Depth) which you can use to make sure that at least one person to act after you had at least the stack size you specify - would that be sufficient?


Unfortunately not for this particular purpose.

When you say default filter set does it imply that it is doable with custom filters? I would assume so, since the stack size information must be stored/accessible somewhere. Ive tried several times in PT3/PT4 to bite the bullet and learn to do columns/custom stats but have always gotten frustrated and quit. Is there a good web resource for total beginners to learn?

Thanks for your replies.

Re: Minimum Stack Filter

PostPosted: Tue Sep 04, 2012 4:53 pm
by kraada
Yes, the Filter Expressions in the custom reports area are extremely robust.

There is good general documentation on PostgreSQL on their website. In terms of understanding how this works in Filter Expressions, this post should help you get started.

But I'll give you this particular filter so that you can compare for future reference:

tourney_hand_player_statistics.id_hand NOT IN (SELECT thps.id_hand from tourney_hand_player_statistics thps, tourney_blinds tb where thps.id_limit = tb.id_limit and (thps.amt_before / tb.amt_bb) <= X)

That filters to all and only hands where all players had strictly more than X big blinds in their starting stack (you can change X as needed).

Re: Minimum Stack Filter

PostPosted: Wed Sep 05, 2012 3:06 pm
by evanski
Thanks a lot for the help. I hate to ask for more, but Im having trouble implementing this one. Ive read the linked post, and some other ones, including the filter page here: http://www.google.com/url?sa=t&rct=j&q= ... DVpHQLfD0Q

So I get how to go about making an expression filter. I just cant quite comprehend the syntax above and how to enter that in the expression box to generate a valid expression.

Re: Minimum Stack Filter

PostPosted: Wed Sep 05, 2012 4:27 pm
by kraada
All you should need to do to enter that in the box is change X to some number and paste it in.

Re: Minimum Stack Filter

PostPosted: Wed Sep 05, 2012 4:56 pm
by evanski
I figured as much, but this is what happens
Image

highfalutin