Effective Stack Filter Problem

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Effective Stack Filter Problem

Postby shawnest » Thu Nov 19, 2015 2:29 pm

I've set up my reports to filter out effective stacks between 17 and 100 (3 handed games) but it shows hands which includes players with less than 17bb.
Settings:
Players Dealt Into Hand Between 3 and 10
Effective Stack Size Big Blinds Between 17 and 100
Postel Blind / Ante Posted Big Blind
Position of First Raiseer Position of Selected Exactly 0
Size Calculated in Big Blinds Preflop Action Faced With Size 2BET Preflop Between 8 and 100

But i still got hands like these:

PokerStars Hand #143657143775: Tournament #1377084421, $14.25+$0.75 USD Hold'em No Limit - Level II (15/30) - 2015/11/11 9:01:57 ET
Table '1377084421 1' 3-max Seat #2 is the button
Seat 1: villain1 (735 in chips)
Seat 2: villain2 (570 in chips)
Seat 3: villain3 (195 in chips)
villain: posts small blind 15
villain: posts big blind 30
*** HOLE CARDS ***
villain: raises 540 to 570 and is all-in
villain: calls 180 and is all-in
villain: folds
Uncalled bet (375) returned to villain

I've changed player ofc.

Is there any way to filter out these players? I want to have report where all 3 players have over 17BB.
shawnest
 
Posts: 5
Joined: Thu Nov 19, 2015 2:20 pm

Re: Effective Stack Filter Problem

Postby kraada » Thu Nov 19, 2015 3:17 pm

So first this isn't a problem with the filter - Villain 1 in your hand is the person who matches as the big blind, and his effective stack is 19BB because he could lose all 570BB as he has the open shove covered.

The easiest way to filter for all three players having the stack size you want is to use this filter expression in My Reports:
(tourney_hand_summar.amt_short_stack / tourney_blinds.amt_bb) > 17
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Effective Stack Filter Problem

Postby shawnest » Sat Nov 21, 2015 5:51 am

Exactly what I wanted, thank you for the answer.
One more question. Is there any way to filter for these line?
Button Steal, SB 3bet non allin (fe. 0-8BB), BB 4bet AI, we're in the button and looking for call%.

tourney_hand_summary.str_aggressors_p = '8098' AND tourney_hand_summary.str_actors_p LIKE '098%' AND ((tourney_hand_summary.amt_short_stack / tourney_blinds.amt_bb) > 17)

I've tried this one and simple filters but facing bet sizing works only on 4bet sizing, I cant use simoultaneously 4bet and 3bet sizing. The problem is that I've got hands where SB 3betshoving covered, and BB 4betting something like 1 BB more. This kind of hands are more like SB 3betshoving BB calling, not SB 3bet nonai and BB 4betshove.

Thanks again!
shawnest
 
Posts: 5
Joined: Thu Nov 19, 2015 2:20 pm

Re: Effective Stack Filter Problem

Postby WhiteRider » Sat Nov 21, 2015 9:24 am

That should get you the correct action sequence, then you'd need to add filters for the raise sizes. Remember that all filters are from the active player's point of view, so you can't face a 3bet and a 4bet (or make a 3bet and a 4bet) - you need to filter for the size of the 3bet faced and the 4bet made for example.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Effective Stack Filter Problem

Postby dave2085 » Fri Aug 24, 2018 3:20 am

I built a stat with this
Code: Select all
(tourney_hand_summary.amt_short_stack / tourney_blinds.amt_bb) >=40
expression aswell

my problem now is that i want to only filter the stacksize from button to big blind, so when i play mtt i want that filter only counting the stacks bu,sb and BB and ignore other stacksizes like mp or utg.

this is the stat i build.
Code: Select all
sum(if[lookup_actions_p.action = 'F' and tourney_hand_summary.str_aggressors_p LIKE '80%'
and tourney_hand_summary.str_actors_p LIKE '0%'
and tourney_hand_player_statistics.amt_p_2bet_facing > 0
AND (tourney_hand_summary.amt_short_stack / tourney_blinds.amt_bb) >=40, 1, 0])


I already tried with this expression:
Code: Select all
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >=40

but this gives me worse outcome.

so my final stat should filter for situations where bu, sb and bb had more or equal to 40bb, and the stat shouldnt filter out all the stacksizes of the other players.


maybe i have an idea:

what if i do this?

Code: Select all
sum(if[lookup_actions_p.action = 'F' and (tourney_hand_summary.str_aggressors_p LIKE '80%'  and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >=40)
and (tourney_hand_summary.str_actors_p LIKE '0%' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >=40)
and tourney_hand_player_statistics.amt_p_2bet_facing > 0, 1, 0])

/EDIT: this doenst work
dave2085
 
Posts: 186
Joined: Mon Jun 02, 2008 10:41 am

Re: Effective Stack Filter Problem

Postby Flag_Hippo » Fri Aug 24, 2018 6:13 am

Using this code in a statistic will query the effective stat of that player only and if you want to test for the stacks of other players in the hand then that would require a subquery - see this guide for more information on that.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Effective Stack Filter Problem

Postby dave2085 » Fri Aug 24, 2018 6:56 am

hmm okay, so i have to solve this in sql?

is it possible to solve it like Kraada mentioned in this thread, in any way?! https://www.pokertracker.com/forums/viewtopic.php?f=61&t=92276&p=332007#p332007


last question before i prolly give up, if i want to write something like this, i cant put into the "normal" Colums Expression... right?
dave2085
 
Posts: 186
Joined: Mon Jun 02, 2008 10:41 am

Re: Effective Stack Filter Problem

Postby BillGatesIII » Fri Aug 24, 2018 8:50 am

    Is in the stat you want to create the button player the first to act? So all other players acting before the button have folded?
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm

    Re: Effective Stack Filter Problem

    Postby dave2085 » Fri Aug 24, 2018 10:12 am

    BillGatesIII wrote:
      Is in the stat you want to create the button player the first to act? So all other players acting before the button have folded?


      yes exactly
      dave2085
       
      Posts: 186
      Joined: Mon Jun 02, 2008 10:41 am

      Re: Effective Stack Filter Problem

      Postby BillGatesIII » Mon Aug 27, 2018 9:19 am

        A non-cached stat can be done with subqueries, like Flag_Hippo says. I think making a cacheable one is beyond the scope of this forum.
        BillGatesIII
         
        Posts: 740
        Joined: Fri Dec 16, 2011 6:50 pm


        Return to PokerTracker 4

        Who is online

        Users browsing this forum: No registered users and 64 guests

        cron
        highfalutin