ATS from BU and CO, help!

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

ATS from BU and CO, help!

Postby suitedeule » Tue Sep 02, 2008 2:51 pm

Hi,
so i got the ATS from SB stat from the repository
http://www.pokertracker.com/repository/statistics.php?f[sort]=hits&f[order]=desc&f[page]=3
i wanted to ask if u guys could assist me in creating the same stat for COand BU


thats how ATS from SB is build (is the statistic working correct anyway? ;) )

Statistics window in Configure Stats:

Name: Att To Steal From SB
Description: Attempts To Steal From SB
Value Expression:
(cnt_steal_att_sb / cnt_steal_opp_sb) * 100

Columns window:
für cnt_steal_att_sb:
Expression:
SUM(if[holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.position = 9,1,0])
Description:
Number of times player raised in SB when folded around.

cnt_steal_opp_sb:
SUM(if[holdem_hand_player_statistics.flg_steal_opp AND holdem_hand_player_statistics.position = 9,1,0])

Number of times it was folded to player in SB (i.e. an opportunity to steal-raise).

both summary type Sum

so basicly id just have to replace the position numbers to get the stat to work for other positions? if so, which are the correct numbers?
thx in advance
eule
suitedeule
 
Posts: 14
Joined: Thu Jun 05, 2008 5:34 pm

Re: ATS from BU and CO, help!

Postby WhiteRider » Wed Sep 03, 2008 8:51 am

The position is the number of seats off the button, so Button position = 0, Cutoff position = 1, etc.
EXCEPT that BB is always 8 and SB is always 9, regardless of how many players are at the table.

So in the expressions you quote you need to change the 9 to 0 for button and 1 for cutoff.
The easiest way to do this is to duplicate (click "Dup") the stat and then rename and edit your new copy.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 2 guests