Bet turn after check-check on flop

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

Bet turn after check-check on flop

Postby Double_Trouble » Thu Dec 15, 2011 8:27 am

Hi there, basically I'm looking for a stat in a HU game, when I'm in position and villain checks flop, I check behind, and villain bets on the turn. Any ideas how to make this stat? Thanks!
Double_Trouble
 
Posts: 5
Joined: Mon Sep 19, 2011 2:26 pm

Re: Bet turn after check-check on flop

Postby kraada » Thu Dec 15, 2011 9:21 am

I can help you build that but first I have a question for you: is any preflop action okay or do you want a specific preflop setup?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Bet turn after check-check on flop

Postby Double_Trouble » Thu Dec 15, 2011 9:51 am

Well it'd be great if I had this for i raise, he calls, and for I raise, he reraises :) Although, it's not a must.
Double_Trouble
 
Posts: 5
Joined: Mon Sep 19, 2011 2:26 pm

Re: Bet turn after check-check on flop

Postby kraada » Thu Dec 15, 2011 10:30 am

Well for the first case (you raise he calls) the stat you want is built in and called Probe Turn. A bet is a probe bet if it's a bet out of position into a player who could have cbet the prior street but didn't. You raised preflop he called, you could have cbet the flop but didn't, so his turn bet is a probe.

For the latter you would need to build the stat as a custom stat. You can do that using these columns:

cnt_t_bet_after_x_3bp: sum(if[holdem_hand_player_statistics.flg_steal_def_opp and holdem_hand_player_statistics.flg_p_3bet and lookup_actions_f.action ='X' and holdem_hand_player_statistics.flg_t_bet, 1, 0])


cnt_t_open_opp_after_x_3bp: sum(if[holdem_hand_player_statistics.flg_steal_def_opp and holdem_hand_player_statistics.flg_p_3bet and lookup_actions_f.action ='X' and holdem_hand_player_detail.flg_t_open_opp, 1, 0])

Put the former over the latter and multiply by 100 to get your stat.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Bet turn after check-check on flop

Postby Double_Trouble » Fri Dec 16, 2011 7:42 am

Thanks, will surely use the probe bet.
Not really sure how to make the latter work :/ Never made custom stats...
Double_Trouble
 
Posts: 5
Joined: Mon Sep 19, 2011 2:26 pm

Re: Bet turn after check-check on flop

Postby kraada » Fri Dec 16, 2011 9:45 am

We have a tutorial on how to set it up here - I promise it's not as scary as it looks (or sounds).
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