creating combos on each street by ccpf...

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

creating combos on each street by ccpf...

Postby skolnieks » Fri Feb 17, 2012 6:02 pm

Combos on Flop by CCPF-

(cnt_p_ccall / cnt_p_ccall_opp) * 132600

Combos on Turn by CCPF -

((cnt_p_ccall / cnt_p_ccall_opp) * 132600) -
((cnt_p_ccall / cnt_p_ccall_opp) * 132600) *
((cnt_f_fold / cnt_f_saw) * 100)
/ 100

Combos on River by CCPF -

(((cnt_p_ccall / cnt_p_ccall_opp) * 132600) -
((cnt_p_ccall / cnt_p_ccall_opp) * 132600) *
((cnt_f_fold / cnt_f_saw) * 100)
/ 100) -
(((cnt_p_ccall / cnt_p_ccall_opp) * 132600) -
((cnt_p_ccall / cnt_p_ccall_opp) * 132600) *
((cnt_f_fold / cnt_f_saw) * 100)
/ 100) *
((cnt_t_fold / cnt_t_saw) * 100) /
100


theese expressions are valid but result seems wrong and ends with .xxxx
i used /%.2f format... ???
skolnieks
 
Posts: 69
Joined: Wed Aug 10, 2011 5:42 pm

Re: creating combos on each street by ccpf...

Postby kraada » Fri Feb 17, 2012 6:36 pm

I suspect the problem is that these numbers are getting too large for us to handle - I don't believe these starts are configured to handle numbers in the trillions.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: creating combos on each street by ccpf...

Postby skolnieks » Fri Feb 17, 2012 9:21 pm

i made changes... so...

Combos on Flop by CCPF -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) (results shows correct)

Combos on Turn by CCPF -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) * (cnt_f_fold / cnt_f_saw) (correct )


Combos on River by CCPF -
((cnt_p_ccall * 1326 / cnt_p_ccall_opp) -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) * (cnt_f_fold / cnt_f_saw)) -
(cnt_t_fold / cnt_t_saw)


for river result are the same like turn... but sholdnt be...
skolnieks
 
Posts: 69
Joined: Wed Aug 10, 2011 5:42 pm

Re: creating combos on each street by ccpf...

Postby WhiteRider » Sat Feb 18, 2012 6:19 am

(cnt_t_fold / cnt_t_saw) is always going to be less than 1, so may not make much difference to the value. Unless the player you're looking at folded every turn they saw then it much change the value a little, but if you're not displaying decimal places it may not be noticeable.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: creating combos on each street by ccpf...

Postby skolnieks » Sat Feb 18, 2012 8:27 am

then combos on river

((cnt_p_ccall * 1326 / cnt_p_ccall_opp) -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) * (cnt_f_fold / cnt_f_saw)) -

((cnt_p_ccall * 1326 / cnt_p_ccall_opp) -
(cnt_p_ccall * 1326 / cnt_p_ccall_opp) * (cnt_f_fold / cnt_f_saw)) *

(cnt_t_fold / cnt_t_saw)
skolnieks
 
Posts: 69
Joined: Wed Aug 10, 2011 5:42 pm


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

Who is online

Users browsing this forum: No registered users and 2 guests