Fold to river probe bet

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

Fold to river probe bet

Postby getthatmoney » Wed Apr 13, 2011 9:35 pm

Hi, there is a stat 'Probe Bet River' and 'Probe bet turn'.

How can I make the stat 'Fold to river probe bet' and 'Fold to turn probe bet'?

Thanks.
getthatmoney
 
Posts: 4
Joined: Fri Dec 12, 2008 12:00 am

Re: Fold to river probe bet

Postby WhiteRider » Thu Apr 14, 2011 4:48 am

I think these columns should work correctly, although I haven't tested them thoroughly:

cnt_r_probe_def_action_fold =
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp and lookup_actions_t.action = 'X' and holdem_hand_player_detail.amt_r_bet_facing > 0 and lookup_actions_r.action = 'F', 1, 0])

This says that the player had an opportunity to c-bet the turn (meaning that they c-bet the flop) but only checked, faced a bet on the river and folded. If the only river action is to fold then they didn't check, meaning that they are in position.

cnt_r_probe_def_opp =
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp and lookup_actions_t.action = 'X' and holdem_hand_player_detail.amt_r_bet_facing > 0 and NOT holdem_hand_player_statistics.flg_r_check, 1, 0])

Then you can create a new statistic "Fold to R Probe" with Value Expression:
(cnt_r_probe_def_action_fold / cnt_r_probe_def_opp) * 100

See the Tutorial: Custom Reports and Statistics for more information on building a stat from expressions like these.
The turn version would work the same way but exchanging turn fields (with _t_) for flop (_f_), and river for turn.
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 0 guests