Check stats

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

Check stats

Postby icollude » Sat Sep 12, 2009 6:05 pm

I dont see any std stats on PT3 for:

Check/fold %
Check/Call %
across each street

Does anyone have the files?
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Check stats

Postby WhiteRider » Sun Sep 13, 2009 4:54 am

You will need to build custom stats for these.
For instance to count the number of times a player check/folds the flop you would use this column expression:
cnt_f_checkfold =
sum( if[ lookup_actions_f.action = 'XF', 1, 0 ] )

The 'f' means actions on the flop, and 'XF' means check then fold (exactly).
To count check/calls you need to look for 'XC%' - this is because after you check/call you may have the opportunity to make further actions. The % will count any one or more actions.

What you include in the expression for the 'opportunities' column depends on what you want to count as an opportunity - do you want to count all times you have the opportunity to check, or times you actually check? (The second I assume)
Anyway, have a look at the Custom Statistics and Reports FAQ and try to build your stats - if you need further help please post back and tell us where you are up to.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check stats

Postby icollude » Sun Sep 13, 2009 4:05 pm

I am sorry, im a dumb ass with making own stats. If someone could make the two files for me and attach them I would be really greatful.

I tried the line on the reply but it said it wasnt valid.
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Check stats

Postby icollude » Sun Sep 13, 2009 4:26 pm

and i want to count actual checks not opportunities
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Check stats

Postby WhiteRider » Sun Sep 13, 2009 4:35 pm

icollude wrote:and i want to count actual checks not opportunities

Yes, but I guess you will want to know the percentage of times a player check/folds, not the absolute number?
Someone check/folding 100 times doesn't mean anything unless you know how many times they had the opportunity to check/fold.

So you need to decide what counts as an opportunity to check/fold. Is this after they check, or when they have the opportunity to check?

e.g. If someone checks the flop 5 times and of those hands 2 times they face a bet and then once they fold - would you want to see 50% (folded 1 time out of 2 when they had the chance to fold) or 20% (folded 1 time out of the 5 they checked)?
I'd expect the first - the second is too dependent on how often they face bets.

Or you might even want to know how often then check/folded when they had the opportunity to check?
e.g. if they saw the flop 10 times when no-one bet before the action got to them so they had the opportunity to check or bet.
If they bet 5, then the other 5 checks follow the above example, that would show you 10% (1/10).

What would you expect/want to see?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check stats

Postby icollude » Sun Sep 13, 2009 4:52 pm

All of a sudden it gets a whole lot more complicated than it would first seem. Cheers for the help though, good work.

I just want to see the % of times someone checks (when they have opp to do so) on the flop and then folds after facing a bet. Similarly with the check/call stat.
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Check stats

Postby WhiteRider » Mon Sep 14, 2009 4:17 am

I'm still not entirely clear exactly which situation you want to count as opportunities - I understand the actions you want to count, it's just the opportunities which isn't clear. I'll build your stats later when I have some time, though.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check stats

Postby WhiteRider » Mon Sep 14, 2009 9:42 am

The flop versions of your stats are attached.

You will need to download the file and extract the stat files from the .zip (right click > Extract) before importing them to the Configure > Configure Statistics window via the Statistics tab.

To build the stats for the other streets you can just duplicate these and change the f (for flop) to t (for turn) and r (river) in the appropriate places.
See the Custom Statistics and Reports FAQ for more information on working with custom stats.
Attachments
Check Flop stats.zip
(1.06 KiB) Downloaded 97 times
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check stats

Postby icollude » Mon Sep 14, 2009 12:37 pm

Spot on kind sir!

I pitty the fools with Holdem Mgr
icollude
 
Posts: 33
Joined: Sun May 04, 2008 2:00 pm

Re: Check stats

Postby preparac » Fri Oct 23, 2009 2:30 pm

Your column

cnt_f_check_face_action =
sum( if[ lookup_actions_f.action LIKE 'X_%', 1, 0 ] )

is exactly the same as

cnt_f_check_raise_opp =
sum(if[tourney_holdem_hand_player_statistics.flg_f_check AND (tourney_holdem_hand_player_statistics.cnt_f_raise > 0 OR tourney_holdem_hand_player_statistics.cnt_f_call > 0 OR tourney_holdem_hand_player_statistics.flg_f_fold), 1, 0])

??
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Next

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

Who is online

Users browsing this forum: No registered users and 3 guests

cron