Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
-
by 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
by 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:
Make sure you don't have any other conflicting filters in use.
-
Flag_Hippo
- Moderator
-
- Posts: 14510
- Joined: Tue Jan 31, 2012 7:50 am
by 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
by 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: 14510
- Joined: Tue Jan 31, 2012 7:50 am
by 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
by 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: 14510
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 27 guests