creating fold_flop%Limp_Pot

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

creating fold_flop%Limp_Pot

Postby skolnieks » Wed Feb 15, 2012 6:24 am

creating fold_flop%Limp_Pot...

(cnt_f_fold_limp_pot / cnt_f_fold_opp_limp_pot) * 100

cnt_f_fold_limp_pot -
sum(if[holdem_hand_player_statistics.flg_f_fold and
(NOT holdem_hand_player_statistics.flg_p_face_raise)
and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

cnt_f_fold_opp_limp_pot -

sum(if[holdem_hand_palyer_statistics.flg_f_saw
(NOT holdem_hand_player_statistics.flg_p_face_raise) =1,0,0])

i cant find a problem for this stat...
skolnieks
 
Posts: 69
Joined: Wed Aug 10, 2011 5:42 pm

Re: creating fold_flop%Limp_Pot

Postby kraada » Wed Feb 15, 2012 9:40 am

Your problem is in cnt_f_fold_opp_limp_pot. You want it to read: sum(if[holdem_hand_player_statistics.flg_f_saw and
(NOT holdem_hand_player_statistics.flg_p_face_raise)
and holdem_hand_player_statistics.cnt_p_raise = 0 and (holdem_hand_player_statistics.cnt_f_call > 0 or holdem_hand_player_statistics.cnt_f_raise > 0 or holdem_hand_player_statistics.flg_f_fold), 1, 0])

Seeing the flop, not having faced a preflop raise and not having made a preflop raise implies that it is a limp pot. Then on the flop if you've either called or raised or folded you must have had a chance to fold.
kraada
Moderator
 
Posts: 54430
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 4 guests