BB. bvsb SB limp, BB iso nAI, SB limp shoved, BB folded

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

BB. bvsb SB limp, BB iso nAI, SB limp shoved, BB folded

Postby DJSpinThat » Wed Oct 27, 2021 7:34 am

BB Isod SB Limp between 1-4x and Folded to shove.

I'm not sure what formula to use to specify that BB raised a limp and then faced a limp shove and he folded to that.

(Number of times player raised a limp and folded to shove ) / (Number of times player raised a limp and faced a shove )

(cnt_p_raise_SBlimp_foldedtoLshove) / (cnt_p_facedshove_afterisoNAI1-4x)


cnt_p_raise_SBlimp_foldedtoLshove

condition 1. hand was folded to SB who limped:
tourney_hand_summary.str_actors_p LIKE '9%'

C2. BB made the first raise (iso)
tourney_hand_player_statistics.flg_p_first_raise

C3. BB isod between 1-4bb:
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4

C4. BB raise folded to shove:
lookup_actions_p.action = 'RF'


....and not sure what else


cnt_p_facedshove_afterisoNAI

C5. Player is BB
tourney_hand_player_statistics.position = 8

C6. raise size faced is shove
(tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack


If you can advise me as to
1. what conditions are required for each column, and
2. what conditions i am missing and what they are

that would be great! Thank you.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: BB. bvsb SB limp, BB iso nAI, SB limp shoved, BB folded

Postby Flag_Hippo » Wed Oct 27, 2021 1:00 pm

DJSpinThat wrote:C6. raise size faced is shove
(tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack

This will not work because:

1. The BB is facing a 3Bet and not a 2Bet.

2. As I've mentioned to you more than once before the size of the raise faced is the amount the player needs to call. In other words its the difference between what chips have been invested (if any) and the absolute size of the raise made by the other player. You will need to add the size of the players first raise to the 3Bet faced before comparing to the BBs effective stack.
DJSpinThat wrote:1. what conditions are required for each column

The actions column needs all conditions. The opportunities column needs everything except lookup_actions_p.action = 'RF'.
DJSpinThat wrote:2. what conditions i am missing and what they are

Nothing else would be needed.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: BB. bvsb SB limp, BB iso nAI, SB limp shoved, BB folded

Postby DJSpinThat » Thu Oct 28, 2021 2:06 am

it didn't count it after testing the scenario. Is it correct?

Folded to SB LS after isoNAI

(cnt_p_raise_foldedtoSBLimpShove / (cnt_p_facedSBLimpShove)

cnt_p_raise_foldedtoSBLimpShove:

sum(if[
tourney_hand_player_statistics.position = 8 and
tourney_hand_summary.str_actors_p LIKE '9%' and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4 and
((tourney_hand_player_statistics.amt_p_3bet_facing+(tourney_hand_player_statistics.amt_p_raise_made/ tourney_blinds.amt_bb)) >= tourney_hand_player_statistics.amt_p_effective_stack) and
lookup_actions_p.action = 'RF', 1, 0])

cnt_p_facedSBLimpShove

sum(if[
tourney_hand_player_statistics.position = 8 and
tourney_hand_summary.str_actors_p LIKE '9%' and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4 and ((tourney_hand_player_statistics.amt_p_3bet_facing+tourney_hand_player_statistics.amt_p_raise_made) / tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])

This is still very complicated to me and not easy, thanks for the help.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: BB. bvsb SB limp, BB iso nAI, SB limp shoved, BB folded

Postby Flag_Hippo » Thu Oct 28, 2021 3:50 am

DJSpinThat wrote:cnt_p_raise_foldedtoSBLimpShove:

sum(if[
tourney_hand_player_statistics.position = 8 and
tourney_hand_summary.str_actors_p LIKE '9%' and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4 and
((tourney_hand_player_statistics.amt_p_3bet_facing+(tourney_hand_player_statistics.amt_p_raise_made/ tourney_blinds.amt_bb)) >= tourney_hand_player_statistics.amt_p_effective_stack) and
lookup_actions_p.action = 'RF', 1, 0])

cnt_p_facedSBLimpShove

sum(if[
tourney_hand_player_statistics.position = 8 and
tourney_hand_summary.str_actors_p LIKE '9%' and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb between 1 and 4 and ((tourney_hand_player_statistics.amt_p_3bet_facing+tourney_hand_player_statistics.amt_p_raise_made) / tourney_blinds.amt_bb) >= tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])

You just need to add the size of the players first raise to the 3Bet faced before comparing to the BBs effective stack. You are dividing part of that by the size of the blinds and that is going to break the comparison.
Flag_Hippo
Moderator
 
Posts: 14441
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 23 guests

cron