c/f turn when c/r flop

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

c/f turn when c/r flop

Postby js2002 » Fri Sep 17, 2010 6:31 am

Is this a good way to build it:

Numerator
lookup_actions_f.action LIKE 'XR' (last action raise, correct huh?) AND
lookup_actions_t.action LIKE 'XF'

Denumerator
lookup_actions_f.action LIKE 'XR'

Is this good? Does such a stat make sense?

results would be: he c/r 10x the flop and 7x he check folded, so his check raises are not very strong.
the 3 other cases must be bet fold or bet call or bet raise[3bet] (b/f b/c b/r) or check call or check fold or again check raise (c/c c/f c/r in PT3: XF XF XR)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/f turn when c/r flop

Postby kraada » Fri Sep 17, 2010 9:02 am

You might want to change that denominator to:

lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%'

This way you checked on the turn and definitely faced a bet. Otherwise flops where you XR and turns where you X and your opponent checks back get counted as 0/1 in this situation even though you might have folded should you have faced a bet.

You also can consider adding % to other things if you want strings like XRR to count, but I can at least see there why you might not want them to.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: c/f turn when c/r flop

Postby js2002 » Fri Sep 17, 2010 9:11 am

kraada wrote:You might want to change that denominator to:

lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%'

This way you checked on the turn and definitely faced a bet. Otherwise flops where you XR and turns where you X and your opponent checks back get counted as 0/1 in this situation even though you might have folded should you have faced a bet.


aaah thx so _% means "1 wirdcard but at least one, followed by anything". Correct me please if I talk bull.

"You also can consider adding % to other things if you want strings like XRR to count, but I can at least see there why you might not want them to."


I cant see that lol :) really, please tell why u mean that I dont want the ending %s.

until then i think this can be good:

Numerator
lookup_actions_f.action LIKE 'XR%' AND
lookup_actions_t.action LIKE 'XF'

Denumerator
lookup_actions_f.action LIKE 'XR%' AND
lookup_actions_t.action LIKE 'X_%'

accurate in ur eyes?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/f turn when c/r flop

Postby kraada » Fri Sep 17, 2010 9:42 am

That looks good and yes you understand X_% properly.

I could see you not wanting situations where the initial flop bettor 3-bets mattering.

For example, A & B are very deep (say 500BB) in a limp pot. A checks, B bets (2BB), A raises (6BB), B 3-bets (18BB), A calls. On the Turn, A checks and folds. It's a weird spot but 500BB deep I don't think it'd be an incredibly terrible line (say B has a double gutshot draw or some such, and A is the sort of person who will commit the rest of his stack with an overpair on the turn even if B hits his draw). And I can see how that's different than A checks, B bets, A raises, B calls, and A then check/folding the turn.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: c/f turn when c/r flop

Postby js2002 » Fri Sep 17, 2010 9:54 am

I see, thx. I dont want these spots u are right.
So I change it back to:

Numerator
lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'XF'

Denumerator
lookup_actions_f.action LIKE 'XR' AND
lookup_actions_t.action LIKE 'X_%'

I think is is good now.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/f turn when c/r flop

Postby js2002 » Fri Sep 24, 2010 4:07 am

because its somehow similar:

I need a river c/f stat now:

Numerator
flop cbet and turn cbet and river lookup_actions_t.action LIKE 'XF'

Denumerator
flop cbet and turn cbet and river lookup_actions_t.action LIKE 'X_%'

Name of the Stat:

c/f River after 2Barrels (ideas welcome)

A very interesting stat 4 FL and NL.
NL got much more aggressive and even not advanced players know the value of 2nd barrels, so I´d like to know, if the River check ist a trap (c/r) a catch (c/c) or a give up (c/f), last one is this stat.

goode idea and good realized? (I think so)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: c/f turn when c/r flop

Postby kraada » Fri Sep 24, 2010 8:57 am

I think so. Though for NL you may need a very large sample of hands before you get any real data here depending on the dynamics of the game you play.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: c/f turn when c/r flop

Postby WhiteRider » Fri Sep 24, 2010 9:47 am

As a very minor point, you don't need to check for a flop c-bet if you check for a turn c-bet as you can only make a c-bet if you also c-bet the previous street.

You could make this stat even more precise by checking for a river c-bet opportunity [instead of flop and turn c-bets] - that would mean that hands where the player's turn c-bet is raised would be ignored.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: c/f turn when c/r flop

Postby kraada » Fri Sep 24, 2010 9:54 am

Actually as I look at it again, this looks very similar to the built in stat Fold to River Float - you cbet flop and turn, then check and face a bet from behind you on the river. That would be the very definition of a float bet.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: c/f turn when c/r flop

Postby js2002 » Fri Sep 24, 2010 9:59 am

kraada wrote:Actually as I look at it again, this looks very similar to the built in stat Fold to River Float - you cbet flop and turn, then check and face a bet from behind you on the river. That would be the very definition of a float bet.


Yeah It is. Did u check the positional "problem" here?
maybe u check the fold to float river stat too?

EDIT:

this is my num for fold to river cbet float:

sum(if[NOT(holdem_hand_player_statistics.flg_p_face_raise) AND holdem_hand_player_statistics.flg_t_cbet AND holdem_hand_player_statistics.enum_r_float_action='F', 1, 0])

I added the cbet, because the build in stat counted different spots. I cant tell which, but my and the build-in produced different results.
(the first term is obsolete I guess,wait: maybe it was build to catch only SRPs (single raised pots))

My def of float is that ucan only float the cbetter.


EDIT2:

MERGE_GAME #2774443800088: Texas Hold'em L $0.02/$0.04 09/12/2010 07:14:32
Table Sydney Harbour Bridge (27744438)
Seat 7: tanakopa ($1.09 in chips) DEALER
Seat 8: avajfire ($1.08 in chips)
tanakopa: Post SB $0.01
avajfire: Post BB $0.02
*** HOLE CARDS ***
Dealt to avajfire [7h 6c]
tanakopa: Call $0.01
avajfire: Check
*** FLOP *** [Jd 8s 2c]
avajfire: Check
tanakopa: Check
*** TURN *** [9d]
avajfire: Bet $0.04
tanakopa: Call $0.04
*** RIVER *** [9c]
avajfire: Check
tanakopa: Bet $0.04
avajfire: Fold
*** SUMMARY ***
Total pot $0.16 Rake $0.00
tanakopa: wins $0.16


yeah, this is a River DEF ACTION FOLD ......... NOT 4 me!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests