Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by Leopard » Sun Apr 10, 2022 7:51 am
sum(if[ (cash_hand_player_statistics.amt_t_effective_stack - cash_hand_player_statistics.amt_t_bet_made - cash_hand_player_statistics.amt_t_raise_made) - 0.7*( cash_hand_summary.amt_pot_t + 2*(cash_hand_player_statistics.amt_t_bet_made + cash_hand_player_statistics.amt_t_raise_made)) < 0 AND (cash_hand_player_statistics.cnt_t_raise > 0 or cash_hand_player_statistics.flg_t_bet) AND cash_hand_player_statistics.cnt_t_call = 0, 1, 0])
NOT working!
but if I delete *0.7 it works again!
Idea of column: how many times opponent do such stupid stake on Turn, when gets to River with SPR < 0.7
-
Leopard
-
- Posts: 24
- Joined: Tue Mar 26, 2013 2:58 pm
by Flag_Hippo » Mon Apr 11, 2022 6:39 am
If you want to test for an SPR of < .7 on the river then you should do that like this:
- Code: Select all
(cash_hand_player_statistics.amt_r_effective_stack / cash_hand_summary.amt_pot_r) < .7
-
Flag_Hippo
- Moderator
-
- Posts: 14512
- Joined: Tue Jan 31, 2012 7:50 am
by Leopard » Mon Apr 11, 2022 9:25 am
okay, 2 quastions:
1) is it principle to write .7 or 0.7 ?
2) my formula concerns not only cases when guys go to River. But also those, when defender folds Turn to overbig stake (but if he calls --> SPR river --> will go to <0.7)
-
Leopard
-
- Posts: 24
- Joined: Tue Mar 26, 2013 2:58 pm
by Flag_Hippo » Mon Apr 11, 2022 11:35 am
1) It doesn't matter.
2) In addition to the expression you've posted can you also please provide a written definiton of exactly what situation you want to be counted in your custom column.
-
Flag_Hippo
- Moderator
-
- Posts: 14512
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 19 guests