Stats sens

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

Stats sens

Postby raph156 » Sat Oct 01, 2011 5:41 pm

HI,
If villain complete the small blind in HU, do i have pre flop open opportunity?
holdem_hand_player_statistics.flg_p_open_opp
Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby raph156 » Sat Oct 01, 2011 5:44 pm

In fact, i want when Im in bb and villain fold direct
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby kraada » Sat Oct 01, 2011 5:55 pm

If someone calls, they have opened the action with a call and flg_p_open_opp is false for everyone else behind them.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats sens

Postby raph156 » Sat Oct 01, 2011 6:02 pm

Ok, so how know when im in bb and villain fold or any other equivalente expression?
I want when i have AA and raise or call or dont have possibility to do cause my oppenante fold direct.

sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND (holdem_hand_player_detail.amt_p_raise_made>0 OR (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR NOT holdem_hand_player_statistics.flg_p_raise_opp AND holdem_hand_player_detail.amt_p_raise_facing <0) ,1, 0])

Thanks for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby raph156 » Sat Oct 01, 2011 7:50 pm

Thats good?
sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND (holdem_hand_player_detail.amt_p_raise_made>0 OR (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR NOT holdem_hand_player_statistics.flg_p_face_raise AND NOT substring(lookup_actions_p.action from 1 for 1)='X' ,1, 0])

NOT holdem_hand_player_statistics.flg_p_face_raise AND NOT substring(lookup_actions_p.action from 1 for 1)='X'
so villain fold
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: Stats sens

Postby WhiteRider » Sun Oct 02, 2011 4:42 am

You can check for times that everyone folds to the BB because the BB's action string will be empty, so you can check for this:

lookup_actions_p.action = ''

Note: that is two single quotes, not one double quote.
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 0 guests