Average stack size including Hero's stack

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 stack size including Hero's stack

Postby hmcp22 » Tue Mar 18, 2014 11:06 pm

Hi,

I read in the forums that the Live Avg Stack stat is the average stack of the table not including hero. Is it possible to have the average stack size at the table to include hero's stack for tournaments? I want to be able to display the Q=stack/av stack for each player at the table.

Thanks
hmcp22
 
Posts: 6
Joined: Mon Nov 10, 2008 1:05 pm

Re: Average stack size including Hero's stack

Postby kraada » Wed Mar 19, 2014 7:47 am

Is this for PT3 or PT4?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Average stack size including Hero's stack

Postby hmcp22 » Wed Mar 19, 2014 10:50 am

This is for PT4
hmcp22
 
Posts: 6
Joined: Mon Nov 10, 2008 1:05 pm

Re: Average stack size including Hero's stack

Postby kraada » Wed Mar 19, 2014 1:53 pm

I think you can do this by adding live_cash_table.amt_avg_stack * live_cash_table.cnt_players and live_cash_player.amt_stack and dividing by live_cash_table.cnt_players + 1 as long as you put it in a hero only table group. But I'm not 100% certain as I haven't had a chance to test it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Average stack size including Hero's stack

Postby hmcp22 » Wed Mar 19, 2014 5:57 pm

Thanks for the response, but I can't seem to make this work
hmcp22
 
Posts: 6
Joined: Mon Nov 10, 2008 1:05 pm

Re: Average stack size including Hero's stack

Postby kraada » Thu Mar 20, 2014 8:12 am

I'll make a note to give it some more testing then and get back to you.
kraada
Moderator
 
Posts: 54431
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 7 guests

cron
highfalutin