FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby plukhead » Wed Apr 21, 2021 10:55 am

hola necesito ayuda para comprobar si esta stats (FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)) esta bien escrita


(fold_t_donk_BUvsBB / fold_t_donk_oop_BUvsBB) * 100



fold_t_donk_BUvsBB

sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_summary.str_aggressors_p = '80'
AND tourney_hand_summary.str_actors_p = '08'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND lookup_actions_f.action = 'B'
AND lookup_actions_t.action = 'F' , 1, 0])


fold_t_donk_oop_BUvsBB

sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_summary.str_aggressors_p = '80'
AND tourney_hand_summary.str_actors_p = '08'
AND tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb <= 3.5
AND lookup_actions_f.action = 'B'
AND tourney_hand_player_statistics.amt_t_bet_facing > 0 , 1, 0])
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby Flag_Hippo » Thu Apr 22, 2021 2:15 pm

That looks fine although there isn't any need to multiply amt_p_raise_made by 1 and the expression will not validate unless you use brackets there:

sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_summary.str_aggressors_p = '80'
AND tourney_hand_summary.str_actors_p = '08'
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) <= 3.5
AND lookup_actions_f.action = 'B'
AND lookup_actions_t.action = 'F' , 1, 0])
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby plukhead » Thu Apr 22, 2021 9:00 pm

ok gracias ,entonces, para que las expresiones se validen cuando quiero filtrar pfr <=3.5 cuando tiene iniciativa ,debo escribirla asi
AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) <= 3.5
y cuando no tiene iniciativa estoy usando esta expresion
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_blinds.amt_bb /
tourney_blinds.amt_bb <= 3.5)
deberia cambiarla tambien para que se valide y escribirla de esta manera?
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_blinds.amt_bb /
tourney_blinds.amt_bb) <= 3.5
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby Flag_Hippo » Fri Apr 23, 2021 7:04 am

Yes but bear in mind if you are going to be using this for other positions adding tourney_blinds.amt_bb to the size of the 2Bet faced will only work for the BB. If you add tourney_hand_player_statistics.amt_blind instead (the amount the player actually posted) then it would work for any position.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby plukhead » Fri Apr 23, 2021 10:28 am

para estar seguro de que entendi correctamente
pfr<= 3.5bb

para que funciona en todas las posiciones
deberia reemplazar sin iniciativa
(tourney_hand_player_statistics.amt_p_2bet_facing + tourney_blinds.amt_bb /
tourney_blinds.amt_bb) <= 3.5
por
(tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind /
tourney_hand_player_statistics.amt_blind) <= 3.5

y con iniciativa

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) <= 3.5
por
(tourney_hand_player_statistics.amt_p_raise_made / tourney_hand_player_statistics.amt_blind) <= 3.5

es correcto?
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: FOLD TURN DONK BUvsBB spin and go (pfr<=3.5bb)

Postby Flag_Hippo » Fri Apr 23, 2021 2:49 pm

Flag_Hippo wrote:adding tourney_blinds.amt_bb to the size of the 2Bet faced

Only for those columns without initiative because the size of raise faced is the amount needed to call.
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 13 guests

cron