BB vs BU in 3BP - Missing call CB opportunities

[olavfo]

This is from a Players report where I'm doing a population analysis. I'm filtering for HU 3B pots between BB and BU. BU opens with no limpers or posters in front of him. Then BB 3-bets without anybody (SB would be the only candidate) calling the raise before him. I also made it so that nobody is raising or calling all-in. Now I expect to get post flop stats for only BU and BB, which I do.



However, there is a discrepancy between BB's number of c-bets and BU's opportunities to call one:





BB c-bets 49,009 times but BU only has 45,368 opportunities to respond to them. Can you spot anything wrong in this filter or am I missing some nuance unrelated to the filter setup?

[Flag_Hippo]

Using simple filters in an "All Players" report is a bit more complicated as the filters are being applied from the perspective of each player. For example lets take this scenario:

Preflop: BTN raises, SB calls, BB 3bets, BTN folds, SB calls.
Flop: SB checks, BB cbets

These cbets will be included in that sample and the BTN is not facing these since they folded preflop. The reason you do not see that reflected in the SB stats is because of the "NOT (Called Preflop 2Bet)" filter (they did call a 2Bet preflop so that data is filtered out). Instead you can use an expression filter to specify that the SB did not VPIP after the BTN by clicking on the filters link and adding this expression filter:

cash_hand_summary.str_actors_p NOT LIKE '09%'

You need to change "cash" to "tourney" if you are in a tournament report.

[olavfo]

Thanks, I understand what happens now.

What I am after is to filter for this exact scenario to do a player pool analysis with an "All Players" report:

Code: Select all

Nobody has posted a blind anywhere, except the small blind and big blind. Nobody has limped. Some position A open-raises. Everybody folds to position B, who 3-bets. All remaining players between B and A folds. Position A calls the 3-bet.

For example, UTG folds, MP raises, it's folded to BU who 3-bets, it's folded back to MP who calls the 3-bet.
Or (as in my first post), everybody folds to BU, BU raises, SB folds, BB 3-bets, BU calls.

I would like to build a set of filters so I can set this scenario up for any pair of openraiser vs 3-bettor positions that I want:

UTG vs MP
UTG vs CO
UTG vs BU
UTG vs SB
UTG vs BB

MP vs CO
MP vs BU
MP vs SB
MP vs BB

CO vs BU
CO vs SB
CO vs BB

BU vs SB
BU vs BB

SB vs BB

I'm sure this can be done easily by building one expression where I can just modify the seat positions in for every pair of seats that I want to filter HU 3B pots for. But I am new to advanced filtering and building them by hand. Do you have some advice to offer?

Thanks in advance!

[Flag_Hippo]

If we use your example of MP raises, BU 3bets, MP calls you can use this expression filter (again changing "cash" to "tourney" if necessary):

cash_hand_summary.str_aggressors_p = '820' and cash_hand_summary.str_actors_p = '202'

The "aggressors" and "actors" strings are a series of numbers which represent the positions of each player to make an aggressive action (the "aggressors" string) or put money in (the "actors" string) in turn. The preflop aggressors string always starts with the BB position (8), the second number is the position of the 2bettor and the third the position of the 3bettor. The actors string records the positions of the players who VPIP'd (raised or called) in order. To change the numbers in the expression for other positions you can refer to this guide:

Guide: Reports, Stats, and Preferred Seating

Incidentally to specify that nobody posted a non standard blind or went/called an all in 3bet you can leave the simple filters for those active and they will work alongside the expression filter.

[olavfo]

Thanks!

If I wanted to group seats, for example letting BU 3-bet either UTG or MP and getting called by the raiser, would this work?

(cash_hand_summary.str_aggressors_p = '830' or cash_hand_summary.str_aggressors_p = '820') and (cash_hand_summary.str_actors_p = '302' or cash_hand_summary.str_actors_p = '202')

[Flag_Hippo]

That should work although there is an error in your actors string for EP vs BTN:

(cash_hand_summary.str_aggressors_p = '830' or cash_hand_summary.str_aggressors_p = '820') and (cash_hand_summary.str_actors_p = '303' or cash_hand_summary.str_actors_p = '202')

[olavfo]

Tyvm, this gives me all I need.