fold to turn donkbet, single raised pot

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 turn donkbet, single raised pot

Postby xnnhep » Fri Mar 04, 2011 2:45 am

created a custom stat to determine how often someone folds to turn donkbets in single raised pots but it doesn't seem to be working.

shouldn't it just be:

(cnt_t_donk_def_action_fold_sr / cnt_t_donk_def_opp_sr) * 100

cnt_t_donk_def_action_fold_sr =
sum(if[holdem_hand_player_statistics.enum_t_donk_action='F' and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet), 1, 0])

cnt_t_donk_def_opp_sr
sum(if[holdem_hand_player_statistics.flg_t_donk_def_opp and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet), 1, 0])

as an aside, is there any way for me to determine if it's the numerator or denominator of a stat that isn't working?
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to turn donkbet, single raised pot

Postby xnnhep » Fri Mar 04, 2011 2:48 am

nevermind, fixed it. the above seems to work.

however, the followup stat (fold to river bet after calling turn donk, single-raised pot) doesn't seem to be working and i've probably screwed it up someplace:

cnt_t_donk_def_action_call_fold_river / cnt_t_donk_def_action_call_fold_river_opp

cnt_t_donk_def_action_call_fold_river =
sum( if[holdem_hand_player_statistics.enum_t_donk_action='C'
and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet)
AND holdem_hand_player_detail.val_t_bet_aggressor_pos = holdem_hand_player_detail.val_r_bet_aggressor_pos
AND holdem_hand_player_detail.amt_r_bet_facing > 0 AND lookup_actions_r.action = 'F', 1, 0])

cnt_t_donk_def_action_call_fold_river_opp =
sum( if[holdem_hand_player_statistics.enum_t_donk_action='C'
and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet)
AND holdem_hand_player_detail.val_t_bet_aggressor_pos = holdem_hand_player_detail.val_r_bet_aggressor_pos
AND holdem_hand_player_detail.amt_r_bet_facing > 0, 1, 0])
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to turn donkbet, single raised pot

Postby WhiteRider » Fri Mar 04, 2011 4:52 am

That looks OK at first glance - what sort of results are you getting that suggest that it is wrong?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: fold to turn donkbet, single raised pot

Postby xnnhep » Sat Mar 05, 2011 4:58 pm

for some reason my hud wasn't updating the stat (was just getting N/A 0/0), a restart fixed it and it seems to work now.
xnnhep
 
Posts: 15
Joined: Wed Feb 23, 2011 2:27 am

Re: fold to turn donkbet, single raised pot

Postby WhiteRider » Sat Mar 05, 2011 5:44 pm

Thanks for the update - I'm glad to hear that.
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 11 guests