Call (CBet) c/r Flop / Fold to Turn Bet

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

Call (CBet) c/r Flop / Fold to Turn Bet

Postby js2002 » Wed Apr 13, 2011 4:27 pm

Hi,

took the build-in column cnt_f_face_xr_call and added the bold parts:


js2002_cnt_f_face_xr_call_fold_to_t_bet
sum ( if[
holdem_hand_player_statistics.flg_f_cbet AND
lookup_actions_f.action LIKE 'BC' AND
holdem_hand_player_statistics.flg_f_face_raise AND
((holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s)) AND
holdem_hand_player_detail.amt_t_bet_facing > 0 AND
lookup_actions_t.action LIKE 'F'

, 1, 0 ] )

for the denumerator I just remove the fold expression.
OK?
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Call (CBet) c/r Flop / Fold to Turn Bet

Postby kraada » Wed Apr 13, 2011 5:03 pm

That looks good to me.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 7 guests

cron