I programmed a stat where it sums when the Villain Bets on the River a size between 90% and 110% of the Pot:
- Code: Select all
(fp_cnt_r_bet_pot_wtsd_won / fp_cnt_r_bet_pot_wtsd) * 100
fp_cnt_r_bet_pot_wtsd (going to showdown after betting):
- Code: Select all
sum(if[
tourney_hand_player_statistics.flg_r_bet
AND (tourney_hand_player_statistics.amt_bet_r BETWEEN (0.90 * tourney_hand_summary.amt_pot) AND (1.1 * tourney_hand_summary.amt_pot) )
AND tourney_hand_player_statistics.flg_showdown
, 1, 0])
fp_cnt_r_bet_pot_wtsd_won (going to Showdown and winning the hand after betting):
- Code: Select all
sum(if[
tourney_hand_player_statistics.flg_r_bet
AND (tourney_hand_player_statistics.amt_bet_r BETWEEN (0.90 * tourney_hand_summary.amt_pot) AND (1.1 * tourney_hand_summary.amt_pot) )
AND tourney_hand_player_statistics.flg_showdown
AND tourney_hand_player_statistics.flg_won_hand
, 1, 0])
I put it here because IS NOT WORKING.
Per example, this hand should sum the stat:
- Code: Select all
GAME #5115494254 Version:20.3.6.5 Uncalled:Y Texas Hold'em NL Tournament 2020-11-14 18:17:49/GMT
Table Sit’n’Go Twister 20€ EU, 616676542, 616676541 (Tournament: Sit’n’Go Twister 20€ EU Buy-In: €18.60 + €1.40)
Seat 3: DESP0o (€910.00 in chips)
Seat 10: ILovePiwo (€590.00 in chips) DEALER
ILovePiwo: Post Ante €5.00
DESP0o: Post Ante €5.00
ILovePiwo: Post SB €15.00
DESP0o: Post BB €30.00
*** HOLE CARDS ***
Dealt to ILovePiwo [SK D4]
ILovePiwo: Call €15.00
DESP0o: Check
*** FLOP *** [D9 DK C3]
DESP0o: Check
ILovePiwo: Bet €35.00
DESP0o: Call €35.00
*** TURN *** [D7]
DESP0o: Check
ILovePiwo: Check
*** RIVER *** [D5]
DESP0o: Bet €120.00
ILovePiwo: Call €120.00
*** SUMMARY ***
Total pot €380.00 Rake €0.00
ILovePiwo: Shows [SK D4] Flush, King High
DESP0o: Shows [S3 S8] One Pair, Threes
ILovePiwo: wins €380.00
I guess i´m doing something wrong, can you help me finding the error?
Thanks!
