Page 1 of 3

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

PostPosted: Sat Oct 02, 2021 7:15 am
by DJSpinThat
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.

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

PostPosted: Sun Oct 03, 2021 6:03 am
by Flag_Hippo
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.

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

PostPosted: Sun Oct 03, 2021 10:20 am
by DJSpinThat
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.

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

PostPosted: Sun Oct 03, 2021 2:02 pm
by Flag_Hippo
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.

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

PostPosted: Mon Oct 04, 2021 8:32 am
by Mike_
I have these stats on my HUD if you still need them ?

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

PostPosted: Tue Oct 05, 2021 2:45 am
by DJSpinThat
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

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

PostPosted: Wed Oct 06, 2021 6:58 am
by DJSpinThat
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.

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

PostPosted: Thu Oct 07, 2021 5:10 am
by Flag_Hippo
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.

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

PostPosted: Thu Oct 07, 2021 6:52 am
by DJSpinThat
Thank you for explaining!

I'll try figuring it out :)

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

PostPosted: Fri Oct 08, 2021 6:51 am
by DJSpinThat
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])

highfalutin