Folding around to the SB

[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?

[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'.

[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?

[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

[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.

[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.

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.

[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'.

[abostick59]

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.

[Flag_Hippo]

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.

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.