wwsdwbr y fold to river bet

Discuss how to create custom stats, reports and HUD profiles and share your creations.

wwsdwbr y fold to river bet

hola, necesito ayuda para escribir 2 stats
la primera es "wwsdwbr <35% del pozo"
% de veces que gana al SD cuando da bet en river < 35% del pozo y recibe un call ,sin importar si pagan uno o mas oponentes

sum(if[tourney_hand_player_statistics.flg_r_bet AND tourney_hand_player_statistics.flg_showdown AND NOT(tourney_hand_player_statistics.flg_r_3bet_opp) AND tourney_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

sum(if[tourney_hand_player_statistics.flg_r_bet AND tourney_hand_player_statistics.flg_showdown AND NOT(tourney_hand_player_statistics.flg_r_3bet_opp) AND NOT (lookup_actions_r.action='BC'), 1, 0])

si esto es correcto solo faltaria la condicion para bets< 35% del pozo

y la segunada stats es "fold to river bet < 35% del pozo"
% de veces que foldea en river cuando recibe bets <35 % del pozo

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0, 1, 0])

faltaria que filtre bets < 35 % del pozo .Gracias

Posts: 48
Joined: Mon Sep 16, 2019 11:16 pm

Re: wwsdwbr y fold to river bet

plukhead wrote:hola, necesito ayuda para escribir 2 stats
la primera es "wwsdwbr <35% del pozo"
% de veces que gana al SD cuando da bet en river < 35% del pozo y recibe un call ,sin importar si pagan uno o mas oponentes

sum(if[tourney_hand_player_statistics.flg_r_bet AND tourney_hand_player_statistics.flg_showdown AND NOT(tourney_hand_player_statistics.flg_r_3bet_opp) AND tourney_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

sum(if[tourney_hand_player_statistics.flg_r_bet AND tourney_hand_player_statistics.flg_showdown AND NOT(tourney_hand_player_statistics.flg_r_3bet_opp) AND NOT (lookup_actions_r.action='BC'), 1, 0])

You can just use:

Code: Select all
`tourney_hand_player_statistics.flg_showdown AND lookup_actions_r.action = 'B'`

Code: Select all
`tourney_hand_player_statistics.flg_r_bet AND tourney_hand_player_statistics.flg_showdown AND NOT(tourney_hand_player_statistics.flg_r_3bet_opp) AND NOT (lookup_actions_r.action='BC')`

It's a simplified expression and more accurate. For example these (incorrect) hands would be counted with your expressions:

br.PNG (10.04 KiB) Viewed 81 times

plukhead wrote:si esto es correcto solo faltaria la condicion para bets< 35% del pozo

Code: Select all
`tourney_hand_player_statistics.val_r_bet_made_pct <= 35`

plukhead wrote:y la segunada stats es "fold to river bet < 35% del pozo"
% de veces que foldea en river cuando recibe bets <35 % del pozo

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0 AND (lookup_actions_r.action SIMILAR TO '(F|XF)%'), 1, 0])

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0, 1, 0])

faltaria que filtre bets < 35 % del pozo .Gracias

Code: Select all
`tourney_hand_player_statistics.val_r_bet_facing_pct < 25.9`

(35 / (100 + 35)) * 100 = 25.9

The percentage of the pot faced is how much a player has to call - it's the pot odds and the bet amount is included. This definition is necessary in order to distinguish between situations where a bet has been called before a player or not (as the pot odds change as a result).
Flag_Hippo
Moderator

Posts: 10791
Joined: Tue Jan 31, 2012 7:50 am