flg_blind_def_opp not working the way I expected

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

flg_blind_def_opp not working the way I expected

Postby ChicagoAl » Wed Jan 19, 2011 6:15 pm

Hi guys.

I have a custom column that i designed to count the number of times a player cold called a raise with AA, other than in response to an attempt to steal. My formula is this:

sum(if[tourney_holdem_hand_player_statistics.id_holecard = 1 AND tourney_holdem_hand_player_statistics.flg_p_ccall AND NOT tourney_holdem_hand_player_statistics.flg_blind_def_opp, 1, 0])

The formula calculates correctly, except when the player is in one of the blinds. It fails to increment even if the raise came from early position. I thought that flg_blind_def_opp was only true in the case of an attempt to steal, but it appears that it is true if the player was in a blind even if there was no steal attempt. Is there a better way to achieve what I'm looking for?

Thanks,

Al
ChicagoAl
 
Posts: 29
Joined: Thu Aug 05, 2010 10:31 am

Re: flg_blind_def_opp not working the way I expected

Postby kraada » Wed Jan 19, 2011 6:56 pm

The problem here is not the blind defense flag it's the cold call flag - a cold call is when a player calls a raise with no money in the pot. Blinds always have some money in the pot by definition and thus can never cold call regardless of who is making the preflop raise.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: flg_blind_def_opp not working the way I expected

Postby ChicagoAl » Fri Mar 11, 2011 4:45 am

Somehow I let this drop and it came back and bit me again today.

I'm going to take a stab here - you're going to tell me that since there is no flg_p_call flag I can't actually differentiate whether a player called a raise from the blinds or not? Or is there some way to use cnt_p_call to accomplish the same thing?
ChicagoAl
 
Posts: 29
Joined: Thu Aug 05, 2010 10:31 am

Re: flg_blind_def_opp not working the way I expected

Postby kraada » Fri Mar 11, 2011 9:46 am

Well if we know that they faced a raise and if cnt_p_call >= 1 (and they didn't limp in the case of the SB) that they called the raise.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: flg_blind_def_opp not working the way I expected

Postby ChicagoAl » Sun Mar 20, 2011 12:31 am

OK got it. So does that mean that flg_blind_def_opp will only be true if the player is in one of the blinds and facing a steal attempt?
ChicagoAl
 
Posts: 29
Joined: Thu Aug 05, 2010 10:31 am

Re: flg_blind_def_opp not working the way I expected

Postby kraada » Sun Mar 20, 2011 8:59 am

That's correct.
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 0 guests