Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by lnsertCoin » Thu Jul 18, 2019 7:40 am
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])
-
lnsertCoin
-
- Posts: 7
- Joined: Fri Apr 25, 2014 3:12 pm
by lnsertCoin » Thu Jul 18, 2019 9:48 am
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])
-
lnsertCoin
-
- Posts: 7
- Joined: Fri Apr 25, 2014 3:12 pm
by lnsertCoin » Thu Jul 18, 2019 1:38 pm
after some more testing, i noticed that 2 post also don't work as intendet, still need help with that
sorry for confusion
-
lnsertCoin
-
- Posts: 7
- Joined: Fri Apr 25, 2014 3:12 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: Google [Bot], Yahoo [Bot] and 45 guests