Customized Table-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

Customized Table-Stats

Postby euneva » Wed Oct 24, 2012 8:52 am

I want a HUD table stat which is outcome of some arithmetical operations between stats of various player at the table in the hand.

Example:

MyCustomStat = PlayerInSB_FoldToLPSteal * PlayerInBB_FoldToLPSteal

Is this possible somehow?
It could belong in Table-Stats group or in Hero stats or wherever, but just displayed on the table for each particular hand

Thanks in advance!
euneva
 
Posts: 33
Joined: Thu May 15, 2008 5:41 pm

Re: Customized Table-Stats

Postby WhiteRider » Wed Oct 24, 2012 11:35 am

No, that kind of stat isn't possible - stats are only calculated for each individual player.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Customized Table-Stats

Postby euneva » Thu Oct 25, 2012 5:54 am

what about table stats where i can choose "table averages" ?
isn't that where i can put individual stats (eg: vpip, ...) to see table average values?
i thought that if table average values are possible, also other arithmetical operations can be made?
euneva
 
Posts: 33
Joined: Thu May 15, 2008 5:41 pm

Re: Customized Table-Stats

Postby WhiteRider » Thu Oct 25, 2012 8:14 am

A table average group displays the average value of a stat for all players at the table - it doesn't have any knowledge of the positions of the individual players, and just does a straight average.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Customized Table-Stats

Postby euneva » Thu Oct 25, 2012 12:28 pm

yes, but PT4 does have knowledge of the positions of the individual players and all them individual stats.

MyCustomStat = PlayerInSB_FoldToLPSteal * PlayerInBB_FoldToLPSteal
would show % of both blinds fold to a lp steal

when i'm in lp and considering a steal, of course i can do the above multiplying myself (live during play) in my head, but would be very useful to have this already calculated on my hud

(and no, i'm not trying to program a bot..)
euneva
 
Posts: 33
Joined: Thu May 15, 2008 5:41 pm

Re: Customized Table-Stats

Postby WhiteRider » Thu Oct 25, 2012 4:28 pm

This isn't possible.
Stats are displayed before the start of the hand, and we don't know which positions the players are going to be in in the next hand (yes, we could guess based on the previous hand, but if a player sat out or another one joined that could completely mess up the order. There is no mechanism to retrieve stats for two specific players at the same time and do calculations on them.
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