Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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: 117
- Joined: Mon Sep 16, 2019 11:16 pm
by 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: 14505
- Joined: Tue Jan 31, 2012 7:50 am
by 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: 117
- Joined: Mon Sep 16, 2019 11:16 pm
by 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: 14505
- Joined: Tue Jan 31, 2012 7:50 am
by 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: 117
- Joined: Mon Sep 16, 2019 11:16 pm
by 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: 14505
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 26 guests