All In Filter

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

All In Filter

Postby 28renton » Fri Aug 08, 2014 10:17 am

Hey,

Just wondering how to create an All In Filter for HU SNG's. Preferably for hands that got all in and went to showdown (so I don't want all ins where my opponent folded or vice versa) at any point in the hand, but if it's easier then just hands that are preflop.
28renton
 
Posts: 5
Joined: Mon Mar 19, 2012 12:52 am

Re: All In Filter

Postby kraada » Fri Aug 08, 2014 11:05 am

You have to add a few filters together to make this happen. Since you want all-in hands that reached showdown you want Actions & Opportunities -> River -> Saw Showdown.

Then for each street you want A&O -> Street -> Raises -> Raised All-in and to also add A&O -> Street -> Opportunities -> Faced All-In and to combine them with "OR". Add this for all streets and OR those together and you'll see what you want. See this tutorial for more details on how to combined filters.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All In Filter

Postby romax » Mon Oct 06, 2014 11:57 am

Kraada, could we please discuss it little bit futher.

How can I also include hands where I just BET (open shoved, not rised) all in on flop, turn or river. I can't find any filter for this.
Also how can I include hands where I put my opponent All in by betting (villian has less chips than me)? Basicaly I want to filter out all hands where I or opponent has a decission for all in.

This expression filter
Code: Select all
tourney_hand_player_statistics.enum_allin <> 'N' OR tourney_hand_player_statistics.enum_face_allin <> 'N'

doesn't help in situation where I put somebody all in but not all in myself.
romax
 
Posts: 39
Joined: Sat Apr 21, 2012 10:24 am

Re: All In Filter

Postby kraada » Mon Oct 06, 2014 12:21 pm

enum_allin should still have the value for the street even if it's a bet all-in and not a raise all-in. So something like enum_allin = 'F' and lookup_actions_f.action = 'B' should work.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All In Filter

Postby romax » Mon Oct 06, 2014 12:36 pm

Kraada thanks for quick reply

1) So am I right doing it complicated way? So I mean there is no functionality in standards filters for all in like this?

2) Right now I am in SQL admin and values in field enum_allin is 'N' when I bet 60 on the flop when opponent has only 40 chips left (puting him all in)
romax
 
Posts: 39
Joined: Sat Apr 21, 2012 10:24 am

Re: All In Filter

Postby kraada » Mon Oct 06, 2014 1:23 pm

(1) At the moment you do need to use a filter expression. This is on our list for a future improvement but I don't have an ETA on that at this point in time.

(2) Please send us that hand via a support ticket so that we can get that fixed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All In Filter

Postby Bill_Balas » Fri Aug 17, 2018 2:06 pm

Hi,

so what would the code for cash game hands "Flop NOT All-in" be?

thx
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: All In Filter

Postby Bill_Balas » Fri Aug 17, 2018 2:11 pm

"Flop NOT All-in bet", is what I meant.

Thx
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm

Re: All In Filter

Postby Flag_Hippo » Sat Aug 18, 2018 6:12 am

Code: Select all
NOT (cash_hand_player_statistics.enum_allin SIMILAR TO '(F|f)' and lookup_actions_f.action = 'B')
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: All In Filter

Postby Bill_Balas » Tue Aug 21, 2018 8:20 am

Thx so much, Flag_Hippo.
Bill_Balas
 
Posts: 161
Joined: Wed Oct 22, 2014 8:57 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 50 guests

cron
highfalutin