begginer question

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

begginer question

Postby SakisLam » Fri Oct 30, 2009 7:08 pm

Im trying to create a statistic that will show me the times villain has bet more than half of the pot on flop (and similar statistics like these)

The problem is that i can't find any variable of bet amount so that I will create a stat like this: bet_amount_on_flop / pot_on_flop > 0.5 ..
SakisLam
 
Posts: 22
Joined: Wed Feb 27, 2008 3:13 pm

Re: begginer question

Postby WhiteRider » Sat Oct 31, 2009 5:26 am

The database field you want is:
holdem_hand_player_detail.val_f_bet_made_pct
..which is the size of the bet as a percentage of the pot size.
There are other similar fields in the database too. Look for amt_f_bet_made (in the same table) etc for absolute amounts bet or raised.

The Database Schema documents the database fields.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 1 guest