Is there a stack size in BB stat for cash games?

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

Is there a stack size in BB stat for cash games?

Postby Jayman8667 » Sun Nov 14, 2010 4:37 pm

I was able to find a stat for stack size in BB but it only shows up as a tournament stat, how can I get this stat for cash tables?
Jayman8667
 
Posts: 12
Joined: Wed Aug 18, 2010 8:21 pm

Re: Is there a stack size in BB stat for cash games?

Postby WhiteRider » Sun Nov 14, 2010 5:27 pm

The easiest way will be to [url=How To: Convert a Statistic to another Section]convert the tournament version to the cash section[/url].

Alternatively see the live stats tutorial for how to build it yourself.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Is there a stack size in BB stat for cash games?

Postby Jayman8667 » Sun Nov 14, 2010 6:32 pm

I read this:

Custom Stat Example

As an example, this is how I built a "Stack in BB" stat in the Holdem Cash Player Statistics section.

To calculate stack in BB we need to divide the stack size by the size of the big blind so first I built a Variable to hold each of those values.
In the custom stats window select the Holdem Cash Player Statistics section and go to the Variables tab.
(These Variables already exist in the tournament sections as they are used in the M stat.)

Click New and give the variable a name, let's start with "var_live_amt_bb".
Enter the Expression: live_table_stat( 'amt_bb' )
Add a Description too: "The BB amount in the previous hand at this table".

Add the second Variable in the same way: "var_live_amt_stack" with Expression: live_player_stat( str_player_name, 'amt_stack' ) and Description "The player's stack at the end of the previous hand".

Now that we have both the Variables that we need we can build the stat.
Go to the Statistics tab and click New.

Give your stat a Name, such as "Stack in BB", and a Description.
Enter the Value Expression using the new Variables: var_live_amt_stack / var_live_amt_bb

Although these stats won't work in reports (only the HUD) it is always a good idea to fill in the Format tab too.

Click Apply to save your stat.
If the HUD is running you will need to stop the Auto Import before your new stat is available to add to the HUD.


When I enter the information it says invalid. Below is a screenshot of the information entered to create the first variable. Did I type something wrong?
http://img690.imageshack.us/img690/8508/problemsd.jpg

Also, I have the Stack in BB stat in the tournament section (downloaded off the forum) and when I try to convert that to cash it says invalid as well.
Jayman8667
 
Posts: 12
Joined: Wed Aug 18, 2010 8:21 pm

Re: Is there a stack size in BB stat for cash games?

Postby Jayman8667 » Sun Nov 14, 2010 7:17 pm

Found the problem, I was using an old version of PT3, just updated to the newest version and it works.
No further helped needed.
thanks
Jayman8667
 
Posts: 12
Joined: Wed Aug 18, 2010 8:21 pm


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

Who is online

Users browsing this forum: Google [Bot] and 5 guests

cron