cbet check bet

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

cbet check bet

Postby plukhead » Wed Apr 07, 2021 3:02 pm

hola necesito ayuda para hacer una stats para spin and go ,que cuente % de veces que en 3h button fold ,SB hace OR < a 3.5bb, BB call ,cbet flop,BB call ,en turn check check,y riber SB betea ...intente hacerlo de esta manera pero no funciona

(bet_x_bet_SBvsBB / bet_x_bet_oop_SBvsBB) * 100


bet_x_bet_SBvsBB
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet_opp
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0)
AND tourney_hand_player_statistics.flg_r_bet, 1, 0])

bet_x_bet_oop_SBvsBB
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet_opp
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0), 1, 0])
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby Flag_Hippo » Thu Apr 08, 2021 3:29 am

plukhead wrote:que cuente % de veces que en 3h button fold

Your columns do not specify 3 handed play so you would need to add tourney_hand_summary.cnt_players = 3.
plukhead wrote:SB hace OR < a 3.5bb, BB call

Your columns do not exclude pots where SB limp-raises or 4bets preflop. Instead of using tourney_hand_summary.str_actors_p NOT LIKE '0%' you can use tourney_hand_summary.str_aggressors_p = '89' AND tourney_hand_summary.str_actors_p = '98' to account for that and the BTN not VPIPing.
plukhead wrote:tourney_hand_player_statistics.flg_f_cbet_opp

This isn't needed. It will always be true when tourney_hand_player_statistics.flg_f_cbet is true and you are already using that.

Code: Select all
sum(if[tourney_hand_player_statistics.position = 9
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_aggressors_p = '89'
AND tourney_hand_summary.str_actors_p = '98'
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT tourney_hand_player_statistics.amt_t_bet_facing > 0
AND tourney_hand_player_statistics.flg_r_bet, 1, 0])

Code: Select all
sum(if[tourney_hand_player_statistics.position = 9
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_aggressors_p = '89'
AND tourney_hand_summary.str_actors_p = '98'
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) <= 3.5
AND tourney_hand_player_statistics.flg_f_cbet
AND tourney_hand_player_statistics.flg_t_cbet_opp
AND NOT (tourney_hand_player_statistics.flg_t_cbet)
AND NOT tourney_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: cbet check bet

Postby plukhead » Thu Apr 08, 2021 8:48 am

No necesito especificar q hay 3 jugadores debido a q el hud esta configurado para funcionar solo cuando hay entre 3 y 3 jugadores. De todas maneras la escribí tal cual lo hiciste vos y el error continúa, la stat no funciona correctamente
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby plukhead » Thu Apr 08, 2021 8:53 am

Dejo captura del error value (54) 17/81
Attachments
Screenshot_20210408-095146.png
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby Flag_Hippo » Thu Apr 08, 2021 11:54 am

Have you rebuilt your custom cache (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild)?
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: cbet check bet

Postby plukhead » Thu Apr 08, 2021 2:04 pm

gracias ahi se soluciono....en caso de querer una stat similar pero para limped pot ,seria correcto escribirla de esta manera?(%de veces q en 3h button fold SB limp BB check ,flop sb betea BB paga,turn checkean ambos y river SB betea)

sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p = '98'
AND char_length(tourney_hand_summary.str_aggressors_p) = 1
and NOT(tourney_hand_player_statistics.flg_p_face_raise)
AND tourney_hand_player_statistics.flg_f_bet
and NOT(tourney_hand_player_statistics.flg_f_face_raise)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0)
AND NOT (tourney_hand_player_statistics.flg_t_bet)
AND tourney_hand_player_statistics.flg_r_bet, 1, 0])



sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p = '98'
AND char_length(tourney_hand_summary.str_aggressors_p) = 1
and NOT(tourney_hand_player_statistics.flg_p_face_raise)
AND tourney_hand_player_statistics.flg_f_bet
and NOT(tourney_hand_player_statistics.flg_f_face_raise)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0)
AND NOT (tourney_hand_player_statistics.flg_t_bet), 1, 0])

no necesito especificar q haya 3 jugadores en la mesa ya q el hud esta configurado para ello
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby Flag_Hippo » Fri Apr 09, 2021 6:48 am

