PokerTracker

hi,

I want to find out how my 3bets against different stacksizes differ in performance. Can you tell me, what to type into the expression filter to filter f.e. 3bets against an openraiser who had 40-50 big blinds before he made his 2bet, please?

tyvm

Unfortunately there isn't a great filter to use for that situation - you can filter for your effective stack but if the open raiser was short and there's a big stack behind you that affects your effective stack.

is there any workaround?

You could do it with a filter expression but I can't think of a way to do it using the regular filters.

a filter expression is exactly what I am looking for. Unfortunately I do not have an idea how to define villains stacksize. Is there something like cash_hand_player_statistics.val_p_raise_aggressor_stacksize between...?

No you'd have to do it with a subquery.

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_first_raise and chps.amt_p_effective_stack / cl.amt_bb between X and Y)

will filter to hands where the effective stack of the first raiser in big blinds was between X and Y.

thank you. I am sorry that I have to ask again. How/where do I use subqueries?

You can put that in the Filter Expressions area in the left hand Filters link of My Reports reports.

Hi guys,

I am building a population analysis & I'm trying to filter for the blinds' stack size when I'm not in the hand.
So I am trying to find the SB raiser (2better here) effective stack size. Obviously, the manual filter on stack always focus on hero so not helping.

I am getting slowly around the homemade subqueries but I'm still a fish. Could someone help me with this?

Best,
François

It depends and a subquery isn't always necessary. If you just want to filter hands directly from the small blinds perspective then you can turn off the 'Filter on Active Player' via the 'Filters' link (this is off by default in an 'All Players' report). If you also add a filter for NOT(Player is Hero) the data will be filtered without your own small blind hands. I don't know if a subquery is needed for what you want without more specific details.