PokerTracker

hola tengo problemas para escribir una stats que cuente fold vs cbet en isopot de BU vs BB
la secuencia seria BU limp,SB fold ,BB iso< 1/3 del SE ,BU call ,flop BB bet ,BU fold
lo intente de la siguiente manera

sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_summary.str_actors_p = '0'
AND NOT (tourney_hand_summary.str_actors_p = '09')
AND lookup_actions_p.action = 'LC'
AND tourney_hand_player_statistics.amt_p_raise_facing <
(tourney_hand_player_statistics.amt_p_effective_stack / 3)
AND lookup_actions_f.action = 'F' , 1, 0])

sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_summary.str_actors_p = '0'
AND NOT (tourney_hand_summary.str_actors_p = '09')
AND lookup_actions_p.action = 'LC'
AND tourney_hand_player_statistics.amt_p_raise_facing <
(tourney_hand_player_statistics.amt_p_effective_stack / 3)
AND tourney_hand_player_statistics.amt_f_bet_facing > 0 , 1, 0])

plukhead wrote:AND tourney_hand_summary.str_actors_p = '0'

With this you are saying only the BTN VPIP'd and they made one action. If the BTN limped, SB folds, BB raises and BTN calls then the actors string would be '080'. See this post for more information on how the actors and aggressors strings work.

plukhead wrote:AND lookup_actions_p.action = 'LC'

'L' isn't a valid action. The BTN actions preflop will be 'CC'.

ok gracias por otro lado quiero escribir cbet de BB vs BU en isopot
la secuencia seria ....
preflop -BU limp ,SB fold ,BB ISO no allin ,BU call
flop-BB bet
intente escribirla de la siguiente manera pero tengo dudas de que sea correcto

sum(if[tourney_hand_player_statistics.position=8
AND tourney_hand_summary.str_actors_p = '080'
AND tourney_hand_player_statistics.cnt_p_face_limpers > 0
AND tourney_hand_player_statistics.flg_p_first_raise
AND lookup_actions_f.action LIKE 'B%' , 1, 0 ])

That's fine.