limp squeezed, original raiser squeezed, CCPF squeezed

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

limp squeezed, original raiser squeezed, CCPF squeezed

Postby marvin » Wed Sep 01, 2010 6:51 am

in "preflop Squeeze Def Fold" (and def call or def raise) it is not difference if the squeezed was the limper, the original raiser, the CCPF or one blind
i.e. : P4 limp, P3 limp, P1 raise, P0 CCPF, SB call, BB call, P4 3bet, everybody fold. here are squeezed blinds, raiser, CCPF and limper (P3).
is possible make different stat for each kind of player
preflop Squeeze Def Fold bilnd
preflop Squeeze Def Fold Orig raiser
preflop Squeeze Def Fold CCPF
preflop Squeeze Def Fold limper?

TY.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: limp squeezed, original raiser squeezed, CCPF squeezed

Postby kraada » Wed Sep 01, 2010 9:04 am

Yes. You need to duplicate the columns used for the normal preflop squeeze def fold statistic and create slightly modified ones for each of your four cases.

For blind you want to add "AND (holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_blind_b)" without the quotes, inside the if[] statement's antecedent.
For the original raiser: "AND holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_limp = false AND holdem_hand_player_statistics.flg_p_ccall = false"
For CCPF: "AND holdem_hand_player_statistics.flg_p_ccall"
For the limper: "AND holdem_hand_player_statistics.flg_p_limp"
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: limp squeezed, original raiser squeezed, CCPF squeezed

Postby marvin » Wed Sep 01, 2010 5:34 pm

1) about raiser, i dont understand the condition "AND holdem_hand_player_statistics.flg_p_open = false" if the raiser is the first in the pot (RFI) (another situation not like the example) it will be counted? when "holdem_hand_player_statistics.flg_p_open" is true?
2) about blinds i wish know if the blinds squeezed was the raiser or the caller, but cant use flag CCPF.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: limp squeezed, original raiser squeezed, CCPF squeezed

Postby kraada » Wed Sep 01, 2010 5:54 pm

RE: (1) I gave you a definition for the example you gave - if you remove "AND holdem_hand_player_statistics.flg_p_open = false " then it will count situations where the original raiser did not raise limpers as well.

RE: (2) holdem_hand_player_statistics.cnt_p_raise > 0 is true if the player raised at least once preflop and holdem_hand_player_statistics.cnt_p_call >0 is true if the player called at least once preflop; I believe that should let you get the situations you want.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: limp squeezed, original raiser squeezed, CCPF squeezed

Postby marvin » Fri Sep 03, 2010 5:55 pm

1) i thought may be better use the string like ["CR" and flag CCPF](squeeze def raise for CCPF) ("CF" or "CC" (squeeze def fold or (squeeze def call)
2) string like ["CR" and flag limp](squeeze def raise for limper) ["CF" and flag limp] squeeze def fold )or ["CC"and flag limp] or squeeze def call)
3) "RR", RF or RC if squeezed like original raiser.
my first problem is that i have problem about the correct syntax, can you write about 1?
4)about blinds, if i use holdem_hand_player_statistics.cnt_p_call >0 it will count each time blinds is squeezed while had called raise, but also if he was the original raiser and def queeze was "call"... in the same way, if i use holdem_hand_player_statistics.cnt_p_raise>0
it will count blinds caller, squeezed and his def is R, or it will count they were squeezed like Original raiser.... i think that for
4.a) big blind must use ["CR" and flag bb](squeeze def raise for caller) ["CF" and flag bb: squeeze def fold )or ["CC"and flag bb] : squeeze def call) + ["RR" and flag bb](squeeze def raise for raiser) ["RF" and flag bb: squeeze def fold for original raiser)or ["RC"and flag bb] : squeeze def call for original raiser)

4.b) the problem is SB, if i use "C...", it will count both action (limper and cold caller)
p5 limp, p2 limp, SB call, BB raise, P5 call, P2 squeeze, SB is squeezed after limp.
p2 raise, SB call, BB 3Bet, SB is squeezed after call Raise.
how can have distinction among theese two?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: limp squeezed, original raiser squeezed, CCPF squeezed

Postby kraada » Fri Sep 03, 2010 6:16 pm

If you want to use action strings (which you can, you just need to be careful you don't let in too much or block out too much), you want to use lookup_actions_p.action LIKE 'STRING' where STRING is whatever you want - and if you want a wildcard, it's % (so 'C%' matches CF, CR, CRR, etc).

About your second question you can distinguish the squeeze action with enum_p_squeeze_action - so you could have something like (holdem_hand_player_statistics.cnt_p_call > 0 AND NOT(enum_p_squeeze_action = 'C') if you so desired.

With regards to your last question, for the SB flg_p_limp is true in the first situation but not in the second.
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