Is this Fold CO to BTN 3bet stat correct?

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

Is this Fold CO to BTN 3bet stat correct?

Postby jscobie » Sun Dec 11, 2011 5:03 pm

Is this right? I am not getting a proper sat by the looks of things. Just says 0% with no times or opportunities available

Fold CO to BTN 3bet =
(Fold_CO_to_Button_3_Bet / total_times_CO_faced_steal_3bet_from_button) * 100

Fold_CO_to_Button_3_Bet =
sum(if[holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=1 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos=0 AND holdem_hand_player_statistics.enum_p_3bet_action='F', 1, 0])

total_times_CO_faced_steal_3bet_from_button =
sum(if[holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=1 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos=0, 1, 0])
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Is this Fold CO to BTN 3bet stat correct?

Postby WhiteRider » Sun Dec 11, 2011 5:42 pm

I can't see anything wrong with those expressions at first glance, although this kind of stat cannot be built with full accuracy. There won't be many cases, but if one of the blinds calls, the cutoff reraises and the blind re-raises (regardless of the button's action) then the blind position will now be the "raise aggressor" position.
Are you sure you've seen that situation come up for the players you're looking at?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Is this Fold CO to BTN 3bet stat correct?

Postby jscobie » Mon Dec 12, 2011 2:59 pm

Thanks, its working, must of been sample size or something
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Is this Fold CO to BTN 3bet stat correct?

Postby Mr Tiger » Wed Feb 29, 2012 1:35 pm

jscobie wrote:Fold_CO_to_Button_3_Bet =
sum(if[holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position=1 AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_detail.val_p_raise_aggressor_pos=0 AND holdem_hand_player_statistics.enum_p_3bet_action='F', 1, 0])

It seems holdem_hand_player_statistics.flg_p_3bet_def_opp isn't mandatory here. Am I right?
Does holdem_hand_player_statistics.enum_p_3bet_action='F' mean that the player folds to any 3bet? (if he folds to 3bet, he faces it first of all)
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Is this Fold CO to BTN 3bet stat correct?

Postby kraada » Wed Feb 29, 2012 2:38 pm

You are correct about that yes. But it doesn't hurt anything by being there, either.
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 1 guest