Raise over limpers IP/OOP

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Raise over limpers IP/OOP

Postby ttesone » Tue Oct 15, 2024 10:03 am

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.
ttesone
 
Posts: 21
Joined: Tue Sep 30, 2008 5:38 pm

Re: Raise over limpers IP/OOP

Postby Flag_Hippo » Wed Oct 16, 2024 6:30 am

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])
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: Raise over limpers IP/OOP

Postby ttesone » Wed Oct 16, 2024 7:43 am

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.
ttesone
 
Posts: 21
Joined: Tue Sep 30, 2008 5:38 pm

Re: Raise over limpers IP/OOP

Postby Flag_Hippo » Wed Oct 16, 2024 12:12 pm

ttesone wrote: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

ttesone wrote: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.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: Raise over limpers IP/OOP

Postby ttesone » Wed Oct 23, 2024 6:11 pm

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])
ttesone
 
Posts: 21
Joined: Tue Sep 30, 2008 5:38 pm

Re: Raise over limpers IP/OOP

Postby Flag_Hippo » Thu Oct 24, 2024 7:13 am

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.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am

Re: Raise over limpers IP/OOP

Postby ttesone » Thu Oct 24, 2024 8:54 am

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
ttesone
 
Posts: 21
Joined: Tue Sep 30, 2008 5:38 pm

Re: Raise over limpers IP/OOP

Postby Flag_Hippo » Fri Oct 25, 2024 6:13 am

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])
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 10 guests

cron