custom stat from the repository

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

custom stat from the repository

Postby shrapnel60 » Mon Nov 02, 2009 9:35 am

would someone like to earn themselves a few fulltilt dollars by converting a cash custom stat to a tournament stat for me,ive had a couple of unsuccessful attempts following the tutorial ,the stat is whiteriders Preflop Limp % in the repository

Thanks
shrapnel60
 
Posts: 9
Joined: Tue Oct 14, 2008 7:44 am

Re: custom stat from the repository

Postby kraada » Mon Nov 02, 2009 9:39 am

What error are you getting when you try to convert it yourself?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: custom stat from the repository

Postby shrapnel60 » Mon Nov 02, 2009 9:40 am

its not a particular error im more getting lost
shrapnel60
 
Posts: 9
Joined: Tue Oct 14, 2008 7:44 am

Re: custom stat from the repository

Postby kraada » Mon Nov 02, 2009 9:43 am

Which step in the tutorial are you able to get to before getting lost? I'd be happy to help you work through the rest of it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: custom stat from the repository

Postby shrapnel60 » Mon Nov 02, 2009 9:50 am

collecting the info uptp step 4,then the column info throw me
shrapnel60
 
Posts: 9
Joined: Tue Oct 14, 2008 7:44 am

Re: custom stat from the repository

Postby kraada » Mon Nov 02, 2009 10:15 am

Okay, in Step 4 what we're doing is writing down basically all of the information about the stat that you can find. What the name is, what the value expression is. Just put it in any old document file and we're going to be referring to it later. The most important bit though is the Value Expression. That tells us really how the stat is calculated. In the example, the stat is calculated as (cnt_p_limp_fold / cnt_p_limp_faceraise) * 100

This is important because it tells us what columns we need to look at next (in step 5). Then we copy down the column information and then recreate all of this data in the Tournament area.
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 3 guests