Fold to Cbet in 3bet Pot OOP and IP

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 Cbet in 3bet Pot OOP and IP

Saw a solution at build-in stats:

cnt_f_cbet_def_action_fold_out_of_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)='X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

cnt_f_cbet_def_action_fold_in_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)<>'X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

There was no denumerator so I took cnt_f_cbet_def_opp and made it to:
cnt_f_cbet_def_opp_out_of_pos
sum(if[holdem_hand_player_statistics.flg_f_cbet_def_opp AND substring(lookup_actions_f.action from 1 for 1)<>'X' , 1, 0])

1. Will this be correct?

2. Do u think I should use these expression 4 the original topic (3bet stats) also? So not use PFA < posi and better use the <> term?

3. please answer my numbered questions, this will save much time, tu
js2002

Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to Cbet in 3bet Pot OOP and IP

It doesn't work for dealt heads up hands because SB = 9 and BB = 8 and in this one case SB is in position on BB. That's why I added the check for absolute position - if you're in absolute position you're always in relative position, so the entire problem vanishes.

(1) This should also work. This works because if you check and then face a cbet, you must be out of position.

(2) Either one should work just fine - it's a matter of preference. It's like writing 2 + 2 vs 2 * 2 vs 2 ^ 2. They all give you the same result

Moderator

Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to Cbet in 3bet Pot OOP and IP

tu

wow all outcomes are 4, yummi

U invented 2+2 ! nh sir!

thread can be closed all clear now!
js2002

Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to Cbet in 3bet Pot OOP and IP

Hi
I need to find the statistic " Fold to Cbet in 3bet pot"

Could someone help me to find this stat?

Thank you a lot
825213

Posts: 1
Joined: Fri Aug 24, 2012 7:37 am

Re: Fold to Cbet in 3bet Pot OOP and IP

write a mail at chefsache@homegames.eu I will sent it as reply. (cash or tourney?)
js2002

Posts: 1494
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Previous