Raise over limpers IP/OOP

[ttesone]

Hi!

I'm trying to make two stats:

ROL IP stat to 4bb+. So far I got this:
sum(if[cash_hand_player_statistics.flg_p_first_raise AND NOT cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.position between 0 and 6 and cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4,1,0])

ROL OOP to 4.1bb+. So far I got this:
sum(if[cash_hand_player_statistics.flg_p_first_raise AND NOT cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.position between 8 and 9 and cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4.1,1,0])

I'm missing the IP/OOP part. I know I should be using str_aggressors_p, but never know how to use it properly.

[Flag_Hippo]

Only the BB can raise limpers IP & OOP. When the BB raises IP then that would be when the SB is the only limper but only for multiway hands:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_first_raise and not cash_hand_player_statistics.flg_p_open_opp and (cash_hand_player_statistics.position between 0 and 6 or cash_hand_player_statistics.position = 8 and cash_hand_summary.str_actors_p like '9%' and cash_hand_summary.cnt_players > 2) and (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4),1,0])

and in all other cases the BB would be OOP including heads up hands where the SB limps:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_first_raise and not cash_hand_player_statistics.flg_p_open_opp and (cash_hand_player_statistics.position = 9 or cash_hand_player_statistics.position = 8 and (cash_hand_summary.str_actors_p not like '9%' or cash_hand_summary.str_actors_p like '9%' and cash_hand_summary.cnt_players = 2)) and (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4.1),1,0])

[ttesone]

I probably didn't explain myself correctly.

I want to make two different stats. The first one would be ROL IP to 4bb+ (also would be nice to only count when there is just 1 limper). For example: UTG limps, CO rol to 4bb. Also would need to exclude BB vs SB as this would be an exception.

The other stat would be ROL OOP to 4.1bb+: For example: CO limps, SB rol to 4.5bb.

[Flag_Hippo]

I probably didn't explain myself correctly.

I want to make two different stats. The first one would be ROL IP to 4bb+ (also would be nice to only count when there is just 1 limper). For example: UTG limps, CO rol to 4bb. Also would need to exclude BB vs SB as this would be an exception.

Your original column already does this apart from specifying that one limper was faced:

Code: Select all

cash_hand_player_statistics.cnt_p_face_limpers = 1

The other stat would be ROL OOP to 4.1bb+: For example: CO limps, SB rol to 4.5bb.

Again your original column basically already does that apart from testing for a single limper being faced. If you don't want to count hands where the BB raised an SB limper then you can do that by testing the actors and/or aggressors strings as I did in my previous reply - see this post for more information on how the actors and aggressors strings work.

[ttesone]

Would something like this work? Just put every possible scenario in the formula:

sum(if[cash_hand_player_statistics.flg_p_first_raise AND NOT cash_hand_player_statistics.flg_p_open_opp AND ((cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) > 4) AND cash_hand_player_statistics.cnt_p_face_limpers = 1 AND ((cash_hand_player_statistics.position = 0 and (cash_hand_summary.str_actors_p like '10%' or cash_hand_summary.str_actors_p like '20%' or cash_hand_summary.str_actors_p like '30%' or cash_hand_summary.str_actors_p like '40%' or cash_hand_summary.str_actors_p like '50%' or cash_hand_summary.str_actors_p like '60%' or cash_hand_summary.str_actors_p like '70%')) or
(cash_hand_player_statistics.position = 1 and (cash_hand_summary.str_actors_p like '21%' or cash_hand_summary.str_actors_p like '31%' or cash_hand_summary.str_actors_p like '41%' or cash_hand_summary.str_actors_p like '51%' or cash_hand_summary.str_actors_p like '61%' or cash_hand_summary.str_actors_p like '71%')) or
(cash_hand_player_statistics.position = 2 and (cash_hand_summary.str_actors_p like '32%' or cash_hand_summary.str_actors_p like '42%' or cash_hand_summary.str_actors_p like '52%' or cash_hand_summary.str_actors_p like '62%' or cash_hand_summary.str_actors_p like '72%')) or
(cash_hand_player_statistics.position = 3 and (cash_hand_summary.str_actors_p like '43%' or cash_hand_summary.str_actors_p like '53%' or cash_hand_summary.str_actors_p like '63%' or cash_hand_summary.str_actors_p like '73%')) or
(cash_hand_player_statistics.position = 4 and (cash_hand_summary.str_actors_p like '54%' or cash_hand_summary.str_actors_p like '64%' or cash_hand_summary.str_actors_p like '74%')) or
(cash_hand_player_statistics.position = 5 and (cash_hand_summary.str_actors_p like '65%' or cash_hand_summary.str_actors_p like '75%')) or
(cash_hand_player_statistics.position = 6 and (cash_hand_summary.str_actors_p like '76%'))),1,0])

[Flag_Hippo]

You don't need to test the actors string because all of that is already implied with just this:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.cnt_p_face_limpers = 1 AND cash_hand_player_statistics.position between 0 and 6 AND (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4),1,0])

If a player in positions 0-6 is facing and isolating one limper then that player can only be in position relative to the limper.

[ttesone]

Great, thanks!

I do need to check string actors for raise over limpers oop from blinds, right? Because from SB you will always be OOP, but from BB there's the case where SB limps and I need to remove that scenario

[Flag_Hippo]

Yes. If you want to exclude SB limps for the blinds then that would be:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.cnt_p_face_limpers = 1 AND cash_hand_player_statistics.position between 8 and 9 AND cash_hand_summary.str_actors_p not like '9%' AND (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb > 4.1),1,0])