C-bet to/from and column info

[OneKef]

Hi, after this 3d I'd like to have really understood the ''actions'' and ''opportunity'' (that's their name right?) columns...I think I'm lagging behind.

Meanwhile, HJ open, and BB call, BB check and HJ cbet...

Action

Code: Select all

sum(if[tourney_hand_player_statistics.position = 2 and tourney_hand_summary.str_aggressors_p = '82' and tourney_hand_summary.str_actors_p = '28' and  tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_f_cbet, 1, 0])

Opportunity

Code: Select all

sum(if[tourney_hand_player_statistics.position = 2 and tourney_hand_summary.str_aggressors_p LIKE '82' and tourney_hand_summary.str_actors_p LIKE '2' and tourney_hand_player_statistics.flg_f_cbet and  tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])

In addition to helping me with this, if possible, please link me something that makes me understand how and why to build these two oclumns, or explain it as you would have to explain it to your 11-year-old son :D

[OneKef]

Okay the strings are ''actions'' and ''opportunities.''
So I'll have to put in the second column just put the opportunity that what I want to happen (for example above here the cbet should be flg_f_cbet_opp).
In any case, and I also read my old posts and the guides you link to, this thing of positions vs. other positions is sending my brain into a tailspin :D
Non serve a nulla neanche mette ''player position'' se uso le stringhe aggressori/attori...

[OneKef]

Sorry, it slipped out in Italian:
''There is no use even putting ''player position'' if I use the aggressor/actor strings...''

[OneKef]

Good morning, I tried starting from the 3d on 3bet, needless to say I am not so sure it is correct.
BTN open and cbet vs BB SRP (deepness random)

Action

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet_opp and tourney_hand_player_statistics.flg_f_cbet and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '08%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

Opportunity

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet_opp and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

What do you think? :D

[Flag_Hippo]

Good morning, I tried starting from the 3d on 3bet, needless to say I am not so sure it is correct.
BTN open and cbet vs BB SRP (deepness random)

Action

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet_opp and tourney_hand_player_statistics.flg_f_cbet and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '08%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

1. When you are using tourney_hand_player_statistics.flg_f_cbet it's not necessary to also test for tourney_hand_player_statistics.flg_f_cbet_opp.

2. Your test for the aggressors and actors strings should not be using % as that can include hands with further preflop actions. You had this correct in your original post. A pot with a single BTN raise and BB call would be:

Code: Select all

tourney_hand_summary.str_aggressors_p LIKE '80' and tourney_hand_summary.str_actors_p LIKE '08'

Opportunity

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet_opp and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

Here you have removed the second number (8) from the actors string in the opportunities column (you also did this in your original post). This needs to be the same test as the actions column since preflop details have not changed. The only difference between the columns is the flop cbet vs the opportunity to flop cbet.

[OneKef]

:heart:

[OneKef]

So, if I wanted to make it also for sb it would become like this?

Code: Select all

tourney_hand_summary.str_aggressors_p LIKE '80' and tourney_hand_summary.str_actors_p LIKE '09'

[Flag_Hippo]

So, if I wanted to make it also for sb it would become like this?

Code: Select all

tourney_hand_summary.str_aggressors_p LIKE '80' and tourney_hand_summary.str_actors_p LIKE '09'

Combined with the expressions from above it would be for the BTN cbetting against the SB.

[OneKef]

Yep, sorry, what I meant :) thanks!!

[OneKef]

Hi
I seem to notice inconsistencies (maybe I'm wrong because I'm missing something though) from these stats I created to those that are already present.

For example:
CBet Flop from BTN vs BB 30x+

(cnt_f_cbet_btn_vs_sb_30_1000bb / cnt_f_cbet_opp_btn_vs_sb_30_1000bb)*100

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet and tourney_hand_summary.str_aggressors_p LIKE '80' and tourney_hand_summary.str_actors_p LIKE '09' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 30 and 1000, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_cbet_opp and tourney_hand_summary.str_aggressors_p LIKE '80' and tourney_hand_summary.str_actors_p LIKE '09' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 30 and 1000, 1, 0])


Did I miss something?