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

Postby js2002 » Sat Apr 02, 2011 9:22 am

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: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

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

Postby kraada » Sun Apr 03, 2011 8:43 am

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

(3) Questions answered with numbers per your request ;)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

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

Postby js2002 » Sun Apr 03, 2011 8:58 am

tu

wow all outcomes are 4, yummi ;)

U invented 2+2 ! nh sir!

thread can be closed all clear now!
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

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

Postby 825213 » Mon May 26, 2014 12:39 am

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

Postby js2002 » Mon May 26, 2014 1:21 am

write a mail at chefsache@homegames.eu I will sent it as reply. (cash or tourney?)
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Previous

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

Who is online

Users browsing this forum: No registered users and 12 guests

cron