displaying hud stats from a "group" of blind

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

displaying hud stats from a "group" of blind

Postby luckycolm » Thu Sep 08, 2011 7:03 pm

is there any way i could get my hud stats displayed so that it represents a group of blinds rather than one specific blind, for example

group 1: 10/20, 15/30, 25/50, 50/100
group 2: 75/150, 100/200, 150/300, 200/400
group 3: 300/600, 400/800, 600/1000, 800/1600
group 4: 1000/2000 to infinety
luckycolm
 
Posts: 26
Joined: Tue Oct 28, 2008 4:05 pm

Re: displaying hud stats from a "group" of blind

Postby WhiteRider » Fri Sep 09, 2011 3:57 am

You would need to build a custom version of each stat for each group - is that something you'd like to do? If so, give us an example of a stat you're interested in and we'll help you build it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: displaying hud stats from a "group" of blind

Postby luckycolm » Fri Sep 09, 2011 8:47 am

yes the two main ones that i would be interested in would be VPIP and PFR set out in groups like this,

group 1: 10/20, 15/30, 25/50,
group 2: 50/100, 75/150, 100/200, 150/300, 200/400
group 3: 300/600, 400/800, 600/1000, 800/1600
group 4: 1000/2000 to infinety

also will the hud display be able to change automatically as the blinds move from one group to another?

there are a few more but if i had the instructions i would be able to do them my self.

has PT4 anything similiar to this on it?
luckycolm
 
Posts: 26
Joined: Tue Oct 28, 2008 4:05 pm

Re: displaying hud stats from a "group" of blind

Postby kraada » Fri Sep 09, 2011 9:08 am

PT4 doesn't yet have functionality like this but we aren't done developing for it yet, either.

For each stat you want to build, you'll need to build custom columns for each group.

So for example for VP$IP you need cnt_vpip_g1 and cnt_hands_g1:

cnt_vpip_g1: sum(if[tourney_holdem_hand_player_statistics.flg_vpip and tourney_holdem_blinds.amt_bb <= 50, 1, 0])
cnt_hands_g1:sum(if[ tourney_holdem_blinds.amt_bb <= 50, 1, 0])

for group 2:

cnt_vpip_g2: sum(if[tourney_holdem_hand_player_statistics.flg_vpip and tourney_holdem_blinds.amt_bb >= 50 and tourney_holdem_blinds.amt_bb <= 400, 1, 0])
cnt_hands_g2:sum(if[ tourney_holdem_blinds.amt_bb >= 50 and tourney_holdem_blinds.amt_bb <= 400, 1, 0])

And so on . . .
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: displaying hud stats from a "group" of blind

Postby luckycolm » Fri Sep 09, 2011 12:27 pm

ok because iam a lazy so and so rather than build the column manually, i just created a new column called cnt_vpip_g1, and then i just typed the sum as you gave it to me into the expression box :o
is this ok?
here is a pic to show you what i have done
[img][IMG]http://img691.imageshack.us/img691/9130/pt3fz.jpg[/img]

Uploaded with ImageShack.us[/img]


i presume i must now create another called cnt_hands_g1 and type the sum as you have given it into the expression box, and that is my first group created for blinds up to 50(bb).
luckycolm
 
Posts: 26
Joined: Tue Oct 28, 2008 4:05 pm

Re: displaying hud stats from a "group" of blind

Postby kraada » Fri Sep 09, 2011 1:03 pm

Those are the columns, then you use them to build the stats - see this tutorial for a detailed explanation of the mechanism.
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 0 guests