SB fold to BB flop cbet when SB open limp/called iso pre

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Mon Feb 08, 2021 8:18 pm

Hello!

I would like to make statistic for - SB fold to BB flop cbet when SB open limp/called BB iso preflop. Is there a safe way for me to do that? I'm not really good with these expression values etc. and really wouldn't want to create faulty stat that doesn't actually show info what I think it does.
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby Flag_Hippo » Tue Feb 09, 2021 6:52 am

There is a built-in statistic called 'Preflop Limp Call' which you can use to get started. You can make that specific to the SB open limping by adding this to the columns:

Code: Select all
and cash_hand_player_statistics.position = 9 and cash_hand_player_statistics.flg_p_open_opp

and then add the information from the columns for the built-in statistic called 'Fold to F CBet' - see this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. If you want your custom statistic checked after creating it then post the details here and we can check it for you.
Flag_Hippo
Moderator
 
Posts: 15135
Joined: Tue Jan 31, 2012 7:50 am

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Tue Feb 09, 2021 6:07 pm

Errors already in part one - I duplicated the preflop limp/call stat to work with it. Tried adding the columns you wrote to it, but wasn't able to make the expression valid regardless of where I put the additional columns - before, after the original stat, with or without brackets or within the brackets of the original stat. How do I add them together correctly ( also having in mind that I'll have to add the fold to cbet part after that). https://gyazo.com/8c1fefdc7aacd4bcab45082c5034a5ef
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby Flag_Hippo » Wed Feb 10, 2021 7:19 am

You need to add that information to the 'Expression' of custom columns and you are trying to add the information to the 'Value Expression' of the statistic itself - see this guide. When the new custom columns are created you can then create a new custom statistic with those and you have done this before so maybe this thread will refresh your memory.
Flag_Hippo
Moderator
 
Posts: 15135
Joined: Tue Jan 31, 2012 7:50 am

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Wed Feb 10, 2021 9:12 am

Yesterday I tried to make a new columns which didn't work instead of integrating the info in to the existing limp stat columns. https://gyazo.com/0f74b16c79e1aa7b027c4f46aea88471 this seems to work, is it correct? And after that I do the same for facereraise column.

How do I combine the fold to F cbet stat with limp/call pre stat? Do I somehow add up the stat expressions? Do I also need to add the positional info you provided to "fold to cbet" stat columns?
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby Flag_Hippo » Wed Feb 10, 2021 12:59 pm

TRNSLTR wrote:https://gyazo.com/0f74b16c79e1aa7b027c4f46aea88471 this seems to work, is it correct?

Yes although while it doesn't affect the function of the column I'd rename it so it's clear what it is counting as well updating the description field accordingly.
TRNSLTR wrote:And after that I do the same for facereraise column.

Yes.
TRNSLTR wrote:How do I combine the fold to F cbet stat with limp/call pre stat? Do I somehow add up the stat expressions? Do I also need to add the positional info you provided to "fold to cbet" stat columns?

Add the expressions from the 'Fold to CBet' columns (excluding the sum(if[, 1, 0]) statement) in the same way as you've added the positional info. When you have done that you can create a new custom statistic with a value expression of:

(a / b) * 100

where 'a' and 'b' are your custom column names.
Flag_Hippo
Moderator
 
Posts: 15135
Joined: Tue Jan 31, 2012 7:50 am

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Wed Feb 10, 2021 2:30 pm

So, this is how far I've gotten - column one https://gyazo.com/a183b373451c41ff43b119248110ce65 , column two https://gyazo.com/27d7396e7d39df3abb81510a6bf639a3 and the stat https://gyazo.com/da91d4829123514455db93b2fec9155a . Everything good and the stat is ready?
For some reason I couldn't change the name of those duplicate stats (that line is inactive). I guess I could work around that by just creating brand new columns instead of duplicating them.

After creating custom stat I think I had to rebuild cache or smth like that for the stat to show actual info right?
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Wed Feb 10, 2021 3:25 pm

Thinking about it, those columns don't feel right since both of them count folds to cbets instead of one counting opportunities to fold. Changed them to these:
Column one https://gyazo.com/27d010129c8b835f54d9e8f3c87778e3
Column two https://gyazo.com/27d010129c8b835f54d9e8f3c87778e3

Let me know if my corrections are correct.
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby Flag_Hippo » Thu Feb 11, 2021 1:25 pm

TRNSLTR wrote:Thinking about it, those columns don't feel right since both of them count folds to cbets instead of one counting opportunities to fold. Changed them to these:
Column one https://gyazo.com/27d010129c8b835f54d9e8f3c87778e3
Column two https://gyazo.com/27d010129c8b835f54d9e8f3c87778e3

Let me know if my corrections are correct.

You've used for the same screenshot for both columns there. Instead of posting screenshots I'd recommend copy/pasting each of the column expressions directly into your replies since that way if there is an issue I can copy/paste from those myself and edit them which I cannot do with screenshots.
TRNSLTR wrote:I guess I could work around that by just creating brand new columns instead of duplicating them.

You can duplicate them again, rename them and delete the original copies. Also do not forget to go back and rename the 'Value Expression' of the statistic with the new column names.
TRNSLTR wrote:After creating custom stat I think I had to rebuild cache or smth like that for the stat to show actual info right?

For new or changed custom columns to use the database cache then the custom cache needs to be rebuilt (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild). You don't have to rebuild the custom cache every time you make a change but you'll want to rebuild the custom cache when you've finished a batch of changes so that the stats can use the cache and are therefore faster:

Guide: Database Caching
Flag_Hippo
Moderator
 
Posts: 15135
Joined: Tue Jan 31, 2012 7:50 am

Re: SB fold to BB flop cbet when SB open limp/called iso pre

Postby TRNSLTR » Thu Feb 11, 2021 3:24 pm

Flag_Hippo wrote:You've used for the same screenshot for both columns there. Instead of posting screenshots I'd recommend copy/pasting each of the column expressions directly into your replies since that way if there is an issue I can copy/paste from those myself and edit them which I cannot do with screenshots.

Oh, my bad. Ok, so this is "cnt_p_limp_call_copy" column:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise and lookup_actions_p.action LIKE 'CC%' and tourney_hand_player_statistics.position = 9 and tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

"cnt_p_limp_faceraise_copy" column:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise and lookup_actions_p.action LIKE 'CC%' and tourney_hand_player_statistics.position = 9 and tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

The whole stat expression:
(cnt_p_limp_call_copy / cnt_p_limp_faceraise_copy) * 100
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 18 guests

cron
highfalutin