Villian StackSize In HUSNG - Tourney Hand Stat, Possible?

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

Villian StackSize In HUSNG - Tourney Hand Stat, Possible?

Postby gkeuler » Tue Apr 05, 2011 3:10 am

Now this isn't exactly what you think because for traditional (PS) HUSNG the stat (3000 - amt_chips) works just fine, but I mainly play the 4mans where in the 2nd round your chips double and situations can arise where there is no trick for knowing the villian's stacksize. (example- 2nd round, Past the 2nd blind level, Hero Chips < 1500)

Any way of creating a stat that directly accesses the HH and pulls the Villian's stacksize? Only way possible to solve this I think
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby WhiteRider » Tue Apr 05, 2011 3:35 am

There are "live stats" for this available for download from the "Get More" section. Search for "LIVE Stack in BB" - there is one for each game type, uploaded by me.

For more information on live stats see the Tutorial: Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby gkeuler » Tue Apr 05, 2011 5:12 am

WhiteRider wrote:There are "live stats" for this available for download from the "Get More" section. Search for "LIVE Stack in BB" - there is one for each game type, uploaded by me.

For more information on live stats see the Tutorial: Custom Reports and Statistics.



I'm actually looking for a Holdem Tournament Hand Stat to review the match after the fact in a Holdem Tournament Hand report.

PS- In the repository the "Live Stack In BB (Holdem Cash)" stat actually downloads the OCPS Live Stack Stat.
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby kraada » Tue Apr 05, 2011 9:13 am

Then you'd want to build the stat using a new column which reads:

tourney_holdem_hand_player_detail.amt_before

Create a stat which then just displays that value and add it to the report you want and it should work straight away - there's no need for updating caches when dealing with Hand statistics :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby gkeuler » Tue Apr 05, 2011 9:45 am

kraada wrote:Then you'd want to build the stat using a new column which reads:

tourney_holdem_hand_player_detail.amt_before

Create a stat which then just displays that value and add it to the report you want and it should work straight away - there's no need for updating caches when dealing with Hand statistics :)


Im looking for the Villains Stacksize in a tourney hand stat report... thats going to display my chip stack right?
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby kraada » Tue Apr 05, 2011 9:51 am

If you flip the report around to look at it from Villain's perspective you'll see his stack size.

Another option though - these are heads up SnGs, so the maximum stack size is an easy function - find the maximum number of chips, subtract your stack size from it and you'll get his stack size :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby gkeuler » Tue Apr 05, 2011 9:57 am

kraada wrote:If you flip the report around to look at it from Villain's perspective you'll see his stack size.

Another option though - these are heads up SnGs, so the maximum stack size is an easy function - find the maximum number of chips, subtract your stack size from it and you'll get his stack size :)


The issue arises in the 2nd round of a 4man tournament, 3000k Starting Each, past the first two rounds where the blind levels are no longer unique and when I have under 1500 chips..

1500-3000 chips and the effective stack column dosent match like it should so you know the villains stack
3000+ chips and you know the villains stack since you could never achieve that in the first round


0-1500 chips and there is no way of knowing the villains stack.
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby kraada » Tue Apr 05, 2011 10:17 am

I can't think of a good way to do that either, then - but still flipping the report around and looking from Villian's perspective will work (if being a bit tedious).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villian StackSize In HUSNG - Tourney Hand Stat, Possible

Postby WhiteRider » Tue Apr 05, 2011 10:39 am

gkeuler wrote:PS- In the repository the "Live Stack In BB (Holdem Cash)" stat actually downloads the OCPS Live Stack Stat.

Thanks - I've updated that, but it will need to be approved before the new stat appears.

You could use "tourney_holdem_hand_summary.amt_p_effective_stack" to display the size of the smaller stack, which is all you're actually playing for at heads up.
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