cnt_p_isolation_opp

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

cnt_p_isolation_opp

Postby Alexkidd103 » Wed Oct 29, 2008 8:53 pm

sum( if[holdem_hand_player_statistics.flg_p_face_raise=false AND holdem_hand_player_statistics.flg_p_open_opp=false, 1, 0])

"Number of times a player had a an isolation opportunity"

is this correct?
Alexkidd103
 
Posts: 40
Joined: Thu Jul 17, 2008 3:59 pm

Re: cnt_p_isolation_opp

Postby Alexkidd103 » Wed Oct 29, 2008 9:55 pm

ok i did the follwing


cnt_p_isolation:
sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp=false, 1, 0])

cnt_p_isolation_opp
sum( if[holdem_hand_player_statistics.flg_p_face_raise=false AND holdem_hand_player_statistics.flg_p_open_opp=false, 1, 0])


stat:
Isolation
(cnt_p_isolation / cnt_p_isolation_opp) * 100

Now besides of the fact i don't know if i'm getting the right number with that formula. When i move the cursor over the number in the hud i get a 50.00000000000 with all those zeros, why?
Alexkidd103
 
Posts: 40
Joined: Thu Jul 17, 2008 3:59 pm

Re: cnt_p_isolation_opp

Postby Alexkidd103 » Thu Oct 30, 2008 5:16 am

i solved teh several decimal problem but i found an error on the stat
The problem is that while i can numerate the hand where the player isolated, i can't get the isolation opp correct.
The reason is that i would need a "first raise opp" and doesn't exist such thing nor i can reproduce it, any advice on how to generate a good isolation_opp is welcome.
Alexkidd103
 
Posts: 40
Joined: Thu Jul 17, 2008 3:59 pm

Re: cnt_p_isolation_opp

Postby WhiteRider » Thu Oct 30, 2008 5:55 am

No, you're right - your opportunity column isn't right because you can face a raise after you call.

You will need to use something like my 'facing limpers' column:

sum( if[ ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp, 1 , 0 ] )

This won't tell you how many limpers there are, though.
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