Page 1 of 1

Folding around to the SB

PostPosted: Mon Aug 31, 2020 11:26 pm
by dirty moose
Hey all,

I'm trying to set a filter where the pot is folded around to me in the SB but can't seem to get it. I want to see my action after it's folded to me. What am I missing?

Re: Folding around to the SB

PostPosted: Tue Sep 01, 2020 5:45 am
by Flag_Hippo
Filter for being in the small blind via 'Hand Details -> Player Position' and having the opportunity to open the pot (or steal) in 'Actions & Opportunities -> Preflop -> Preflop Opportunities'.

Re: Folding around to the SB

PostPosted: Tue Sep 01, 2020 12:39 pm
by dirty moose
Thx Hippo,

Is there a way to show weather I've limped/raised or folded? Or can I only see on at a time?

Re: Folding around to the SB

PostPosted: Wed Sep 02, 2020 4:25 am
by Flag_Hippo
If you are in a hand report there is a column called 'PF Act' which displays the actions you took preflop and you can sort that column by clicking on the column header. If you are in a player report you can add statistics to your report to show you the frequencies/ratios of each action:

Guide: Configuring Reports

Re: Folding around to the SB

PostPosted: Sat Sep 05, 2020 1:35 pm
by abostick59
Hi, I am bumping this old thread because I have a related question: I want to filter for situations where the action is folded around to the small blind and the hero is in the big blind. I have been looking for a way to do this, but so far it has been eluding me.

Re: Folding around to the SB

PostPosted: Sat Sep 05, 2020 10:38 pm
by abostick59
abostick59 wrote:Hi, I am bumping this old thread because I have a related question: I want to filter for situations where the action is folded around to the small blind and the hero is in the big blind. I have been looking for a way to do this, but so far it has been eluding me.

This works for hands that the SB opens, i.e. is first in with a raise:
)Players Dealt into Hand Between 3 and 10) AND Position of Active Player Position of Selected Exactly 8) AND Position of First Raiser Position of Selected Exactly 9) AND (Number of Limpers Exactly 0)
Getting hands where the action folds to the SB and they limp/complete is still eluding me. The best I can come up with is a filter where the hero in the BB faces a single limper in any position.

Re: Folding around to the SB

PostPosted: Sun Sep 06, 2020 6:09 am
by Flag_Hippo
There isn't a built-in filter for the positions of limpers/callers however you can use the following filter expression in 'My Reports' which ensures a small blind limp:

Code: Select all
cash_hand_summary.str_actors_p LIKE '9%' and cash_hand_summary.str_aggressors_p NOT LIKE '89%'

See this post for more information on how the actors and aggressors strings work. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For a tournament report just substitute all instances of 'cash' with 'tourney'.

Re: Folding around to the SB

PostPosted: Sun Sep 06, 2020 1:43 pm
by abostick59
Flag_Hippo wrote:There isn't a built-in filter for the positions of limpers/callers however you can use the following filter expression in 'My Reports' which ensures a small blind limp:

Code: Select all
cash_hand_summary.str_actors_p LIKE '9%' and cash_hand_summary.str_aggressors_p NOT LIKE '89%'

See this post for more information on how the actors and aggressors strings work. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For a tournament report just substitute all instances of 'cash' with 'tourney'.


Thank you for your help.

So if I am reading this correctly, this filter expression picks out times that (a) the SB is the only player to VPIP, and (b) the SB did not raise. Have I got that right?

Because if I do, that only covers situations where the action is folded to the SB, they complete, and the BB checks behind. Or does the aggressor string for the BB stay the same if there are raises and reraises?

I want to be sure I am including situations where the SB completes and the BB raises. In particular, I want to be sure that I am including situations where the SB completes, the BB raises, and the SB three-bets.

I really appreciate the assistance; this is my first foray into PostgreSQL query construction.

Re: Folding around to the SB

PostPosted: Mon Sep 07, 2020 2:25 am
by Flag_Hippo
abostick59 wrote:So if I am reading this correctly, this filter expression picks out times that (a) the SB is the only player to VPIP, and (b) the SB did not raise. Have I got that right?

The expression filter specifies that the SB open limped but it's still possible for the BB to VPIP.
abostick59 wrote:I want to be sure I am including situations where the SB completes and the BB raises. In particular, I want to be sure that I am including situations where the SB completes, the BB raises, and the SB three-bets.

Yes these situations would be included since the % signs within the filter captures all possible actions after the initial SB open limp. For more information on pattern matching in PostgreSQL see this guide.