fold to donk bet barrel stat

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 donk bet barrel stat

Postby xnnhep » Wed Feb 23, 2011 5:21 am

hi,

sorry if this is a dumb/obvious question; i'm new to this and trying to learn how to create conditional stats.

i'd like to create a custom stat that calculates how often a player:

raises preflop
is lead into on the flop and calls
folds to a turn barrel from the donkbettor

is it as simple as just going:

cnt_f_donk_def_opp_action_call and (cnt_t_bet_def_action_fold / cnt_t_bet_def_opp) * 100
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to donk bet barrel stat

Postby WhiteRider » Wed Feb 23, 2011 5:45 am

No - you will need to build new columns to build this stat.

The best way will be to make a new version of the "Call F Donk Bet" stat and add in the extra criteria.

The "actions" column cnt_f_face_donk_call is defined as:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%', 1, 0] )

To include a check for folding to a bet on the turn we can use:
holdem_hand_player_detail.amt_t_bet_facing > 0 AND lookup_actions_t.action = 'F'
(the player faced a bet and their first action was to fold.)

If you want to make sure that the bettor was the same player on the flop and turn you can use:
holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos

This makes the final actions column:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%' AND holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos AND holdem_hand_player_detail.amt_t_bet_facing > 0 AND lookup_actions_t.action = 'F', 1, 0] )

The opportunities column is very similar, just missing the check for folding on the turn:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%' AND holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos AND holdem_hand_player_detail.amt_t_bet_facing > 0, 1, 0] )

You can then build a stat to divide the former by the latter and multiply by 100 (as in most existing stats) to get the percentage.

See the Tutorial: Custom Reports and Statistics for how to build a stat from these expressions.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: fold to donk bet barrel stat

Postby xnnhep » Sat Feb 26, 2011 3:24 am

wow. thanks so much for taking the time to explain this in detail.
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to donk bet barrel stat

Postby WhiteRider » Sat Feb 26, 2011 5:41 am

You're welcome.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: fold to donk bet barrel stat

Postby xnnhep » Sat Feb 26, 2011 11:52 pm

quick followup question:

can you confirm that the above stat will include both 3bet and single-raised pots?
if so, would adding the following to both the action and opportunity count columns make the stat only calculate for single-raised pots:

and not(holdem_hand_player_statistics.flg_p_3bet)
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to donk bet barrel stat

Postby WhiteRider » Sun Feb 27, 2011 6:03 am

Yes, that stat will include 3-bet and single-raised pots - any hand where the player was the the last preflop raiser.
Your addition is good, but you might want to include a check to ignore 4-bets too.

and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet)

Note: 4bets in PT3 include all 4-bets and higher.
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