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

[TRNSLTR]

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.

[Flag_Hippo]

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.

[TRNSLTR]

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

[Flag_Hippo]

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.

[TRNSLTR]

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?

[Flag_Hippo]

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.

And after that I do the same for facereraise column.

Yes.

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.

[TRNSLTR]

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]

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.

[Flag_Hippo]

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.

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.

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

[TRNSLTR]

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