Playing around with expression filters

[Vleesjas]

Hi guys,

I've started learning / using the expression filters to get into a a deeper understanding of pool tendency's (currently playing 6max 25NL R&C on GG).
For Single raised pots I get the results I was hoping for, but I'm having difficulty understanding where I'm going wrong with the specific scenario where hero is in the CU, and the SB 3-bets, without any other players being involved. So now squueze after BTN coldcalls 2b, nor the bigblind cold-callen SB's 3b.

I find a huge cap between using the statistic tab (without expression filter), and using a hand report, including the expression filter for only cu&sb have a positive VPIP.

The following filters were used in the statistic tab:
"Raise first in = true AND number of preflop limp = 0 AND position of active player = 1 AND position of preflop 3Bettor = 9"
Total hands: 482

I used the exact same filters + the expression filter cash_hand_summary.str_actors_p = '19'
Total hands: 226

Not sure where I go wrong with this one, I understand that there should be more hands when using the statistic tab since there are more preflop scenarios like explained at the top, BTN coldcalling, BB being involved etc. But the gap is way to big.

Any help / tips are welcome .
Thanks in advance!

[Ventilatorrr]

Hello,

Using the cash_hand_summary.str_actors_p = '19' expression filter will only filter hands where CO raised, SB 3-betted, and then everyone folded. The actors are only players who bet, raised or called - and not players who folded. So using this filter will not filter through any hands where CO player didn't fold to SB's 3-bet.

[Vleesjas]

Hello,

Using the cash_hand_summary.str_actors_p = '19' expression filter will only filter hands where CO raised, SB 3-betted, and then everyone folded. The actors are only players who bet, raised or called - and not players who folded. So using this filter will not filter through any hands where CO player didn't fold to SB's 3-bet.

That clears up a lot, looks like I need to get some more insides on using expression filters instead of just copying them (knew that beforehand but the lazy option is the most tempting one when learning a new skill ) Thanks for the quick reply !

[Vleesjas]

Hello,

Using the cash_hand_summary.str_actors_p = '19' expression filter will only filter hands where CO raised, SB 3-betted, and then everyone folded. The actors are only players who bet, raised or called - and not players who folded. So using this filter will not filter through any hands where CO player didn't fold to SB's 3-bet.

I'm trying to filter for the specific scenario where hero opens CO as RFI, and SB 3-betted. All other scenario's included (CU folding/callen/raising etc.) to get an idea of howmuch pool is 3betting SB vs my CU open. Any idea how to realise this? All help is welcome

[Flag_Hippo]

To filter hands where CO raised first in and SB 3bets without any other players involved you can use this expression filter:

Code: Select all

cash_hand_summary.str_aggressors_p LIKE '819%' and cash_hand_summary.str_actors_p LIKE '19%' and cash_hand_summary.str_actors_p NOT LIKE '198%'

This post has more information on how the actors and aggressors strings work if you want to filter for different situations and for more information on pattern matching in PostgreSQL see this guide.