"Fold to raise after Cbet" stat and fractions

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

"Fold to raise after Cbet" stat and fractions

Postby rekyl » Tue Sep 02, 2008 5:41 pm

Hi, I downloaded the above named stat, created by EB1983, from the repository. The stat wont show fraction of opportunities when I hover my mouse over the stat in the HUD. For every stat I have created myself, this haven't been a problem and I haven't done anything special to make those fractions show. What can I do to fix this?
rekyl
 
Posts: 43
Joined: Thu Feb 14, 2008 8:45 pm

Re: "Fold to raise after Cbet" stat and fractions

Postby WhiteRider » Wed Sep 03, 2008 10:11 am

This normally seems to be to do with either the format expressions - make sure it says the same in the format summary expression, or the 'summary type' of Columns used. In the Column definition for each one used in the stat, make sure it is of type 'Sum'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: "Fold to raise after Cbet" stat and fractions

Postby rekyl » Wed Sep 03, 2008 11:51 am

Thanks for your reply White Rider.
As far as I can see there is nothing wrong with the Columns used. The format expression is: /%.2f and there is nothing written in the field for "Format Summary Expression", but that is the same with other stats I use and they don't have this problem. Can you download the stat and look for anything that could be wrong?
rekyl
 
Posts: 43
Joined: Thu Feb 14, 2008 8:45 pm

Re: "Fold to raise after Cbet" stat and fractions

Postby js2002 » Thu Sep 04, 2008 4:52 am

Got the same problems and a ticket open.

Sometimes it works and sometimes not.
For the Stat "Contibet Success %age" changing cnt_f_cbet_success / cnt_f_cbet * 100 to (cnt_f_cbet_success / cnt_f_cbet) * 100 worked!
And my summary field is also empty!

But 1 Hint: for the popup tooltips, restart PT3 after adding a new stat and updating the cache.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: "Fold to raise after Cbet" stat and fractions

Postby js2002 » Thu Sep 04, 2008 8:26 am

Got new question about the "Raise F CBet" Stat.

1. me 3Bet PF, Flop in position, Villian check raises my ContiBet. It this counted in "Raise F CBet" Stat ? (first because it was also a c/r and second because it was a 3Bet pot) Today, I had this hand and it didn´t count!

2. generally: does check raising contibets go also into the "Raise F CBet" Stat ?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: "Fold to raise after Cbet" stat and fractions

Postby WhiteRider » Thu Sep 04, 2008 12:24 pm

rekyl wrote:Thanks for your reply White Rider.
As far as I can see there is nothing wrong with the Columns used. The format expression is: /%.2f and there is nothing written in the field for "Format Summary Expression", but that is the same with other stats I use and they don't have this problem. Can you download the stat and look for anything that could be wrong?


Try this:
js2002 wrote:For the Stat "Contibet Success %age" changing cnt_f_cbet_success / cnt_f_cbet * 100 to (cnt_f_cbet_success / cnt_f_cbet) * 100 worked!
And my summary field is also empty!

But 1 Hint: for the popup tooltips, restart PT3 after adding a new stat and updating the cache.



js2002 wrote:Got new question about the "Raise F CBet" Stat.

1. me 3Bet PF, Flop in position, Villian check raises my ContiBet. It this counted in "Raise F CBet" Stat ? (first because it was also a c/r and second because it was a 3Bet pot) Today, I had this hand and it didn´t count!

2. generally: does check raising contibets go also into the "Raise F CBet" Stat ?

1. No. It counts when the player raises a CBet, and since you were the preflop aggressor, you made the CBet - you weren't reacting to it.
2. Yes.

This is the expression:
sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R', 1 , 0 ])

This counts times when you (the current player) faced a 3- or 4-bet preflop (i.e. you don't have to have made one) AND when you faced a C-Bet on the flop and [R]aised.

If you MAKE the c-bet, this expression is false.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: "Fold to raise after Cbet" stat and fractions

Postby js2002 » Thu Sep 04, 2008 12:31 pm

WhiteRider wrote:

This is the expression:
sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='R', 1 , 0 ])

This counts times when you (the current player) faced a 3- or 4-bet preflop (i.e. you don't have to have made one) AND when you faced a C-Bet on the flop and [R]aised.

Huh? And what happens if I call a 2Bet preflop and then raise (or c/r) Villians ContiBet? Will it be count by ur exp above? I dont see and ...p_raise_def_opp ?!

If you MAKE the c-bet, this expression is false.
Sure, that was misdiscribed in point 1, sry.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: "Fold to raise after Cbet" stat and fractions

Postby WhiteRider » Thu Sep 04, 2008 12:52 pm

Sorry - I got mixed up and quoted the wrong stat. What I quoted is from the stats that report actions to C-Bets in pots which were 3-bet preflop.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: "Fold to raise after Cbet" stat and fractions

Postby js2002 » Thu Sep 04, 2008 1:23 pm

thx, just searched it in the column fields ... hehe :)

done here, thx
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: "Fold to raise after Cbet" stat and fractions

Postby SeRvE_VolleY » Fri Sep 05, 2008 2:54 am

just wondering if i want a stat that is: opponent bets and i raise , and he folds....would this be "Fold to R Cbet"
SeRvE_VolleY
 
Posts: 33
Joined: Sat May 10, 2008 7:39 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests