3bet flop won shodown

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

3bet flop won shodown

Postby gman » Fri Oct 03, 2008 5:21 am

I'm trying to create a report that shows how often I won in a showdown when I 3bet the flop.

This did work with the raise expression:

Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])

Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand, 1, 0])

But this doesn't work:

Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_3bet > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0])


Code: Select all
sum(if[holdem_hand_player_statistics.cnt_f_3bet> 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand, 1, 0])


I want to do :
Code: Select all
(cnt_f_3bet_wtsd_won / cnt_f_3bet_wtsd) * 100

WHere am I falling down. Any help is appreciated. Thanks.
gman
 
Posts: 6
Joined: Fri Oct 03, 2008 4:59 am

Re: 3bet flop won shodown

Postby WhiteRider » Fri Oct 03, 2008 12:15 pm

holdem_hand_player_statistics.cnt_f_3bet doesn't exist - it is:
holdem_hand_player_statistics.flg_f_3bet
You can only 3bet once on the flop, so there is no need for a cnt_ (count) stat, it is just a flg_ (flag/boolean) stat.
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 2 guests