More precise effective stacksize filter(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

More precise effective stacksize filter(HU)

Postby JimmSlimm » Thu Sep 15, 2011 9:30 am

I would like filter hands with effective starting stack size more precise than the default values(which is 5-10, 10-15 etc), and be able to see a graph OR report of showdown and non-showdown bb/100.

I have no idea how to do it
JimmSlimm
 
Posts: 16
Joined: Tue Oct 14, 2008 5:32 pm

Re: More precise effective stacksize filter(HU)

Postby kraada » Thu Sep 15, 2011 10:52 am

You can filter custom reports using the blue Filters link to be more precise.

The value you want to use there is:

holdem_hand_summary.amt_p_effective_stack BETWEEN X and Y

Where X and Y are the values you want the starting stack size between. If you want it in big blinds divide the effective stack by holdem_limit.amt_bb.

If you want to see a report's value for only showdown or non showdown hands you can filter for Saw Showdown, and use the NOT Selected button to make it NOT(Saw Showdown) - the filtered results will give you the showdown and non-showdown results respectively.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: More precise effective stacksize filter(HU)

Postby JimmSlimm » Thu Sep 15, 2011 11:24 am

Thanks, works :)
JimmSlimm
 
Posts: 16
Joined: Tue Oct 14, 2008 5:32 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest