-Live stats- short stack in table.(SNG)

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

-Live stats- short stack in table.(SNG)

Postby majonyjony » Fri Sep 30, 2011 5:55 am

It is possible to know with "live stats"
if you have a very short stacked opponent relative to the mean on the table?

if ((var_live_amt_stack / var_live_avg_stack)>=2.5 OR ("one player short stack" ) *, '| BLA BLA BLA |', .............. ,'-')

*((stack player 1? / var_live_avg_stack) OR (stack player 2 / var_live_avg_stack) OR (stack player 3 / var_live_avg_stack))<0.3

Ty!
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: -Live stats- short stack in table.(SNG)

Postby WhiteRider » Fri Sep 30, 2011 6:28 am

It isn't possible to generate that as a single number on the table but you could build a stat to show for each player, to show their stack relative to the average. You would then need to look round the table to see the smallest value, so I'm not sure that would be better than having their stack in BB...
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: -Live stats- short stack in table.(SNG)

Postby majonyjony » Fri Sep 30, 2011 7:18 am

If the average stack is ((stack_p1 + stck_p2 +...) / number of players)

I just need to know if (stack_p2 / average stack) <0.3

I have all "ingredients" but dont know the name of "stack_p2".
majonyjony
 
Posts: 116
Joined: Wed Oct 08, 2008 4:01 am

Re: -Live stats- short stack in table.(SNG)

Postby WhiteRider » Fri Sep 30, 2011 8:28 am

You can't get "stack-p2" - you can only get the stack for the active player. i.e. The stats for each player know what their own stack is, but not anyone else's.
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 6 guests