face percent of potsize stat problem

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

face percent of potsize stat problem

Postby mkjmkjmkj » Sun Feb 19, 2012 10:35 am

i have made some custom stats for players calling different percents of the potsize
using this tourney_holdem_hand_player_detail.val_f_bet_facing_pct

the problem is that when there are multible callers the the potsize increases
so the first caller is not faced with the same percent size of the pot as the second caller
is there a solution to this

here is the stat i use for 90-110% of the potsize

(cnt_f_bet_90_110pct_action_call / cnt_f_bet_90_110pct_def_opp) * 100

cnt_f_bet_90_110pct_action_call =
sum( if[tourney_holdem_hand_player_detail.val_f_bet_facing_pct<= 52.4 AND tourney_holdem_hand_player_detail.val_f_bet_facing_pct>47.3 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%') , 1 , 0 ] )


cnt_f_bet_90_110pct_def_opp=
sum( if[tourney_holdem_hand_player_detail.val_f_bet_facing_pct<= 52.4 AND tourney_holdem_hand_player_detail.val_f_bet_facing_pct>47.3 , 1 , 0 ] )
mkjmkjmkj
 
Posts: 91
Joined: Mon May 30, 2011 5:41 am

Re: face percent of potsize stat problem

Postby kraada » Sun Feb 19, 2012 1:03 pm

There is not - the actual amount to call varies from player to player so they really aren't facing a bet of the same size. You can use the absolute amount that the player bet with the amt_x_bet_facing column if you would like to use exact amount bet, but when you're talking relative amounts to call it does vary from player to player so pretending it didn't would not be accurate.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 3 guests