Count raises on flop

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Count raises on flop

Postby BannedOak » Mon Dec 20, 2021 2:21 am

Hello,
with this column
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND tourney_hand_player_statistics.flg_f_bet, 1, 0])

I get number of bets the player made on flop in heads up.
I cannot create the simmilar column for getting number of raises the player made on flop in heads up because Database field tourney_hand_player_statistics has a Field name cnt_f_raise which is int2 Type. There is no flg_f_raise as a bool Type.
How can I get a number of raises the player made on flop in heads up?
BannedOak
 
Posts: 58
Joined: Fri Sep 03, 2010 1:56 am

Re: Count raises on flop

Postby majonyjony » Mon Dec 20, 2021 8:24 am

This should work for you

Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%'), 1, 0])
majonyjony
 
Posts: 106
Joined: Wed Oct 08, 2008 4:01 am

Re: Count raises on flop

Postby BannedOak » Mon Dec 20, 2021 4:04 pm

Thank you,

your code works fine, and I created a similar code for counting calls
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%'), 1, 0])

but when I test it, it detects Calls, but doesn't detect CheckCalls at the flop.
Can you tell why?
BannedOak
 
Posts: 58
Joined: Fri Sep 03, 2010 1:56 am

Re: Count raises on flop

Postby Flag_Hippo » Tue Dec 21, 2021 6:51 am

BannedOak wrote:but when I test it, it detects Calls, but doesn't detect CheckCalls at the flop.
Can you tell why?

How are you testing it? That expression does count flop check-calls:

xc.PNG

Make sure you don't have any other conflicting filters in use.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: Count raises on flop

Postby BannedOak » Tue Dec 21, 2021 4:12 pm

Flag_Hippo wrote:
BannedOak wrote:but when I test it, it detects Calls, but doesn't detect CheckCalls at the flop.
Can you tell why?

How are you testing it? That expression does count flop check-calls:

xc.PNG

Make sure you don't have any other conflicting filters in use.

I am using it as a part of the formula to calculate AFq at the Flop. When I observe calculation, it takes into account Calls, but doesn't count CheckCalls.
BannedOak
 
Posts: 58
Joined: Fri Sep 03, 2010 1:56 am

Re: Count raises on flop

Postby Flag_Hippo » Wed Dec 22, 2021 7:17 am

BannedOak wrote:I am using it as a part of the formula to calculate AFq at the Flop. When I observe calculation, it takes into account Calls, but doesn't count CheckCalls.

Are you going to provide details about this "formula" you are using and the "calculation" you are observing? The expression in this thread counts flop check-calls so unless you provide specific information regarding exactly what you are doing beyond that then I cannot assist you any further.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: Count raises on flop

Postby BannedOak » Wed Dec 22, 2021 3:50 pm

Flag_Hippo wrote:
BannedOak wrote:I am using it as a part of the formula to calculate AFq at the Flop. When I observe calculation, it takes into account Calls, but doesn't count CheckCalls.

Are you going to provide details about this "formula" you are using and the "calculation" you are observing? The expression in this thread counts flop check-calls so unless you provide specific information regarding exactly what you are doing beyond that then I cannot assist you any further.

The formula is this one
Code: Select all
((xyz_hu_f_bet + xyz_hu_f_raise) / (xyz_hu_f_call + xyz_hu_f_fold + xyz_hu_f_bet + xyz_hu_f_raise)) * 100

and column definitions are
xyz_hu_f_bet
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND tourney_hand_player_statistics.flg_f_bet, 1, 0])

xyz_hu_f_raise
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%'), 1, 0])

xyz_hu_f_call
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%'), 1, 0])

xyz_hu_f_fold
Code: Select all
sum(if[tourney_hand_summary.cnt_players = 2
 AND tourney_hand_player_statistics.flg_f_fold, 1, 0])

and HUD profile editor -> item properties for this stat is defined as Small Blind (SB) in the Position field (when this stat is used for SB headsup AFq), and as Big Blind (BB) in the Position field (when this stat is used for BB headsup AFq)
BannedOak
 
Posts: 58
Joined: Fri Sep 03, 2010 1:56 am

Re: Count raises on flop

Postby Flag_Hippo » Thu Dec 23, 2021 6:58 am

That looks fine but you haven't said exactly how you have verified that flop check-calls are not being counted. Have you rebuilt your custom database cache? If you have then attach your custom statistic here along with your verification steps.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Amazonbot and 24 guests

cron