average pot size

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 pot size

Postby fritos » Fri Jun 26, 2009 11:09 am

I've asked this before and got told that it's planned but not yet available. So, if I want to build this stat on my own - how would I go about doing that?
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: average pot size

Postby kraada » Fri Jun 26, 2009 11:14 am

For the HUD this just isn't available right now, I'm afraid. It is still planned, but it won't be available until after Build 5 at the earliest.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: average pot size

Postby fritos » Fri Jun 26, 2009 12:05 pm

I don't want it for the HUD, I just want it as a general statistic.
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: average pot size

Postby kraada » Fri Jun 26, 2009 1:44 pm

In that case you should be able to build it using the holdem_hand_summary.amt_pot database field. Just add that value up, divide by how many hands and it will give you the average total pot for however many hands are in your database.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: average pot size

Postby fritos » Fri Jun 26, 2009 2:38 pm

Ok, how does this field work in LHE compared to NLHE? Since I play LHE, will I have to do some limit conversions or something to be able to compare potsizes across different limits?
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: average pot size

Postby kraada » Fri Jun 26, 2009 7:31 pm

amt_pot is the total size of the pot in dollars. If you wanted to normalize to big bets or big blinds you would need to divide amt_pot by the appropriate amount.
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