delayed XR stat

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

delayed XR stat

Postby caribbean93 » Sat Oct 12, 2024 11:01 am

Hi, I'm trying to create a stat for my HUD of tournaments Spins.

I want to know the percentage of check raise of my rival vs my delayed bet BTN vs BB. I open raise as BTN, BB called, I don't Cbet Flop, BB don't probe turn, I bet turn and BB raise.

Thanks for you help
caribbean93
 
Posts: 7
Joined: Fri Feb 26, 2016 7:22 pm

Re: delayed XR stat

Postby Ventilatorrr » Sun Oct 13, 2024 7:51 am

Hello,

Here are updated columns (and the stat) for the BB vs BTN Raise vs Turn Delayed Cbet stat:

1. Column #1: cnt_bb_vs_btn_raise_vs_turn_delayed_cbet_srp
Code: Select all
sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.str_aggressors_p = '80' and tourney_hand_summary.str_actors_p = '08' and lookup_actions_f.action = 'X' and lookup_actions_t.action LIKE 'XR%', 1, 0])


2. Column #2: cnt_bb_vs_btn_raise_vs_turn_delayed_cbet_srp_opp
Code: Select all
sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.str_aggressors_p = '80' and tourney_hand_summary.str_actors_p = '08' and lookup_actions_f.action = 'X' and lookup_actions_t.action LIKE 'X_%', 1, 0])


3. Stat: BB vs BTN Raise vs Turn Delayed Cbet
Code: Select all
(cnt_bb_vs_btn_raise_vs_turn_delayed_cbet_srp / cnt_bb_vs_btn_raise_vs_turn_delayed_cbet_srp_opp) * 100
Ventilatorrr
Moderator
 
Posts: 51
Joined: Sun Jul 19, 2015 12:39 pm

Re: delayed XR stat

Postby Ventilatorrr » Mon Oct 14, 2024 9:24 am

An expert has looked over my columns and has noticed an issue with the lookup_actions_t.action = 'XR' part, which doesn't include hands with any further actions after check/raising on the turn to count towards the stat. Also, "=" has been used instead of "LIKE" in str_aggressors_p and str_actors_p parts. I've edited my previous post with these changes.
Ventilatorrr
Moderator
 
Posts: 51
Joined: Sun Jul 19, 2015 12:39 pm

Re: delayed XR stat

Postby caribbean93 » Tue Oct 15, 2024 4:28 am

Thank you, I'll give it a try right now
caribbean93
 
Posts: 7
Joined: Fri Feb 26, 2016 7:22 pm

Re: delayed XR stat

Postby caribbean93 » Wed Oct 16, 2024 4:54 am

Great,it works.

How could I make two different stats, one for Limped pots and the other for Raised pots?

Cheers
caribbean93
 
Posts: 7
Joined: Fri Feb 26, 2016 7:22 pm

Re: delayed XR stat

Postby Flag_Hippo » Wed Oct 16, 2024 6:32 am

That depends on if you mean generally or for what's been posted above. You can normally test for a limped pot with:

Code: Select all
char_length(cash_hand_summary.str_aggressors_p) = 1

and raised pots with:

Code: Select all
char_length(cash_hand_summary.str_aggressors_p) >= 2

but that will not work for what's been posted above since the aggressors string in those columns is set at being two characters long since you wanted hands where BTN raised and BB called so just adding char_length(cash_hand_summary.str_aggressors_p) = 1 to those columns would mean not getting any data without further adjustments.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 44 guests

cron
highfalutin