$3 a piece (Stars transfer) for the follwing stats...

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

$3 a piece (Stars transfer) for the follwing stats...

Postby SeanJFraley » Fri May 01, 2009 4:56 pm

I need:

PFR for SB
PFR for BB

These two need to be percentage, not opportunity.
SeanJFraley
 
Posts: 11
Joined: Thu Feb 21, 2008 5:07 pm

Re: $3 a piece (Stars transfer) for the follwing stats...

Postby kraada » Fri May 01, 2009 5:45 pm

Click Configure --> Configure Statistics. Click on Holdem Cash Player Statistics, go to the columns tab.

Create new columns:
cnt_pfr_sb with definition sum(if[holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.position = 9, 1, 0])
cnt_hands_sb with definition sum(if[holdem_hand_player_statistics.position = 9, 1, 0])
cnt_pfr_bb with definition sum(if[holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.position = 8, 1, 0])
cnt_hands_bb with definition sum(if[holdem_hand_player_statistics.position = 8, 1, 0])

Then go to the Stats tab, create a new stat:

PFR SB

with value espression:

(cnt_pfr_sb / cnt_hands_sb) * 100

On the format tab, call it PFR SB, expression /%.2f for value and summary, give it the categories you think most appropriate and save.

Duplicate it, change the columns for BB.

For all of these, you can put in whatever description you'd like; it's up to you. Once you've built the stats, rebuild your cache if you want to use them in the HUD but then you'll be all set.
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 4 guests