Unopened PFR

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

Unopened PFR

Postby bdadavies » Fri Apr 02, 2010 11:09 am

Hello

I dont really know how to make custom stats.

What I'm after, if someone has or could do is the PFR when the pot is unopened for CO BTN and SB (basically the steal % for these positions).

I have looked in the repository and the PFR for these positions exist, all I need in addition is that the PFR is in an unopend pot (a steal!)

This is for FR if that makes any difference.

Hopefully someone can help.

Best wishes
bdadavies
 
Posts: 110
Joined: Tue Jun 03, 2008 9:09 am

Re: Unopened PFR

Postby kraada » Fri Apr 02, 2010 11:47 am

To create ATS(CO), you'll need two columns:

cnt_steal_opp_co: sum(if[holdem_hand_player_statistics.flg_steal_opp and holdem_hand_player_statistics.position = 1, 1, 0])

cnt_steal_att_co: sum(if[holdem_hand_player_statistics.flg_steal_att and holdem_hand_player_statistics.position = 1, 1, 0])

Put the latter over the former and create the format tab as you desire and you'll be all set. To create a button version, change the position from 1 to 0. To make a SB version, you would use position = 9.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unopened PFR

Postby WhiteRider » Fri Apr 02, 2010 12:37 pm

For a walkthrough of how to utilize these columns see the Tutorial - Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unopened PFR

Postby bdadavies » Fri Apr 02, 2010 1:16 pm

Thanks guys.

I had a quick flick through the guide and then just dived in and basically used the existing attempt to steal stat as a template. It was easier than I had thought.

Currently the cache is updating so I'll find out in a bit if it has all worked.

One question springs to mind.

I notice that the SB would have the value of 9

Would this mean that in a 6-max game this stat wouldn't work, or is the number 9 "hardwired in" for the SB and in 6-max the numbers are 1-9 but something lime 3-6 are missing?

(I hope that makes sense!)
bdadavies
 
Posts: 110
Joined: Tue Jun 03, 2008 9:09 am

Re: Unopened PFR

Postby WhiteRider » Fri Apr 02, 2010 3:25 pm

The SB is always position 9 (and BB is 8) regardless of table size, for just this kind of reason.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests