3H, BU fold, SB OS eff stack size at particular blind level

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

3H, BU fold, SB OS eff stack size at particular blind level

Postby DJSpinThat » Sat Oct 02, 2021 7:15 am

Hi,

Not sure what im doing wrong.

I'm trying to make a stat where,
-its 3handed
-big blind is 30
-BTN folds
-SB open shoves
-eff stack sizes are 13-16bb

i used the raise first in stat as a base but its not working.

Stat:
RFI_BB30_OS_13to16bb

(cnt_p_raise_first_in_BB30_OS_13to16bb / cnt_p_open_opp_BB30_13to16bb ) * 100

Columns:
cnt_p_raise_first_in_BB30_OS_13to16bb

sum(if[tourney_blinds.amt_bb=30 and
tourney_hand_player_statistics.amt_p_raise_made > tourney_hand_player_statistics.amt_p_effective_stack and
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 13 and 16 and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.flg_p_open_opp, 1, 0])


cnt_p_open_opp_BB30_13to16bb

sum(if[tourney_blinds.amt_bb=30 and
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 13 and 16 and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

Also, i set the Item Properties/Position to SB.


-if its 15/30, and we all started with 500chips, i have 485chips, BB has 470, i shove SB, BB folds, but the stat doesn't count this, but it seemed to count it when SB had the bigger stack than the BB, posted chips not included.

Is there a better way to create this stat?

Thank you.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby Flag_Hippo » Sun Oct 03, 2021 6:03 am

If all players started a hand with 500 chips then the effective stacks are more than 16BB:

500 / 30 = 16.66

A players effective stack in a hand is after antes and before (includes) blinds.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby DJSpinThat » Sun Oct 03, 2021 10:20 am

ok thank you.

I have another question,

I'm trying to create a stat to count the number of times BB raised SB limp.
Where, 3Handed, BTN folded, SB limped, and BB raised SB limp.

The "Raise With Previous Limpers" stat counts the situation where BTN limped, SB limped and BB raised.

I'm having trouble trying to figure out the expression that stipulates that the BTN folded and SB limped.

Thank you for your help.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby Flag_Hippo » Sun Oct 03, 2021 2:02 pm

You can specify that the SB was the first player to VPIP with:

Code: Select all
tourney_hand_summary.str_actors_p LIKE '9%'

This post has more information on how the actors and aggressors strings work.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby Mike_ » Mon Oct 04, 2021 8:32 am

I have these stats on my HUD if you still need them ?
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby DJSpinThat » Tue Oct 05, 2021 2:45 am

yes that would be awesome!

I'm also trying to create the opposite, SB limps then BB iso, and see SB LF to iso, LC to iso and L shoves to iso. If you have that would be great, if not thats ok.

Much appreciated :D
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby DJSpinThat » Wed Oct 06, 2021 6:58 am

Is the following correct? I'm coming up with less hands than i thought in my database.

1. 3H. BU fold. SB limp. BB iso up to 4x. SB Folds. Eff stack between 10-12bb.

Preflop Limp Fold_SB=<4x_10to12bb
(cnt_p_limp_fold_SB_10to12bb / cnt_p_limp_faceraise_4x) * 100

cnt_p_limp_fold_SB_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_summary.str_actors_p LIKE '9%' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and lookup_actions_p.action = 'CF', 1, 0])

cnt_p_limp_faceraise_4x:
sum(if[tourney_hand_player_statistics.flg_p_limp AND
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb <= 4 and
tourney_hand_player_statistics.flg_p_face_raise, 1, 0])


2. 3H. BU fold. SB limp. BB iso up to 4x. SB calls. Eff stack between 10-12bb.

Preflop Limp Call_SB=<4x_10to12bb:
(cnt_p_limp_call_SB_10to12bb / cnt_p_limp_faceraise_4x) * 100

cnt_p_limp_call_SB_10to12bb
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_summary.str_actors_p LIKE '9%' and
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12
and lookup_actions_p.action LIKE 'CC%', 1, 0])


3. 3H. BU fold. SB limp. BB iso up to 4x. SB shoves. Eff stack between 10-12bb.

Preflop Limp Shove_SB=<4x_10to12bb:
(cnt_p_limp_shove_SB_10to12bb / cnt_p_limp_faceraise_4x) * 100

cnt_p_limp_shove_SB_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and (tourney_hand_player_statistics.amt_p_raise_made > tourney_hand_player_statistics.amt_p_effective_stack) and tourney_hand_summary.str_actors_p LIKE '9%' and lookup_actions_p.action LIKE 'CR%', 1, 0])


Thank you.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby Flag_Hippo » Thu Oct 07, 2021 5:10 am

DJSpinThat wrote:BB iso up to 4x

DJSpinThat wrote:cnt_p_limp_fold_SB_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_summary.str_actors_p LIKE '9%' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and lookup_actions_p.action = 'CF', 1, 0])

You haven't specified here that the player is facing a 4x 2Bet (amt_p_2_bet_facing) so what you are going to get is the number of hands the player limp folds vs any 2Bet size.
DJSpinThat wrote:BB iso up to 4x

DJSpinThat wrote:Eff stack between 10-12bb

DJSpinThat wrote:cnt_p_limp_faceraise_4x:
sum(if[tourney_hand_player_statistics.flg_p_limp AND
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb <= 4 and
tourney_hand_player_statistics.flg_p_face_raise, 1, 0])

This player is not the player making the initial raise so you shouldn't be using amt_p_raise_made here. You need to use amt_p_2_bet_facing instead of amt_p_raise_made to specify the size of the 2Bet faced and you can remove flg_p_face_raise. Also bear in mind that amt_p_2_bet_facing is the amount the player needs to call which isn't the same thing as the absolute size of the 2Bet if the player limped and/or is in the blinds. Finally you haven't specified an effective stack size of 10-12BB in this column.
DJSpinThat wrote:BB iso up to 4x

DJSpinThat wrote:cnt_p_limp_call_SB_10to12bb
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_summary.str_actors_p LIKE '9%' and
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12
and lookup_actions_p.action LIKE 'CC%', 1, 0])

You need to use amt_p_2_bet_facing if you want to specify the size of the 2Bet faced.
DJSpinThat wrote:BB iso up to 4x

DJSpinThat wrote:cnt_p_limp_shove_SB_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and (tourney_hand_player_statistics.amt_p_raise_made > tourney_hand_player_statistics.amt_p_effective_stack) and tourney_hand_summary.str_actors_p LIKE '9%' and lookup_actions_p.action LIKE 'CR%', 1, 0])

You need to use amt_p_2_bet_facing if you want to specify the size of the 2Bet faced. Also use >= when comparing the size of the players raise to their effective stack otherwise you will miss a large percentage of all-in hands since it is impossible for the player with the smaller stack to make a raise that's larger than their effective stack.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby DJSpinThat » Thu Oct 07, 2021 6:52 am

Thank you for explaining!

I'll try figuring it out :)
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: 3H, BU fold, SB OS eff stack size at particular blind le

Postby DJSpinThat » Fri Oct 08, 2021 6:51 am

i think i got the others, just wanted to make sure if the following looks correct?

cnt_p_limp_faceraise_4x_10to12bb

sum(if[tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb <=4 and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 and tourney_hand_player_statistics.flg_p_limp, 1, 0])
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 29 guests

cron