bet % 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

bet % limp_pot

Postby skolnieks » Tue Feb 14, 2012 1:19 pm

bet % limp_pot-
(cnt_f_bet_limp_pot / cnt_f_open_opp_limp_pot) * 100

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

cnt_f_open_opp_limp_pot-
sum(if[holdem_hand_player_detail.flg_f_open_opp and
(NOT holdem_hand_player_statistics.flg_p_face_raise)
and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

is it ok that i did not find holdem_hand_player_statistics.flg_p_face_raise in existing columns?
i wish to create same stat for flop turn river...
skolnieks
 
Posts: 69
Joined: Wed Aug 10, 2011 5:42 pm

Re: bet % limp_pot

Postby kraada » Tue Feb 14, 2012 2:46 pm

That looks fine to me - the database value is valid and should do what you want as far as I can see.
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 3 guests