Check Raise Flop CBet

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

Check Raise Flop CBet

Postby Messaa » Fri Mar 13, 2009 8:27 am

I am trying to create a "Check Raise Flop CBet" stat by the following

(cnt_f_check_raise_cbet / cnt_f_check_raise_cbet_opp) * 100

cnt_f_check_raise_cbet:

sum(if[holdem_hand_player_statistics.flg_f_check_raise AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

cnt_f_check_raise_cbet_opp:
sum(if[holdem_hand_player_statistics.flg_f_check AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND(holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold), 1, 0])

Format expr:

if (cnt_f_check_raise_cbet_opp < 10, 'X', format('{1} ({2}/{3})',format_number((cnt_f_check_raise_cbet / cnt_f_check_raise_cbet_opp) * 100,0,false,false), cnt_f_check_raise_cbet,cnt_f_check_raise_cbet_opp))


However, when I add this to my HUD, stats for all other players but hero disappears. When I remove the stat from the HUD, everything works. This tells me that the stat is buggy, what is the problem?
Messaa
 
Posts: 36
Joined: Tue May 27, 2008 1:55 am

Re: Check Raise Flop CBet

Postby kraada » Fri Mar 13, 2009 10:36 am

At a quick glance the stat looks fine. A minor point:
sum(if[holdem_hand_player_statistics.flg_f_check AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND(holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold), 1, 0])

should be functionally equivalent to:

sum(if[holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.flg_f_cbet_def_opp , 1, 0])

(you must call, raise or fold, so you're always going to have done something when you face a cbet :).

That shouldn't cause these problems though. Have you updated your cache since creating the custom statistic? Not doing so would cause the HUD to stop using the cache when you add this stat which would cause all sorts of problems.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Check Raise Flop CBet

Postby Messaa » Fri Mar 13, 2009 11:01 am

Yes I have updated the cache many times since the stat was created. Only for the DB I'm importing into, though.

Other suggestions?
Messaa
 
Posts: 36
Joined: Tue May 27, 2008 1:55 am

Re: Check Raise Flop CBet

Postby WhiteRider » Fri Mar 13, 2009 11:21 am

Does your stat work correctly if you add it to one of the built-in reports in the main PT3 application?
e.g. Hands tab, add it to the top report by clicking the spanner/wrench icon to the right. Does that work?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check Raise Flop CBet

Postby Messaa » Sat Mar 14, 2009 5:10 pm

It seems I have solved this issue by simplifyng the format expr.
Messaa
 
Posts: 36
Joined: Tue May 27, 2008 1:55 am


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

Who is online

Users browsing this forum: No registered users and 13 guests

cron
highfalutin