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 VNix » Fri Jan 14, 2011 12:17 pm
Hello!
Please help me...this stats wrong or not ?:
Bet Flop:
((cnt_f_bet - cnt_f_cbet - cnt_f_donk - cnt_f_float) / (cnt_f_bet - cnt_f_cbet - cnt_f_donk - cnt_f_float + cnt_f_check)) * 100
Fold Flop:
((cnt_f_bet_def_action_fold - cnt_f_cbet_def_action_fold - cnt_f_donk_def_opp_action_fold - cnt_f_float_def_opp_action_fold ) / (cnt_f_bet_def_opp - cnt_f_cbet_def_opp - cnt_f_donk_def_opp - cnt_f_float_def_opp )) * 100
I need only Unraised Preflop (Limped Pots)...
-
VNix
-
- Posts: 11
- Joined: Thu Apr 15, 2010 2:49 pm
by kraada » Fri Jan 14, 2011 12:48 pm
That looks like it should work I think, but there may be some cases that I'm not thinking of off the top of my head. The safer way would be to build new columns specifically for limp pots - then you'd be certain you've got the proper situations counted.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 9 guests