Flop/Turn/River 3bet Calculation seems weird?

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

Flop/Turn/River 3bet Calculation seems weird?

Postby maxp1981 » Thu Mar 06, 2008 2:36 pm

So, PT3 calculates a flop/turn/river 3-bet percentage like this:

SELECT (sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_raise)) FROM holdem_hand_player_statistics WHERE (holdem_hand_player_statistics.id_player = 558)

It then divides 3bet/raise...

Doens't that say how often a players flopraise was a 3-bet instead of saying how often he 3-bet when he had the opportunity to do so ??

If not so, for what are the 3-bet opportunitiy-fields ?
maxp1981
 
Posts: 9
Joined: Thu Feb 28, 2008 11:54 am

Re: Flop/Turn/River 3bet Calculation seems weird?

Postby Josh » Thu Mar 06, 2008 3:31 pm

Actually, the stat definitions are wrong. Thanks for bringing this to my attention. I'll get it fixed for the next release.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm

Re: Flop/Turn/River 3bet Calculation seems weird?

Postby maxp1981 » Thu Mar 06, 2008 4:19 pm

And I already thought I was too dumb to understand it :mrgreen:
maxp1981
 
Posts: 9
Joined: Thu Feb 28, 2008 11:54 am


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

Who is online

Users browsing this forum: No registered users and 39 guests