Tutorial: Creating C-bet Success Statistic

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

Re: Tutorial: Creating C-bet Success Statistic

Postby BoFo » Mon Sep 08, 2008 2:23 pm

Thanks, it now seems to work. U are not only kind, but also rather bright.

Yours, Bo.
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Tutorial: Creating C-bet Success Statistic

Postby WhiteRider » Mon Sep 08, 2008 2:26 pm

LOL :D :ugeek:
YW.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tutorial: Creating C-bet Success Statistic

Postby BoFo » Wed Oct 22, 2008 12:06 pm

There is one more thing: it comes out like 52.44 and two squares thereafter. Those cant be copied into this message, but I hope you know the type. It's like when I try to open something in "Word" that the program does not recognize. I have got /%.2f in both fields.

Yours, Bo.
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Tutorial: Creating C-bet Success Statistic

Postby WhiteRider » Wed Oct 22, 2008 12:21 pm

Yes, I understand what you mean.
Please Export your stat and attach it to a ticket on the Support system , and link to this thread in the reference field of the ticket so that we can investigate.
Let me know your ticket number.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tutorial: Creating C-bet Success Statistic

Postby BoFo » Wed Oct 22, 2008 1:59 pm

Support Ticket #37520
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Tutorial: Creating C-bet Success Statistic

Postby WhiteRider » Wed Oct 22, 2008 2:08 pm

I replied to your ticket - you have pressed <enter> at the end of /%.2f, that is what the boxes are trying to represent. If you remove the newline it should remove the boxes.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tutorial: Creating C-bet Success Statistic

Postby BoFo » Wed Oct 22, 2008 2:39 pm

Bravo! It does not take much to mess it up! Thanks again!
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Tutorial: Creating C-bet Success Statistic

Postby WhiteRider » Wed Oct 22, 2008 3:03 pm

No problem.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Tutorial: Creating C-bet Success Statistic

Postby feint06 » Mon Nov 17, 2008 5:05 pm

Very cool tutorial, should be stickied imo.

kraada wrote:So what is our test? First we make sure we did c-bet (flg_f_cbet) and we didn't see a turn using NOT and (flg_t_saw) and we never faced a raise (NOT(flg_f_face_raise)).

Why this test? It should be obvious why we want to make sure we c-bet. But then what is a success? All opponents folded. Unfortunately there is no flg_all_opponents_gave_up flag. But what happens when all opponents fold? We don't get to see the turn. Then you have to make sure there are no cases you are missing. If we only used the first two, we would miss the situation where we bet, the other player raised, and we folded, thus not seeing a turn, but our c-bet would most definitely not have succeeded :)

Are there any other cases where we c-bet, don't see a turn and don't get raised that the c-bet fails? I can't think of any.


This is true, but I think your definition also undervalues the cbet success a little. There will be times when we cbet, an opponent raises, and we 4bet causing the opponent to fold (example -- you have AA and make a standard cbet on a raggy flop. A competent villain knows you could be cbetting with ace-high and takes a stab at the pot by 3betting -- you shove and he folds). These cases will be counted as failed cbets (which I suppose they are since the cbet itself failed) but the end result was a profitable situation (which I believe is the goal of this statistic).

So it would seem to me that to include these scenarios, we need a definition that is based on us winning the pot on the flop instead of us not seeing a turn with some other stipulations.
feint06
 
Posts: 859
Joined: Fri Feb 01, 2008 10:18 pm

Re: Tutorial: Creating C-bet Success Statistic

Postby kraada » Mon Nov 17, 2008 5:20 pm

True, in that case use holdem_hand_player_statistics.flg_won though make sure to have not(turn saw) otherwise you end up getting all hands you won that you cbet and that's going to be such a lot of hands that it's going to be hard to gauge how well the c-bet worked.

Personally I'd rather make a bet/3bet statistic and see how often that wins; the idea behind this stat was to see how often your cbets just win without further action, to answer the question of how often you should cbet regardless of cards/board texture/etc. If you want a stat for slightly different reasons that changes how you'd want the definition.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 3 guests

cron
highfalutin