percentage of pot bet

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

percentage of pot bet

Postby zedjr » Sun Feb 15, 2009 8:03 am

How can i build a stat to show ercentage of pot bet for certain actions and correspond to that action tehy did like rfi or pf3bet. thanks
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: percentage of pot bet

Postby WhiteRider » Sun Feb 15, 2009 12:02 pm

There are a set of database fields like "holdem_hand_player_detail.val_f_bet_made_pct" which show the bet size as a percentage of the pot.

IF you want to find out how much you bet for a c-bet for instance you need to do something like:
if[holdem_hand_player_statistics.flg_f_cbet, holdem_hand_player_detail.val_f_bet_made_pct, 0]
(if the player c-bet, use the pot_bet%, otherwise use 0)

e.g. if you want to find out the average c-bet size, create a column to sum the above, and another to count c-bets, and divide one by the other.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests