VP/PFR based on number of players at the table

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

VP/PFR based on number of players at the table

Postby Th0rgal » Thu Jul 30, 2009 3:39 pm

Hi Guys,

Is this possible at all? if so how do I start building a stat like that?

Cheers,
Thor
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: VP/PFR based on number of players at the table

Postby WhiteRider » Thu Jul 30, 2009 5:11 pm

If you want to see this information in the HUD the simplest way is to use Player Ranges - see the Tutorial: Configuring HUD Options.

If you want to build a stat for use in the main application reports you will need the database field:
holdem_hand_summary.cnt_players

It depends on exactly how and where you want to use this information as to exactly how you would build the statistic so if you need more help please tell me how you want to use/display the info.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: VP/PFR based on number of players at the table

Postby Th0rgal » Thu Jul 30, 2009 6:11 pm

What I am looking for is very similar to the advance hud "M" based stats. Basically I like to see in the HUD
VP (8-9players)
VP (7-6players)
VP (4-5players)
VP (1-3players)

and the same for PFR

This is specifically for SNG'S
You think thats possible?
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: VP/PFR based on number of players at the table

Postby WhiteRider » Fri Jul 31, 2009 4:27 am

OK, right - so you don't just want to see one value in the HUD based on the current number (range) of players? That's what Player Ranges would give you.

If you want to show a list of stats for the number of players then you'll need to create a custom stat for each value.

Duplicate the normal VP$IP stat and the columns it uses and add a check for the number of players into the expression in the columns.
e.g.
VP$IP = (cnt_vpip / cnt_hands) * 100
..so you need to duplicate the columns cnt_vpip and cnt_hands.
So:
cnt_vpip = sum(if[holdem_hand_player_statistics.flg_vpip, 1, 0])
..becomes..
cnt_vpip_8_9 = sum(if[holdem_hand_summary.cnt_players=>8 AND holdem_hand_summary.cnt_players<=9 AND holdem_hand_player_statistics.flg_vpip, 1, 0])

Repeat this for cnt_hands too, then duplicate VP$IP to:
VP$IP 8-9 = (cnt_vpip_8_9 / cnt_hands_8_9) * 100
..and repeat for each of your new stats.

Custom Statistics and Reports FAQ.
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 0 guests