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
by andy2001 » Wed Apr 13, 2011 10:56 am
I'm trying to make a a stat show raises preflop that are open raises or vs limpers. I have
(cnt_p_raise_limpers+cnt_p_raise_first_in)/(cnt_p_open_opp+cnt_p_facing_limpers)*100
But when I use it it can't access opportunities on the hud.
-
andy2001
-
- Posts: 44
- Joined: Wed Apr 29, 2009 7:37 pm
by kraada » Wed Apr 13, 2011 12:35 pm
That looks like it should work fine to me - have you tried updating the cache?
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by andy2001 » Wed Apr 13, 2011 2:06 pm
Just tryed updating the cache and it's still the same. I thought the cache update was for when a new colum is added. This stat uses existing ones.
The numbers I'm getting look like they may be correct, just no samplesize given.
Or do I need to make two new colums for this stat.
-
andy2001
-
- Posts: 44
- Joined: Wed Apr 29, 2009 7:37 pm
by kraada » Wed Apr 13, 2011 2:16 pm
You shouldn't need new columns but I just thought I'd check.
Try restarting PT3 also and see if the stat comes up then.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by WhiteRider » Thu Apr 14, 2011 4:27 am
To see times/opportunities in the HUD the Value Expression needs to be in a specific format:
(a / b) * 100
Note exactly where the spaces are.
I think that it should work correctly when using +, but I'm not absolutely sure. Try an expression like this:
((cnt_p_raise_limpers+cnt_p_raise_first_in) / (cnt_p_open_opp+cnt_p_facing_limpers)) * 100
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests