Stats by STT stage

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

Stats by STT stage

Postby Grohl_ » Sun Feb 15, 2009 11:12 am

Hi all,
I'm hoping to construct a report that can show VPIP/PFR/AF by stage of a Single Table Tournament?

Player/ Hands/ Stage /VPIP/ PFR / AF
Jimmy/ 653 Early 16.14 12.5 0.4
Jimmy/ 460 Middle 25 16 2
Jimmy/ 240 Late 30 25 4.5

Like that... I've made something similar which has 'Blinds' instead of Stage, but how/where can I set up 'Stages'?
Grohl_
 
Posts: 12
Joined: Fri Jul 18, 2008 9:06 pm

Re: Stats by STT stage

Postby WhiteRider » Sun Feb 15, 2009 12:10 pm

That can be quite tricky, but it depends how you want to define your 'stages'.
The easiest way would be to do it by blind level.
You could create a column using a big IF statement; something like this:

if [ tourney_holdem_blinds.amt_bb <= 200, 'Early', if [tourney_holdem_blinds.amt_bb <= 1000, 'Middle', 'Late' ] ]

You would want that column to be 'Group By' so that it would group all hands for the same 'stage' together.
This kind of thing isn't straightforward, but have a play with it and see what you can come up with. If you get stuck please post back and tell us where you are up to.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats by STT stage

Postby Raisebanyai » Thu Feb 26, 2009 1:28 pm

It works for me.

But, is there any way to put it in the HUD? That it would look like something like this:

[Notes]/Playername/2494
7.91/4.66/1.59/1138 {early stage: VPIP/PFR/AF/Hands}
13.97/12.62/1.80/1260 {middle stage}
37.50/30.21/N/A/96 {late stage}
Raisebanyai
 
Posts: 10
Joined: Fri May 09, 2008 5:53 am

Re: Stats by STT stage

Postby kraada » Thu Feb 26, 2009 3:54 pm

Any stats in the Tournament Holdem Player Statistics sections should be usable in the HUD. You can add them to your HUD just like any other stat. For more on how to configure your HUD, please see the How To: HUD Configuration.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats by STT stage

Postby Raisebanyai » Fri Feb 27, 2009 5:58 am

kraada wrote:Any stats in the Tournament Holdem Player Statistics sections should be usable in the HUD. You can add them to your HUD just like any other stat. For more on how to configure your HUD, please see the How To: HUD Configuration.


It should be, but it's not, at least for me.

I can see "stages" in the available stats at the report tab holdem tournament player statistics section (it works also as intended), but it does not appeare amongst the stats of the tournament configuratin section.

What have I done wrong?
Raisebanyai
 
Posts: 10
Joined: Fri May 09, 2008 5:53 am

Re: Stats by STT stage

Postby kraada » Fri Feb 27, 2009 11:14 am

Without seeing the actual stat I can't be sure. Could you please export, then zip up and attach your stat to a ticket using this link and we'll look into what could be causing the problem for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats by STT stage

Postby Raisebanyai » Mon Mar 02, 2009 8:14 am

Nevermind, I figured it out.
It works now.

Thank you anyway
Raisebanyai
 
Posts: 10
Joined: Fri May 09, 2008 5:53 am

Re: Stats by STT stage

Postby kraada » Mon Mar 02, 2009 11:43 am

Out of curiosity: what was it?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats by STT stage

Postby Grohl_ » Wed Mar 18, 2009 8:40 pm

I was looking at the HUD Options and saw the 'Stats from Tournament Blind Level Only' and thought, now that I can make a report showing stats by stage, if only it could be displayed on the HUD.

Is that what you've managed to do?

I second your call to share your method!
Grohl_
 
Posts: 12
Joined: Fri Jul 18, 2008 9:06 pm

Re: Stats by STT stage

Postby peyrolas » Thu Mar 19, 2009 7:57 am

this sound really very interesting..however i am not a stats crack..can.t ever get my reports how i want and i do not have the time to invest more...

so also my call - please share your info and/or upload your report -thanks
peyrolas
 
Posts: 41
Joined: Sat Jan 10, 2009 6:38 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests