Stats sens

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

Stats sens

Postby raph156 » Sat Sep 17, 2011 4:37 am

Hi,
In this expression, does the sb count in the amount? So he raise 2,5bb + the SB post, that count a bet of 3bb or 2,5bb?
sum( if[holdem_hand_player_statistics.flg_blind_s and holdem_hand_player_detail.amt_bet_p BETWEEN (1 * holdem_limit.amt_bb) AND (3 * holdem_limit.amt_bb),1 ,0])


If a player bet 10bb, the other player raise to 30bb and he reraise to 60bb. I want the last bet was count as a 50bb bet and not a 60bb, cause i want the amount a player add in the pot, not the total bet for the street. With thise kind of expression, the logik is right?

sum(if[holdem_hand_player_detail.amt_bet_ttl BETWEEN (10 * holdem_limit.amt_bb) AND (25 * holdem_limit.amt_bb) and (holdem_hand_player_statistics.flg_won_hand), 1, 0])

Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby WhiteRider » Sat Sep 17, 2011 8:09 am

"holdem_hand_player_detail.amt_bet_p" is the total amount bet preflop.
If you want the sizes of specific raises then you need to use "holdem_hand_player_detail.amt_p_raise_made" (the first preflop raise) or "holdem_hand_player_detail.amt_p_raise_made_2" (the last preflop raise).

Similarly "holdem_hand_player_detail.amt_bet_ttl" is the total amount bet in the hand - this includes blinds, so if you want to ignore those you will need to use the fields mentioned above.

Postflop you also have "holdem_hand_player_detail.amt_f_bet_made", which is the amount of the "bet" on the flop (i.e. exactly the "bet", not any raises).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats sens

Postby raph156 » Wed Oct 05, 2011 9:11 am

Hi,
holdem_hand_player_detail.amt_bet_ttl
i want total amount bet in hand (bet+ raise if villain call or not).
Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby raph156 » Wed Oct 05, 2011 12:00 pm

and to have total amount bet flop between 11 and 25 ( if villain call or not), thise expression good?
sum( if[(holdem_hand_player_detail.amt_f_bet_made + holdem_hand_player_detail.amt_f_raise_made) BETWEEN (11* holdem_limit.amt_bb) AND (25 * holdem_limit.amt_bb) , 1, 0])
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby kraada » Wed Oct 05, 2011 12:20 pm

That will work or you could use holdem_hand_player_detail.amt_bet_f - that is the total amount of money you bet on the flop in any form.
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 0 guests