## <1/3 SE

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

### <1/3 SE

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

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

Captura
Attachments

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

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)))`
Flag_Hippo
Moderator

Posts: 11610
Joined: Tue Jan 31, 2012 7:50 am

### Re: <1/3 SE

lo intente de esta manera ,pero no funciona correctamente
Attachments
2.PNG (2.47 KiB) Viewed 406 times

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

intento construir 3bet<1/3 SE de BB vs MR<3.5bb de SB ,button fold

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

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`
Flag_Hippo
Moderator

Posts: 11610
Joined: Tue Jan 31, 2012 7:50 am

### Re: <1/3 SE

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
Attachments
rol.PNG (2.53 KiB) Viewed 366 times

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

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.
Flag_Hippo
Moderator

Posts: 11610
Joined: Tue Jan 31, 2012 7:50 am

### Re: <1/3 SE

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])

Posts: 84
Joined: Mon Sep 16, 2019 11:16 pm

### Re: <1/3 SE

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 = 8AND 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 75AND tourney_hand_player_statistics.cnt_p_face_limpers > 0AND 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 = 8AND 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 75AND tourney_hand_player_statistics.cnt_p_face_limpers > 0, 1, 0])`
Flag_Hippo
Moderator

Posts: 11610
Joined: Tue Jan 31, 2012 7:50 am