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 NKL300 » Tue Sep 14, 2010 6:54 pm
Hi There,
I would like to figure out how often people bet the flop full pot or less then full pot and I also want a stat that tells me if they bet less then pot on the flop how often then check fold on the turn.
I am looking in the schema i can find the amt_bet_f so that needs to be smaller then the total pot preflop but cant seem to find how to define that.
Push in the right direction would be appreciated.
Thank you!
-
NKL300
-
- Posts: 8
- Joined: Sat Sep 04, 2010 12:33 pm
by kraada » Wed Sep 15, 2010 8:57 am
Use instead omaha_hand_player_detail.val_f_bet_made_pct - if that's 100 or more, he bet more than the pot as it was to him.
-
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 0 guests