Openfold and opencall from SB

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

Openfold and opencall from SB

Postby TheLuigi » Fri Oct 01, 2010 8:45 pm

There is a stat for openraise from SB, but I haven't seen stats for other 2 possible actions of SB when folded to him. Is it possible to code those?

Thanks.
TheLuigi
 
Posts: 15
Joined: Tue Jul 15, 2008 5:02 pm

Re: Openfold and opencall from SB

Postby kraada » Sat Oct 02, 2010 8:59 am

You can use the Limp statistic from the Blinds position to see how often someone open limps the small blind (since you cannot ever limp from the big blind). You can then calculate open folding from these values (100 - steal attempt (blinds) - limp (blinds) = open fold from small blind).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Openfold and opencall from SB

Postby TheLuigi » Sat Oct 02, 2010 1:44 pm

Why this is not valid SQL?

sum( if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp, 1, 0 AND holdem_hand_player_statistics.flg_blind_s, 1, 0])
TheLuigi
 
Posts: 15
Joined: Tue Jul 15, 2008 5:02 pm

Re: Openfold and opencall from SB

Postby WhiteRider » Sat Oct 02, 2010 2:19 pm

TheLuigi wrote:Why this is not valid SQL?

sum( if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp, 1, 0 AND holdem_hand_player_statistics.flg_blind_s, 1, 0])

Because you have the 1, 0 bit twice.
Try this:

sum( if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_blind_s, 1, 0])
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