Report: Hand Strength

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

Report: Hand Strength

Postby Zito » Wed Dec 12, 2012 7:19 am

Looking for a way to display hand strength pre as percentile following certain actions.

Example
We filter for full stacks who've 4b from the blinds and wtsd, a column "Hand Strength %" lists all hands as percentiles (AA =.45% KK=.90% etc) the bottom displays the mean hand strength percentile of the population for this action.

New to custom reports; so If I'm way off, are there any feasible alternatives?
Zito
 
Posts: 122
Joined: Fri Sep 02, 2011 10:45 am

Re: Report: Hand Strength

Postby kraada » Wed Dec 12, 2012 9:50 am

You'd have to make a pretty long if statement in your stat in order to do this - you'd need to write out each one of them. It'd start with:
sum(if[holdem_hand_player_statistics.id_holecard = 1, .45, if[ holdem_hand_player_statistics.id_holecard = 2, x, if[ .....
and so on.

This post has the list of id_holecard values.

You'll want to make the column summary type Average also - then that will do the summary row the way you want it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report: Hand Strength

Postby Zito » Fri Dec 14, 2012 5:54 pm

Thanks Kraada,

Does this expression go in the "hand" + "column" tabs?, then I just write the values for the 169 starting, hands give it a name then I'm good?
Zito
 
Posts: 122
Joined: Fri Sep 02, 2011 10:45 am

Re: Report: Hand Strength

Postby kraada » Fri Dec 14, 2012 7:18 pm

If you want to use them on a report that groups things with more than one hand per row, you'll need to do them in Player columns.
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 1 guest