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 feint06 » Mon Nov 17, 2008 5:28 pm

kraada wrote: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.


Good points.


Before your reply I was looking through the schema and wondering how I would approach the problem. Would this work also:

Code: Select all
sum(if[holdem_hand_player_statistics.flg_f_cbet AND NOT(holdem_hand_player_statistics.flg_t_saw) AND NOT(holdem_hand_player_statistics.flg_f_fold), 1, 0])
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:32 pm

That would increment for bet/3bet and your cbets just worked both, yes.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

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

Who is online

Users browsing this forum: No registered users and 3 guests

cron
highfalutin