cbet and 4bet ip/oop

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

cbet and 4bet ip/oop

Postby ratsch » Thu Oct 14, 2010 3:45 pm

Hi,

Do there exist or is it possible to create stats for cbetting and 4betting in and out of position? I found one custom stat in the repository that used in and out of position expressions, but when I tried to modify it it didn't work. The stats were raise cbet ip and raise cbet oop. The ip one read (cnt_f_cbet_IP_def_action_raise / cnt_f_cbet_IP_def_opp) * 100

So I tried to adapt it for cbetting and 4betting as follows:

4bet pre oop:
(cnt_p_4bet_OOP / cnt_p_4bet_OOP_def_opp) * 100

cbet oop
(cnt_f_cbet_OOP / cnt_f_cbet_OOP_def_opp) * 100

But PT said expression was invalid. I don't know anything about making stats, this is my first attempt. Can anyone help?
ratsch
 
Posts: 8
Joined: Thu Aug 19, 2010 11:39 pm

Re: cbet and 4bet ip/oop

Postby kraada » Thu Oct 14, 2010 4:10 pm

The details referred to in the Value Expression boxes in the Stats tab refer to columns created on the Columns tab - if those columns don't exist, then they will not validate. You would likely need to create those as I don't think they're created for any other statistic as far as I'm aware.

Please take a look at the Tutorial: Using Custom Statistics and Reports for more on how to create custom statistics.
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