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

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

Postby jscobie » Tue Jul 19, 2011 6:38 am

This might seem a bit basic but I cant seem to get a stat working for how often a opponent is folding to, calling, or raising a c-bet after they have called a 3-bet pre-flop.

Any help on how I can get this would be much appreciated.
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

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

Postby jscobie » Tue Jul 19, 2011 8:21 am

Sorry for being so vague. I think I have already solved my own problem. I didnt realise the columns tab was for total numbers and not %s.

Im guessing now i need to make a stat like: (cnt_p_3bet_f_cbet_def_action_call / cnt_p_3bet_f_cbet_def_opp) * 100

But this includes 4-bets or more.

If I make up a new column for just 3-bet pots, would it be; sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])

Would this column be the total number of times opponent called a c-bet in a 3-bet pot? All I have done is removed the 4-bet part
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 9:09 am

That would be the total number of times someone faced a 3-bet and called a c-bet. Since it doesn't say anything about 4bets, that may or may not happen.

One example that would fall under you column would be someone 3-bets, you 4-bet, they 5-bet, you call and they cbet. Admittedly that'd be a little rare.
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 9:24 am

You've confused me :?

Im just looking for a stat to compliment the existing 3-betting stats. Im trying to up my 3 betting frequency but want to know how often someone is going to call, fold or raise my c-bet after they call my 3-bet. Obviously, I have their 4-bet frequency and their FT3B stats already so Im just looking for stats that can help me decide the best course of action post-flop.

What do you think would be best for me?
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 9:36 am

Let me try to clarify:

jscobie wrote:If I make up a new column for just 3-bet pots, would it be; sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])


This column picks out all times when a player: (a) faced a 3-bet preflop and (b) called a cbet. Nothing else matters. He could have faced a 4bet or not - it's not specified. Anything unspecified can happy in any possible way. If you're happy with that - that's fine and you can use it. I was just trying to explain what the column you built actually does.
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 9:45 am

I get it now, thanks.

Im away to study the tutorial to get fully clued up on how im going to make these stats

I'll probably be back soon to ask more questions about it soon :lol:
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

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

Postby jscobie » Tue Jul 19, 2011 10:14 am

Sorry kraada, im not getting very far with this.

sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])

Can I change the OR that ive underlined to something else so that its only 3-bet pots? Or is there another way?
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 10:30 am

You can do:

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 ])

Now a player must have faced a 3-bet, not faced a 4-bet, and called a cbet.
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 11:18 am

So how about 4-betting. Only facing a 4-bet and not a 3-bet. So in essence, player made the 3-bet (so wasnt facing one), called the 4-bet, then called with JJ to a c-bet shove when the board came 852r. Or something like that. I know this wont happen too often.

Would that be

sum(if[ (holdem_hand_player_statistics.flg_p_4bet_def_opp AND NOT (holdem_hand_player_statistics.flg_p_3bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])

or maybe just

sum(if[ (holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

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

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

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_opp, 1 , 0 ])

Is this correct for an opportunities count column?
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Next

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

Who is online

Users browsing this forum: No registered users and 20 guests

cron