Custom statistics

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 statistics

Postby skelm » Sun Sep 21, 2008 12:44 pm

Hi guys,

I'm looking to get a few custom statistics made up - Happy to pay for them so feel free to e-mail me at michael at codingo dawt com dot au about this (Mods if this is against the forums terms I apologize- I did hunt around to see if this was the case but couldn't find a definitive answer).

The statistics I'm after are for HU only and would be the following:

VP$IP in SB
VP$IP in BB
PFR in SB
PFR in BB
3bet SB
3bet BB
Avg Stack (BB)

Thanks guys! Hopefully somebody out there can bash these together quite easily.

Regards,

Michael
skelm
 
Posts: 5
Joined: Wed Feb 06, 2008 1:16 am

Re: Custom statistics

Postby WhiteRider » Sun Sep 21, 2008 1:02 pm

The by position VP and PFR are already in the Repository. They are listed as 6-max stats, but that's only because they are defined for the seats at a 6-max table.

The others are really easy to build too, if you import and take a look at the VP by position stats, then you can duplicate the 3-bet stat and add a check for position.
The Average stack one should be pretty straightforward too - the DB field you will need is:
holdem_hand_player_detail.amt_before

You'll get much more out of the Custom Stats if you learn to build them yourself..
Custom Statistics and Reports FAQ.
Let me know if you get stuck.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom statistics

Postby skelm » Sun Sep 21, 2008 1:21 pm

WhiteRider wrote:The by position VP and PFR are already in the Repository. They are listed as 6-max stats, but that's only because they are defined for the seats at a 6-max table.

The others are really easy to build too, if you import and take a look at the VP by position stats, then you can duplicate the 3-bet stat and add a check for position.
The Average stack one should be pretty straightforward too - the DB field you will need is:
holdem_hand_player_detail.amt_before

You'll get much more out of the Custom Stats if you learn to build them yourself..
Custom Statistics and Reports FAQ.
Let me know if you get stuck.


Further to my first post how would I go about designing a Avg Hands / Session statistic?
skelm
 
Posts: 5
Joined: Wed Feb 06, 2008 1:16 am

Re: Custom statistics

Postby skelm » Sun Sep 21, 2008 2:04 pm

After playing around with this for a while I think i'd much rather pay to have this done to save time - If anybody is interested please e-mail the address listed in my original post.
skelm
 
Posts: 5
Joined: Wed Feb 06, 2008 1:16 am

Re: Custom statistics

Postby WhiteRider » Sun Sep 21, 2008 4:42 pm

If you want average hands per session on the HUD, I don't think that's possible at the moment.
You could create it in the 'holdem cash sessions' section, but I don't think it's currently possible in the 'holdem cash player sessions' which is where you'd need to create it for it to be available on the HUD.
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