Page 1 of 1

Stat HU SB limp and fold vs allin preflop

PostPosted: Thu Jul 18, 2019 7:40 am
by lnsertCoin
Hi,
i want to count how often in HU SB limps and fold vs BB allin preflop

when the SB has less chips than BB it works, but when SB has more chips than BB it don't work. What's wrong with this?

Expression:
(limp_fold_vs_AI / limp_fold_vs_AI_opp) * 100

column: limp_fold_vs_AI
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin_action='F', 1, 0])

column: limp_fold_vs_AI_opp
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin='P', 1, 0])

Re: Stat HU SB limp and fold vs allin preflop

PostPosted: Thu Jul 18, 2019 9:48 am
by lnsertCoin
hi again, i made some changes to the columns and it looks like it's working now

column: limp_fold_vs_AI
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin_action='F'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 7), 1, 0])


column: limp_fold_vs_AI_opp
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 7), 1, 0])

Re: Stat HU SB limp and fold vs allin preflop

PostPosted: Thu Jul 18, 2019 1:38 pm
by lnsertCoin
after some more testing, i noticed that 2 post also don't work as intendet, still need help with that
sorry for confusion

highfalutin