stats by position

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 by position

Postby zedjr » Mon Sep 01, 2008 7:34 am

Made an earlier post about making stats and am doing research and hope i get some direction and help for this. AM trying to learn to make a custom hud like in hold em manager for positional stats. So first i need to learn to make stats i guess. AM curious on how to make stats by position so i can therefore insert into a pop up hud. I am assuming it is quite easy but am not sure on how to do this. THanks for any help. zedjr
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: stats by position

Postby zedjr » Mon Sep 01, 2008 8:58 am

I forgot to add i am trying to make positional stats by basic positions like early position, midle position and late position. So i would need to combine stats from different positions.
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: stats by position

Postby WhiteRider » Mon Sep 01, 2008 9:50 am

There is a forum section for Custom Stats, so I'll move this there.

There are already some by-position stats in the Repository.
Is it these that you've downloaded and are trying to install (re: your other post)?

Have a look at how they are constructed and you will be able to duplicate and adapt them by adding checks for more than one position in each.

Custom Statistics and Reports FAQ.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stats by position

Postby zedjr » Mon Sep 01, 2008 10:46 am

i have looked at that. is there any sort of idiots guide to creating a stat. A complete wakthru or something as when it starts off saying stuff like this i have little clue to what it means. Also which stat exactly in the repository is a position stat. ALso how can i add positions to create one stat for lets say early position stat.
format_bool( value, format )
format_bool( flg_p_ccall, 'check' )
..shows a boolean (true/false) value as a checkbox.

format_number( value, decimal places, commas, color )
format_number( value, 1, false, false )
..shows a number (value) with 1 decimal place, no commas, not colored (green for positive, red for negative).
'value' will normally be something like:
(cnt_p_ccall / cnt_p_ccall_opp) * 100
..in which case this will be a % formatted to 1 decimal place.

This is more commonly done by entering this in the Format Expression field:
%/.2f
..which formats the value of the statistic to 2 decimal places
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: stats by position

Postby WhiteRider » Mon Sep 01, 2008 11:02 am

This walkthrough (linked in the FAQ) takes you through it step by step.
viewtopic.php?f=18&t=10638#p49504

Page 1 of the Statistics section of the Repository has a stat called "6max VPIP from button", which is a position stat.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stats by position

Postby zedjr » Mon Sep 01, 2008 11:50 am

i cnat say that is the best tutorial for creating stats as it just skips and sais click on stat tab and do somethign there. Was very confused but am trying to understand this better. Need a dummies guide for this as i dont think that one qualifies as a dummies guide.
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: stats by position

Postby WhiteRider » Mon Sep 01, 2008 11:53 am

OK, please tell us where you are stuck.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: stats by position

Postby zedjr » Mon Sep 01, 2008 12:00 pm

ok i will try to understand the one from 6 max button. OK i imported stat. I see under stat tab is where i see entrie sfor this. DOnt understadn then what is use of column tab. ANyways am looking at stat "6max pfr from button". First question is. IS this an actual usable stat at this point as i see no column entries. am jsut a little confused by columns tab and stat tab. Ok next on this stat where is the part saying this is for 6 max. How can i make this a stat for nine handed full ring. Also how can i make this a stat for utg. also what would i change and how if u know to make this a stat for button and co seat. this is the value expression "(PFR_Button_Numerator / VPIP_button_denominator) * 100". ALso under format i see an entry "/%.2f". what does this mean? In categories i see assigned actions and street preflop but i will get to this later as one thing at a time i guess. WIll try to read some more on your site about this and sorry if i seem so stupid about this.
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: stats by position

Postby WhiteRider » Mon Sep 01, 2008 12:48 pm

zedjr wrote:OK i imported stat. I see under stat tab is where i see entrie sfor this. DOnt understadn then what is use of column tab.

I'll come back to this in a bit..
ANyways am looking at stat "6max pfr from button". First question is. IS this an actual usable stat at this point as i see no column entries.

Yes, once you have imported that stat, you can add it to reports which show player statistics (like the Known Starting Hands Summary) or to the HUD (you will have to restart the HUD to get it to show up).

am jsut a little confused by columns tab and stat tab.

The Statistics tab is where you define the actual statistics that will be used in the HUD or reports.
Statistics are built up from Columns. So the value expression you mention
(PFR_Button_Numerator / VPIP_button_denominator) * 100
..is built from 2 columns "PFR_Button_Numerator" and "VPIP_button_denominator".
If you click the Columns tab you will find these columns in blue in the list (it's sorted alphabetically).
The Columns are built up from database fields, so are a kind-of halfway step between the DB and your Stats.
e.g. PFR_Button_Numerator =
SUM(if[holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.position = 0,1,0])
This counts how often the player raises (cnt_p_raise>0, so they raised at least once preflop) and they were on the button (position=0, 0 seats off the button).

holdem_hand_player_statistics.cnt_p_raise
and
holdem_hand_player_statistics.position
are fields in the database - you can explore the database fields by clicking 'insert' on the Columns tab.

Ok next on this stat where is the part saying this is for 6 max. How can i make this a stat for nine handed full ring.

There is nothing here that defines it as 6-max, I think the creator just defined them for positions possible on a 6 seat table.

Also how can i make this a stat for utg. also what would i change and how if u know to make this a stat for button and co seat. this is the value expression "(PFR_Button_Numerator / VPIP_button_denominator) * 100".

To change this stat to be for different positions you would need to edit the columns as shown above - e.g. the cutoff is position=1, hijack position=2. UTG depends on how many players there are at the table, but you can keep increasing the position count like this for each seat.
Note: BB is always position 8 and SB is position 9.

ALso under format i see an entry "/%.2f". what does this mean?

This is explained in the FAQ.
It means 2 decimal places.

In categories i see assigned actions and street preflop but i will get to this later as one thing at a time i guess. WIll try to read some more on your site about this and sorry if i seem so stupid about this.

When you add your stats to reports or the HUD you can narrow your selection down to categories - this is where they are defined.
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