All in stats

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

All in stats

Postby stuart_gall » Sun May 08, 2011 2:43 pm

Hello,
Is it possible to create a stat for the percentage of times a player is all-in for each street ?

TIA
Stuart
stuart_gall
 
Posts: 61
Joined: Mon Mar 22, 2010 7:46 am

Re: All in stats

Postby WhiteRider » Sun May 08, 2011 3:38 pm

Yes - have a look at this thread.
_p_ is for preflop, you can also use _f_ for flop, _t_ for turn and _r_ for river.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: All in stats

Postby stuart_gall » Mon May 09, 2011 4:00 pm

OK - that basically worked.

all in pre I made cnt_p_shove / cnt_hands * 100
But
all in flop I made cnt_f_shove / cnt_f_saw * 100 which is more usefull to me.
and so on cnt_t_shove / cnt_t_saw * 100

On the hud I add the statistics, and I set "show times / opportunites" true.
This works for the preflop stat, but I just get things like "3% ()" on flop,turn and river.

Any Ideas ?
stuart_gall
 
Posts: 61
Joined: Mon Mar 22, 2010 7:46 am

Re: All in stats

Postby kraada » Mon May 09, 2011 4:24 pm

It needs to be formatted exactly like this:
(cnt_f_shove / cnt_f_saw) * 100

Then it will work.
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 1 guest