Page 1 of 1

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

PostPosted: Wed Apr 21, 2021 10:55 am
by plukhead
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])

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

PostPosted: Thu Apr 22, 2021 2:15 pm
by Flag_Hippo
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])

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

PostPosted: Thu Apr 22, 2021 9:00 pm
by plukhead
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

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

PostPosted: Fri Apr 23, 2021 7:04 am
by Flag_Hippo
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.

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

PostPosted: Fri Apr 23, 2021 10:28 am
by plukhead
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?

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

PostPosted: Fri Apr 23, 2021 2:49 pm
by Flag_Hippo
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.

highfalutin