Custom stat 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

Custom stat help

Postby icollude » Sun May 10, 2009 3:39 pm

Custom stat help required. I am new to PT3 but want to do the following:
1) Have a stat that summarises the cummulative 'fold to check raise' rate over all streets - std currently shows post flop per street only
2) Have the above stats put into my HUD

Any help would be greatly appreciated


M
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Custom stat help

Postby WhiteRider » Sun May 10, 2009 6:00 pm

If you duplicate one of the existing stats you can add the other streets in.
Which particular stats are you looking at?

Custom Stats guide
Custom Statistics and Reports FAQ.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom stat help

Postby icollude » Mon May 11, 2009 5:29 pm

that would be fine if i knew how
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Custom stat help

Postby kraada » Mon May 11, 2009 5:49 pm

Configure --> Configure Statistics, click on the Holdem Cash Player Statistics section go to the Stats tab.

Click on Fold to Flop Check/Raise and click the Dup button on the right.

Change the name to "Fold to Check/Raise" and change the value expression to:
((cnt_f_face_xr_fold + cnt_t_face_xr_fold + cnt_r_face_xr_fold) / (cnt_f_face_xr + cnt_t_face_xr + cnt_r_face_xr) * 100

On the Format tab change the Title to Fold to C/R, remove the Street - Flop category, save the stat and click apply.

You'll need to update your cache before you can use this stat in your HUD but once you do you will be able to use it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stat help

Postby icollude » Wed May 13, 2009 12:21 pm

Appreciated
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests