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

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

Postby Flag_Hippo » Fri Oct 08, 2021 12:23 pm

DJSpinThat wrote: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])

If this is also for the SB then you haven't specified that here. Also when a player limps and another player raises to 4bb then the limper is facing a 2Bet of 3bb since that is the amount they now need to call. If you use 4bb then it will count hands where the 2Bet is 5BB. Finally since you are using <= then hands will get counted when amt_p_2bet_facing / tourney_blinds.amt_bb is zero and in these columns you don't want to count hands where the player didn't face a raise after limping.
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 » Mon Oct 18, 2021 7:13 am

is this correct?

sum(if[tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb <=4 and tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb >=1 and tourney_hand_player_statistics.position = 9 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

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

Postby Flag_Hippo » Mon Oct 18, 2021 12:19 pm

DJSpinThat wrote:tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb <=4 and tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb >=1

You are still using a facing value of up to 4 which will not work for what you want to count. You can also use between instead of and which will give you:

Code: Select all
tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3
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 » Mon Oct 18, 2021 11:23 pm

Thank you Hippo.

I summed it up, looks ok?

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_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100

cnt_p_limp_fold_SB_4x_10to12bb:

sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 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_10to12bb:

sum(if[tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 AND
tourney_hand_player_statistics.position = 9 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])


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_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100

cnt_p_limp_call_SB_4x_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_2bet_facing / tourney_blinds.amt_bb between 1 and 3 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_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100

cnt_p_limp_shove_SB_4x_10to12bb:

sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 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])
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 » Tue Oct 19, 2021 5:59 am

That looks fine.
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 » Fri Oct 22, 2021 10:50 am

I'm trying to do something similar but when the raise size is all-in but doesn't seem to work....

Preflop Limp CO_SB_AI_0to8bb
(cnt_p_limp_call_SB_AI_0to8bb / cnt_p_limp_faceraise_AI_0to8bb) * 100

cnt_p_limp_call_SB_AI_0to8bb:

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_2bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack) and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and lookup_actions_p.action LIKE 'CC%', 1, 0])


cnt_p_limp_faceraise_AI_0to8bb:

sum(if[tourney_hand_player_statistics.position = 9 AND tourney_hand_player_statistics.amt_p_2bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and tourney_hand_player_statistics.flg_p_limp, 1, 0])


Preflop Limp Fold_SB_AI_0to8bb
(cnt_p_limp_fold_SB_AI_0to8bb / cnt_p_limp_faceraise_AI_0to8bb) * 100

cnt_p_limp_fold_SB_AI_0to8bb:

sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_2bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_summary.str_actors_p LIKE '9%' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and lookup_actions_p.action = 'CF', 1, 0])
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 » Sat Oct 23, 2021 2:00 pm

As I've mentioned previously amt_p_2bet_facing is the amount the player needs to call so in this case you cannot compare that directly to this players effective stack because they have already invested 1BB by this point. You need to add tourney_blinds.amt_bb to the amount faced before comparing the two.
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 24, 2021 6:46 am

ok. i added that but i'm still not getting any values...

cnt_p_limp_call_SB_AI_0to8bb:
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_2bet_facing+tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack) and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and lookup_actions_p.action LIKE 'CC%', 1, 0])


cnt_p_limp_faceraise_AI_0to8bb:
sum(if[tourney_hand_player_statistics.position = 9 AND ((tourney_hand_player_statistics.amt_p_2bet_facing+tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack) and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and tourney_hand_player_statistics.flg_p_limp, 1, 0])


cnt_p_limp_fold_SB_AI_0to8bb
sum(if[tourney_hand_player_statistics.flg_p_limp AND ((tourney_hand_player_statistics.amt_p_2bet_facing+tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack) and tourney_hand_summary.str_actors_p LIKE '9%' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 8 and lookup_actions_p.action = 'CF', 1, 0])
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 24, 2021 2:38 pm

Rebuild your custom database cache (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild).
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 » Mon Oct 25, 2021 4:31 am

This worked. Appreciate the help, thank you.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

PreviousNext

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 26 guests

cron