plukhead wrote:tourney_hand_summary.str_actors_p = '98'

This means that the BB VPIP'd after the SB so that will not work. Use tourney_hand_summary.str_actors_p = '9' instead.
plukhead wrote:AND char_length(tourney_hand_summary.str_aggressors_p) = 1
and NOT(tourney_hand_player_statistics.flg_p_face_raise)

Both of these are not needed. If the aggressors string is 1 (nobody raised) then it is not possible for the player to face a preflop raise either.
plukhead wrote:AND tourney_hand_player_statistics.flg_f_bet
and NOT(tourney_hand_player_statistics.flg_f_face_raise)
AND NOT (tourney_hand_player_statistics.amt_t_bet_facing > 0)
AND NOT (tourney_hand_player_statistics.flg_t_bet)

For your opportunities column all of this would still be true if the player bet all-in on the flop. You can specify the player checked the turn using lookup_actions_t.action = 'X' (if they checked the turn then they couldn't have been all-in on the flop). You can also use lookup_actions_f.action = 'B' instead of tourney_hand_player_statistics.flg_f_bet
and NOT(tourney_hand_player_statistics.flg_f_face_raise)
to simplify the expression.
plukhead wrote:no necesito especificar q haya 3 jugadores en la mesa ya q el hud esta configurado para ello

Bear in mind that if you use these types statistics in a heads up HUD then the SB has position postflop so you'd also need to add tourney_hand_player_statistics.flg_r_open_opp to the opportunities column. It's technically not required in these columns for three handed play when SB is OOP but it's good practice to include it anyway.

Code: Select all
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p = '9'
AND char_length(tourney_hand_summary.str_aggressors_p) = 1
AND lookup_actions_f.action = 'B'
AND lookup_actions_t.action = 'X'
AND tourney_hand_player_statistics.flg_r_bet, 1, 0])

Code: Select all
sum(if[tourney_hand_player_statistics.position=9
AND tourney_hand_summary.str_actors_p = '9'
AND char_length(tourney_hand_summary.str_aggressors_p) = 1
AND lookup_actions_f.action = 'B'
AND lookup_actions_t.action = 'X'
AND tourney_hand_player_statistics.flg_r_open_opp, 1, 0])
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: cbet check bet

Postby plukhead » Fri Apr 09, 2021 10:42 am

gracias esto fue de gran ayuda ,la unica duda q me queda es turn al escribir " lookup_actions_t.action = 'X'" no es posible que el villano betee turn luego de que demos check ?
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby plukhead » Fri Apr 09, 2021 10:47 am

y en flop al escribir "AND lookup_actions_f.action = 'B'" no es posible que el villano raise NO allin flop y sb pague haciendo posible el check de turn?
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: cbet check bet

Postby Flag_Hippo » Fri Apr 09, 2021 2:04 pm

plukhead wrote:y en flop al escribir "AND lookup_actions_f.action = 'B'" no es posible que el villano raise NO allin flop y sb pague haciendo posible el check de turn?

plukhead wrote:gracias esto fue de gran ayuda ,la unica duda q me queda es turn al escribir " lookup_actions_t.action = 'X'" no es posible que el villano betee turn luego de que demos check ?

No those wouldn't be possible.

lookup_actions_f.action = 'B' specifies that the ONLY action the player took on the flop was a bet so they couldn't have faced a raise.

lookup_actions_t.action = 'X' specifies that the ONLY action the player took on the turn was a check so they couldn't have faced a bet.

Examples:

lookup_actions_f.action = 'B' (player bet and ONLY bet)

lookup_actions_f.action = 'BF' (player bet/folded and ONLY bet/folded)

lookup_actions_f.action SIMILAR TO '(BF|BC|BR)' (player bet folded or bet called or bet raised)

lookup_actions_f.action LIKE 'B_' (player bet and took exactly one other action)

lookup_actions_f.action LIKE 'B%' (player bet and made any number of possible other actions afterwards (including no second action))

For more information on pattern matching in PostgreSQL see this guide.
Flag_Hippo
Moderator
 
Posts: 14440
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 24 guests

cron
highfalutin