after investing >=25BB eventually folding %

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

after investing >=25BB eventually folding %

Postby helaco » Sat Sep 15, 2012 8:16 am

hi,

I'd like to know if, and how its possible to make a stat like that ^
or is there already something like that? ( i'd like to know on the turn/river if i should lure villain in, or know: ah he invested 30bb and he wont ever fold his hand now)
tnx in advance
helaco
 
Posts: 12
Joined: Tue May 27, 2008 4:38 am

Re: after investing >=25BB eventually folding %

Postby WhiteRider » Sat Sep 15, 2012 4:16 pm

You will need a pair of columns like this:

actions =
sum( if[holdem_hand_player_detail.amt_bet_ttl / holdem_limit.amt_bb > 25 AND NOT holdem_hand_player_statistics.flg_showdown AND NOT holdem_hand_player_statistics.flg_won_hand, 1, 0 ] )

opportunities =
sum( if[holdem_hand_player_detail.amt_bet_ttl > 25, 1, 0 ] )

For how to build a stat from expressions like these check out the Tutorial: Custom Reports and Statistics.
Here "actions" counts the number of times the player bet more than 25 BB, didn't go to showdown and didn't win the hand (therefore folded at some point), and "opportunities" counts the number of times they bet more than 25 BB.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 7 guests