Fold to C-Bet after being 3-Bet 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

Re: Fold to C-Bet after being 3-Bet Stat?

Postby jscobie » Tue Jul 19, 2011 11:58 am

I meant

sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0 ])
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Fold to C-Bet after being 3-Bet Stat?

Postby kraada » Tue Jul 19, 2011 12:03 pm

Yes the latter would work.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to C-Bet after being 3-Bet Stat?

Postby jscobie » Tue Jul 19, 2011 12:04 pm

Sorry, another question. Do I just change the action='C' to action='F' or action='R' for the fold and raise stats?

I appreciate this help immensely
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Fold to C-Bet after being 3-Bet Stat?

Postby kraada » Tue Jul 19, 2011 12:20 pm

Yep :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to C-Bet after being 3-Bet Stat?

Postby wangtangkiki » Fri Jul 22, 2011 2:40 am

Is there anyway I could get a copy of this stat that I can import? I tried to use the code but it said inavlid expression.
wangtangkiki
 
Posts: 133
Joined: Mon Feb 28, 2011 11:01 pm

Re: Fold to C-Bet after being 3-Bet Stat?

Postby kraada » Fri Jul 22, 2011 8:11 am

Try getting rid of the hard return (making it all one line) and validating again - these expressions validate for me.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to C-Bet after being 3-Bet Stat?

Postby WhiteRider » Sun Jul 24, 2011 11:23 am

I lost my connection while looking at this on Friday - I think there is an extra ( in the first expression. I'm not on my normal computer just now and can't check this out, but try this expression:

sum(if[ holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 10 guests

cron