wwsdwbr y fold to river bet

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

wwsdwbr y fold to river bet

Postby plukhead » Fri May 07, 2021 10:13 am

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
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: wwsdwbr y fold to river bet

Postby Flag_Hippo » Sat May 08, 2021 5:48 am

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'

instead of:

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
br.PNG (10.04 KiB) Viewed 421 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: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Google [Bot] and 19 guests

cron
highfalutin