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 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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 2 guests