Contbet turn and river in 3bet pots

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

Contbet turn and river in 3bet pots

Postby black winter day » Wed Jul 01, 2009 4:16 am

I didn't find those stats in repository, can you make them?
Just please don't ask me to make them myself using some formulas, i tried to make custom stats before and didn't succeed.
black winter day
 
Posts: 144
Joined: Sun Feb 10, 2008 7:56 pm

Re: Contbet turn and river in 3bet pots

Postby kraada » Wed Jul 01, 2009 9:22 am

These are going to be pretty simple and I'll show you how to make the one for the turn. I'm confident you can handle the river afterwards :)

Click Configure --> Configure Statistics and click on Holdem Cash Player Statistics, then go to the Columns tab. Click New, call the new column cnt_t_cbet_3b_pot (for count of how many times you cbet a 3bet pot on the turn), give it this definition:
sum(if[holdem_hand_player_statistics.flg_t_cbet and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp), 1, 0])

This adds up all the times you: cbet the turn (flg_t_cbet) and either 3bet yourself (flg_p_3bet) or faced a 3bet (flg_p_3bet_def_opp). That's going to be how often you cbet the turn in a 3bet pot.

Then you need another column for how many times you had the chance to cbet in a 3bet pot. Click New again (after saving that column), call the new one: cnt_t_cbet_opp_3b_pot, with this definition:
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp), 1, 0])
which as you can see is quite similar, it just checks to see how many cbet opportunities you had (flg_t_cbet_opp) instead of how many cbets you actually made.

Once that column is saved, go to the stats tab. Click New, give your new stat a title and description. For value expression use:
(cnt_t_cbet_3b_pot / cnt_t_cbet_opp_3b_pot) * 100

Then go to the Format tab, add a title and width, and put /%.2f in the format expression box. Save your stat.

That's it.

For the river, do the same just do the same thing using _r_ in place of _t_.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Contbet turn and river in 3bet pots

Postby JustAnotherForum » Wed Jul 01, 2009 12:10 pm

wouldn't you have to filter out pots that were 4bet+?

sum(if[holdem_hand_player_statistics.flg_t_cbet_opp
AND (holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_3bet_def_opp)
AND NOT holdem_hand_player_statistics.flg_p_4bet
AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])
JustAnotherForum
 
Posts: 19
Joined: Sun Aug 10, 2008 1:13 pm

Re: Contbet turn and river in 3bet pots

Postby kraada » Wed Jul 01, 2009 12:16 pm

You could do that as well if you wanted to; I didn't assume that it was what OP wanted. He might want all 3+ bet pots counted (I do it that way for my Fold to c-bet in 3-bet pots).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Contbet turn and river in 3bet pots

Postby JustAnotherForum » Wed Jul 01, 2009 12:52 pm

imo most ppl differentiate between 3 and 4 bet pots because the dynamic and hand ranges are completely different. And especially for this stat, in a 4bet pot to have a 2 more bets go in postflop will usually be an extreme outlier and likely not what OP is looking for.

Also, what is the poker tracker coding standard regarding statiscs? If PT3 were to have this stat as a built-in, would the standards that the developers follow include 4-bet pots in a stat called "Contbet turn and river in 3bet pots"? Not attacking, just curious about the accuracy of the stats already included in PT3.
JustAnotherForum
 
Posts: 19
Joined: Sun Aug 10, 2008 1:13 pm

Re: Contbet turn and river in 3bet pots

Postby kraada » Wed Jul 01, 2009 1:11 pm

If you can't cbet the turn (which requires a flop cbet) because you're all in, it won't be a cbet opportunity either way, and similarly for the river, so the likely cases for the river cbet (and turn cbet to an extent) are going to be exactly 3bet pots.

As to the dynamic I do think it changes quite a bit by game type, so if he's playing 6 max or heads up it's going to work a lot differently than full ring. Also if he's playing more deep tables it's going to vary - this is why you have to thikn quite a bit about exactly what stats you want :)

I don't know of plans to add default stats like this into PT3 at this point; I would suspect that if they were ever to be added, default stats would likely go in as you proscribe and there'd be a 4bet pot variant (which is easy to build from the above information). Are there any other specific stats you want more information about?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Contbet turn and river in 3bet pots

Postby black winter day » Wed Jul 01, 2009 8:22 pm

Justanotherforum - thanks for the addition, yes, i would like to have this stat for 3bet pots only.

Kraada - can you just please make those stats for 3bets only, filtering out 4bets and add it to repository?
I think it would be easier for both of us, then for me trying to build a custom stat, failing, asking you to build it yourself etc etc.

And the more such stats will be in the repository, the less work you'll have explaining to everyone separately how to do it anyway :)

As for me, i won't be able to create custom stats anyway, because i don't really understand how this works...
black winter day
 
Posts: 144
Joined: Sun Feb 10, 2008 7:56 pm

Re: Contbet turn and river in 3bet pots

Postby WhiteRider » Thu Jul 02, 2009 4:33 am

I would really recommend making the effort to learn how to do this for yourself - it really isn't that hard if you follow the steps kraada described, and once you learn how to build them you will be able to build other stats in the same way and this really opens up the possibilities.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Contbet turn and river in 3bet pots

Postby black winter day » Thu Jul 02, 2009 7:12 am

Guys, i don't want to go through the same thing again.
I am not an advanced programmer. I said in this thread like 3 times - i don't understand how the stats are build and i don't think i need much more stats than the ones that are already there.
I mean, i can probably follow the instructions like a monkey and do it, but i could make a mistake and each cash update process takes like an hour and if after that i see that the stat is wrong again, it tilts me.
Not to mention, that there were some different strings in this thread, when Justanotherforum added the formulas for filtering out 4bet stats and i don't know how to incorporate them.

I have asked you for 2 similar stats to be made...why would you make it harder for me instead of just making them? Why instead do you make me feel uncomfortable asking you to do the same thing over and over and feeling stupid because i don't know how it's done.
black winter day
 
Posts: 144
Joined: Sun Feb 10, 2008 7:56 pm

Re: Contbet turn and river in 3bet pots

Postby kraada » Thu Jul 02, 2009 8:45 am

Because we want to help you so that you understand what's going on. Give a man a fish, and all that.

Either way, here's your fish:
Attachments
Cbetstats.zip
(1.17 KiB) Downloaded 164 times
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests