Where is the Times/Opportunities info kept?

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

Where is the Times/Opportunities info kept?

Postby jludman » Tue Sep 01, 2009 5:36 pm

I made a new stat, 3bet from BB vs steal. I was able to add this to the popup menu for preflop stats, however, I can't seem to figure out where the Times/Opportunities thing is configured. I can set the boolean to "True", but I don't know how to tell it where to get the 2 #s, so it just reports "0% ()"
jludman
 
Posts: 24
Joined: Mon Jun 09, 2008 4:46 pm

Re: Where is the Times/Opportunities info kept?

Postby kraada » Tue Sep 01, 2009 5:45 pm

In your custom statistic make sure you set the formatting of the value expression on the stats tab to be: (x / y ) * 100 where x and y are the two columns you are using to calculate the percentage in question. Then times and opportunities will be shown properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Where is the Times/Opportunities info kept?

Postby jludman » Wed Sep 02, 2009 9:45 am

Thanks, got it working. Seemed to require a restart of PT after I fixed the formatting, but it's all good now :).

Now, however, I am thinking that I would like to break out the data from the "Blinds" column in the HUD into SB and BB. I assume the "Position" selection box just filter to only the hands in those positions, and thus automatically makes the statistics correct for that. I duped the "Preflop Statistics" group, but I can't figure out how to remove "Blinds" and add "SB" and "BB".

Also, is it possible to run a HUD without actually sitting at a table, so that I can test my new stats?
jludman
 
Posts: 24
Joined: Mon Jun 09, 2008 4:46 pm

Re: Where is the Times/Opportunities info kept?

Postby WhiteRider » Wed Sep 02, 2009 11:04 am

The current positions ranges only show the blinds as totals over small and big blinds.
If you want to see them individually you will need to build position-specific custom stats.
Kraada explains how to do this in his How To: Advanced HUD Configuration.
Custom Statistics and Reports FAQ.

You can use the HUD on the Replayer to test the stats and group configuration, then when you go to a "real" table at your site all you will need to do is position the groups.
Whether you can see the HUD on observed tables depends on whether the site writes hand histories for observed tables (not many do).
Other than PokerStars and Full Tilt (see the Memory Grabber option in the Auto Import tab) the HUD will only appear when you are auto importing hands.
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