Single raise pre flop

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

Single raise pre flop

Postby 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

Re: Single raise pre flop

Postby 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

Re: Single raise pre flop

Postby 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

Re: Single raise pre flop

Postby 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

Re: Single raise pre flop

Postby 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]

Who is online

Users browsing this forum: No registered users and 0 guests