Creating a new stat

[luis111angel]

Hey there:

I`d to create the statistic: "3Bet vs ISO", thing is that it´s getting harder to create this column since it needs to be a limper and then a 2Bet, could you please give me a hand creating this new stat?

Thanks in advance

[Flag_Hippo]

You can test and compare the aggressors and actors strings:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_actors_p) >= 2 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int != substring(cash_hand_summary.str_actors_p from 1 for 1) ::int

See this post for more information on how the actors and aggressors strings work. This thread and this thread have more information on comparing/testing the strings.

[luis111angel]

Amazing, thanks for such a response!

Now, i´m trying to create the stat "Straddle folds to a BB open raise"

My column:
sum(if[
lookup_actions_p.action LIKE '%S%'
AND lookup_actions_p.action LIKE '%F%'
AND cash_hand_player_statistics.val_p_raise_aggressor_pos=8
AND cash_hand_player_statistics.amt_p_2bet_facing > 0,
1,0])

Could you please help me creating the stat, i want it to not count if `BB raise with previous limpers` so i wonder how do i restrict the column to not count when there are limpers in the hand?

Thanks in advance for helping

[Flag_Hippo]

lookup_actions_p.action LIKE '%S%'
AND lookup_actions_p.action LIKE '%F%'

Straddling is a players first action so the first % prefix is redundant. Fold is always the last action so the % suffix is redundant but prefixing it with % will mean it will test for any preflop fold and the player may not fold to the open raise but later on preflop. You should test for an exact match on the lookup actions string and not separate the two:

Code: Select all

lookup_actions_p.action = 'SF'

cash_hand_player_statistics.val_p_raise_aggressor_pos=8

This will not necessarily be true in hands that were not folded. I'd recommend testing the aggressors string:

Code: Select all

cash_hand_summary.str_aggressors_p LIKE '88%'

want it to not count if `BB raise with previous limpers` so i wonder how do i restrict the column to not count when there are limpers in the hand?

Use what I provided for the isolation stat and change the comparison from not equals:

Code: Select all

!=

to equals

Code: Select all

=

[luis111angel]

So, the final column would be like this?

sum(if[
lookup_actions_p.action LIKE 'SF'
AND cash_hand_player_statistics.val_p_raise_aggressor_pos=8
AND cash_hand_summary.str_aggressors_p LIKE '88%'
AND cash_hand_player_statistics.amt_p_2bet_facing > 0,
1,0])

I don´t really understand much from creating columns, so could you please help me giving me the column i need? i`d really appreaciate it

Thanks in advance!

[Flag_Hippo]

Your custom statistic will need two columns. One that counts the folds and one that counts the opportunities to fold:

Code: Select all

sum(if[cash_hand_player_statistics.amt_p_2bet_facing > 0 AND cash_hand_summary.str_aggressors_p LIKE '88%' AND lookup_actions_p.action = 'SF' AND char_length(cash_hand_summary.str_aggressors_p) >= 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int = substring(cash_hand_summary.str_actors_p from 1 for 1) ::int, 1, 0])

Code: Select all

sum(if[cash_hand_player_statistics.amt_p_2bet_facing > 0 AND cash_hand_summary.str_aggressors_p LIKE '88%' AND lookup_actions_p.action LIKE 'S%' AND char_length(cash_hand_summary.str_aggressors_p) >= 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int = substring(cash_hand_summary.str_actors_p from 1 for 1) ::int, 1, 0])

[luis111angel]

Amazing! is working, thank you so much!

Could you please give me the columns for 3Bet - Straddle vs BB open raise ?

[Flag_Hippo]

You can use the same opportunities column for that. For the other column just change:

Code: Select all

lookup_actions_p.action = 'SF'

to

Code: Select all

lookup_actions_p.action LIKE 'SR%'