Fold Flop Continuation Bet Percentage in 3Bet 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 Flop Continuation Bet Percentage in 3Bet Pot

Postby piocet » Tue Jun 21, 2011 6:17 pm

Here is the hand in question.

PokerStars - $1 NL (9 max) - Holdem - 8 players
Hand converted by PokerTracker 3: http://www.pokertracker.com

CO: $100.00
Hero (BTN): $115.00
SB: $80.50
BB: $52.60
UTG: $212.45
UTG+1: $80.05
MP: $157.55
MP+1: $45.15

SB posts SB $0.50, BB posts BB $1.00

Pre Flop: ($1.50) Hero has Jc Jh

UTG raises to $3.00, fold, fold, fold, fold, Hero calls $3.00, SB raises to $10.00, fold, UTG calls $7.00, Hero calls $7.00

Flop: ($31.00, 3 players) 2s 3d Ad
SB bets $16.00, UTG calls $16.00, fold

Turn: ($63.00, 2 players) 2c
SB bets $20.00, UTG raises to $146.00, SB calls $34.50 and is all-in

River: ($172.00, 2 players) Qd

SB shows Qh As (Two Pair, Aces and Queens) (PreFlop 26%, Flop 14%, Turn 10%)
UTG shows Ac Kh (Two Pair, Aces and Twos) (PreFlop 74%, Flop 86%, Turn 90%)
SB wins $169.00

So, it is a 3Bet Pot and I folded to flop continuation bet. However, the stat as in the subject is shown as 0/1. I cannot figure out what went wrong. Any suggestions?
piocet
 
Posts: 10
Joined: Tue Apr 29, 2008 4:06 am

Re: Fold Flop Continuation Bet Percentage in 3Bet Pot

Postby WhiteRider » Wed Jun 22, 2011 3:30 am

That stat only counts hands where you made a raise preflop, which you didn't in this case.
If you want to build a new version of the stat which includes all 3-bet pots (including those like this where you didn't raise) then see the walkthrough example in the Tutorial: Custom Reports and Statistics. You will need to remove "holdem_hand_player_statistics.cnt_p_raise > 0" part of the expression in the columns.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold Flop Continuation Bet Percentage in 3Bet Pot

Postby piocet » Wed Jun 22, 2011 4:41 am

I see. I didn't notice that cnt_p_3bet_f_cbet_def_action_fold is calculated in a different way from cnt_p_3bet_f_cbet_def_action_call and cnt_p_3bet_f_cbet_def_action_raise. Thanks for your reply.
piocet
 
Posts: 10
Joined: Tue Apr 29, 2008 4:06 am

Re: Fold Flop Continuation Bet Percentage in 3Bet Pot

Postby allyourbaser » Wed Jun 29, 2011 9:50 am

Hi,

I am trying to alter the stat 'Fold % When Call Preflop' for someone eventually folding in a hand where they called ANY raise p to show only when they were the initial raiser and I 3bet and they eventually folded during the hand. I have tried several combos after reading the walk through but I keep getting the 'Value expression is NOT valid' (cnt_fold_when_p_3bet_def_action_call / cnt_p_3bet_def_action_call_hands) * 100

Can you please tell me what else I need to change?

Also, I would ultimately like to show this same stat to reflect when it's only the two of us after the flop. Thanks.
allyourbaser
 
Posts: 10
Joined: Wed Jul 02, 2008 11:21 am

Re: Fold Flop Continuation Bet Percentage in 3Bet Pot

Postby kraada » Wed Jun 29, 2011 11:34 am

You need to refer to a column that exists - take a look at the Tutorial: Using Custom Statistics and Reports for a more detailed explanation - once you have the proper columns existing, everything will work.
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 0 guests