Page 1 of 1

<1/3 SE

PostPosted: Mon Mar 08, 2021 2:58 pm
by plukhead
Hola necesito corregir esta columna, para que filtre situaciones en las q nos enfrentamos a pfr< a 3,5 BB y hacemos 3bet <1/3 del stack efectivo , resumiendo necesito construir 3bet NAI

Re: <1/3 SE

PostPosted: Mon Mar 08, 2021 7:27 pm
by plukhead
Captura

Re: <1/3 SE

PostPosted: Tue Mar 09, 2021 7:01 am
by Flag_Hippo
plukhead wrote:para que filtre situaciones en las q nos enfrentamos a pfr< a 3,5 BB

Code: Select all
(tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) < 3.5

plukhead wrote:y hacemos 3bet <1/3 del stack efectivo

Code: Select all
tourney_hand_player_statistics.flg_p_3bet and (tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_p_effective_stack * (1/3)))

Re: <1/3 SE

PostPosted: Wed Mar 10, 2021 11:48 pm
by plukhead
lo intente de esta manera ,pero no funciona correctamente

Re: <1/3 SE

PostPosted: Wed Mar 10, 2021 11:52 pm
by plukhead
intento construir 3bet<1/3 SE de BB vs MR<3.5bb de SB ,button fold

Re: <1/3 SE

PostPosted: Thu Mar 11, 2021 8:23 am
by Flag_Hippo
Apologies I forgot to adjust for BBs:

Code: Select all
((tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) + (tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb)) < 3.5

Re: <1/3 SE

PostPosted: Fri Mar 12, 2021 9:42 pm
by plukhead
gracias ahora funciona bien, eh intentado dividir tambien entre nai y ai la stats rol y no lo he logrado ....necesito ayuda ,quiero saber como hacer para que solo contemple rol < 1/3 del stack efectivo .A continuacion dejo captura de la stat que necesito modificar

Re: <1/3 SE

PostPosted: Sat Mar 13, 2021 1:30 pm
by Flag_Hippo
Can you please copy/paste the code directly into your replies (or attach an exported statistic) as I cannot copy/paste from your screenshots to test/edit. Thank you.

Re: <1/3 SE

PostPosted: Mon Mar 15, 2021 9:31 pm
by plukhead
necesito que esta stat cuente solo rol < 1/3 del stack efectivo.Gracias


(AA_BB_vs_SB_ROL_Tot_17 / AA_BB_vs_SB_ROL_opp_Tot_17) * 100



sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 75
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0
AND tourney_hand_player_statistics.flg_p_first_raise, 1, 0])

sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 75
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0, 1, 0])

Re: <1/3 SE

PostPosted: Wed Mar 17, 2021 1:49 pm
by Flag_Hippo
plukhead wrote:necesito que esta stat cuente solo rol < 1/3 del stack efectivo.

That should just be the addition of same expression as I gave before:

(AA_BB_vs_SB_ROL_Tot_17 / AA_BB_vs_SB_ROL_opp_Tot_17) * 100

AA_BB_vs_SB_ROL_Tot_17
Code: Select all
sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 75
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0
AND tourney_hand_player_statistics.flg_p_first_raise AND (tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_p_effective_stack * (1/3))), 1, 0])

AA_BB_vs_SB_ROL_opp_Tot_17
Code: Select all
sum(if[tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p NOT LIKE '0%'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 75
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0, 1, 0])