Average chips of first hand of HU

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

Average chips of first hand of HU

Postby Eric Poker » Sat Mar 07, 2009 5:42 am

I'm playing 1 table SnG and I would like to know how much chips I have on average the first hand when we are only 2 players list
This is possible (in pt3 or query) ?
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: Average chips of first hand of HU

Postby kraada » Sat Mar 07, 2009 10:51 am

It's almost certainly possible with the right database query, though doing it in PT3 will be highly difficult (if not impossible). The problem is figuring out which is your very first hand of heads up play; I'm not sure what's the best way of doing that off the top of my head. I'll try and find some time to think about the query though and if I come up with anything I will post it in this thread.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Average chips of first hand of HU

Postby Eric Poker » Sat Mar 07, 2009 4:42 pm

I think #id hand is incremanting on everysite. That mean the lowest #id hand how meet the requierement (2 handeds) of a tournament is the good one
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: Average chips of first hand of HU

Postby kraada » Sun Mar 08, 2009 9:31 am

Yes, but my SQL query writing experience is limited. I could write it in pseudocode for you, but I don't know how to put the PostgreSQL query together, and I'm pretty sure that even if you had the query getting it into a PT3 report is nigh on impossible at this point in time.
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