stats appear after x number of hands

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

stats appear after x number of hands

Postby eszibit » Mon Jan 04, 2010 1:40 pm

Hi ,great software but i would like to know if there is a way to make some stats appear after a specific number of hands. Let's say i make Vpip appear after 20 hands , but preflop 3bet to appear after 100hands,because i multitable and sometimes i use some stats that are not accurate and i make mistakes.
If i have to adjust from the "configure stats" window please be specific,any help would be deeply appreciated,thanks.
eszibit
 
Posts: 8
Joined: Mon Jan 04, 2010 1:27 pm

Re: stats appear after x number of hands

Postby kraada » Mon Jan 04, 2010 2:04 pm

You can configure this sort of thing to an extent - you can replace the actual stat's text with different text under situations that match what you specify.

I'll walk you through how to do one, from there it should be easy to figure out.

Let's change VP$IP to only show a value if a player has 10 hands, otherwise it will show an X.

Click Configure --> Configure Statistics, choose the Holdem Cash Player Statistics section, and go to the Statistics tab. Scroll down to VP$IP and click on it then click the Dup button. Rename your statistic to something else (you can't edit the default stats, but you can create ones that are nearly identical), say VP$IP-X. Go to the Format tab. In the format expression tab change /%.2f to:
if (cnt_hands < 10, 'X', format('{1}',format_number( ((cnt_vpip / cnt_hands) * 100),0,false,false)))

Save the stat and you should be able to begin using it immediately. Here's how it works, it says if a player has less than 10 hands (cnt_hands < 10), then display 'X', otherwise, display the number that is equivalent to VP$IP (with no decimal places).

You can then adapt this format expression for other statistics fairly easily (look on the Definition tab's Value Expression to see how each statistic is calculated).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: stats appear after x number of hands

Postby eszibit » Mon Jan 04, 2010 3:18 pm

it works very nice,thanks a lot!
eszibit
 
Posts: 8
Joined: Mon Jan 04, 2010 1:27 pm

Re: stats appear after x number of hands

Postby kraada » Mon Jan 04, 2010 3:31 pm

You're welcome :)
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 4 guests