new vpip 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

new vpip stat

Postby hugblue » Thu Sep 29, 2011 11:30 pm

hi all ...

just a single question..

if i want to make a new stat in pokertracker. like..

i have an vpip value.
if vpip is <45 then (new stat) is equal -1
if vpip is between 45 and 55 then (new stat) is equal 0
if vpip is >55 then (new stat) is equal 1

i know ofcause that i can color code all numbers. but thats not what i want.

so how do i make a new stat that can give vpip either -1 , 0 , 1

one way i thought of was to use an if..else statement. but this one can only give out 2 values. false or true. and i need 3 values.

thz..
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: new vpip stat

Postby WhiteRider » Fri Sep 30, 2011 3:20 am

You can "nest" IF statements so that you can get a 3-way output.
Probably the easiest way is to make a copy of the existing VP$IP stat and change the Format Expression to display 1, 0 or -1 based on the Value Expression, like this:

if( (cnt_vpip / cnt_vp_opp) < 0.54, -1, if( (cnt_vpip / cnt_vp_opp) > 0.55, 1, 0 ) )

Check out the Tutorial: Custom Reports and Statistics for more information on format expressions and other aspects of working with custom stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new vpip stat

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

thz alot whiterider ..

is checking it out right now.

//hugblue
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests