Positionally aware stat

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

Positionally aware stat

Postby pat3392 » Wed Mar 23, 2011 9:36 am

I'm trying to come up with such a stat to colour code my VP$IP. I can't settle on one definition as I keep seeing flaws. Anyone want to offer some ideas?
pat3392
 
Posts: 142
Joined: Wed Jan 27, 2010 7:44 pm

Re: Positionally aware stat

Postby kraada » Wed Mar 23, 2011 10:18 am

I've tried to come up with things like this in the past but I've never found anything that I liked particularly well either. In the end I just look at several stats and decide for myself the tendencies of the player on the fly. If I can see his PFR increases as he gets in later position and his attempt to steal is considerably higher than his PFR then he's probably got enough tendencies to be more aggressive in later position to act on. But it's difficult to quantify that into a specific number.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Positionally aware stat

Postby pat3392 » Wed Mar 23, 2011 10:45 pm

I've found this custom stat:

sum(if[holdem_hand_player_statistics.flg_vpip and ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0) or

(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1) or

(holdem_hand_summary.cnt_players > 8 and holdem_hand_player_statistics.position = 2)), 1, 0])

The expression is confusing. What is it going to do when their's 5 players? There will be >2 and >4 players present, won't this result in a error? And how it says "or" instead of "and" is peculiar
pat3392
 
Posts: 142
Joined: Wed Jan 27, 2010 7:44 pm

Re: Positionally aware stat

Postby WhiteRider » Thu Mar 24, 2011 5:37 am

The column will count 1 for every hand where the condition is true. For it to be true for a hand the player need to have VP$IP AND any of the other conditions, which are:
There were more than two players and the player was on the button (position 0)
There were more than four players and the player was in the cut-off (position 1)
There were more than eight players and the player was in position 2

If ANY of those true and will be counted, so when there are five players it will be true if the player was in position 0 or position 1.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Positionally aware stat

Postby pat3392 » Thu Mar 24, 2011 8:37 pm

tyvm
pat3392
 
Posts: 142
Joined: Wed Jan 27, 2010 7:44 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests