Stuck in stat making process

[Gster]

I'm looking to make a stat that follows the following description: The amount of times player 3-bet from blinds vs button or cutoff
over the amount of times player had the opportunity to 3-bet from blinds vs button or cutoff.

This is the "Raise vs Steal Att" stat and I chose this as a basis from which to work from
((cnt_sb_steal_raise + cnt_bb_steal_raise) / (cnt_steal_def_opp_bb + cnt_steal_def_opp_sb)) * 100

I realize that I'm just looking to tweak the traditional definition of "steal" by excluding the "SB" part.

-Am I right in thinking that I only have to modify the columns regarding the big blinds given the description I'm aiming to achieve?

and finally, is there a way to say the following... (face sb steal attempt)=false
that way I can just plug it into the boolean.

Thanks

[WhiteRider]

Yes, you will need to build new versions of the columns for the situation you want to count.
To count times that you face a steal which is not from the small blind you can use an expression like this:

holdem_hand_player_statistics.flg_blind_def_opp AND NOT (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9)

There is a section on creating new versions of stats in the Tutorial: Custom Reports and Statistics.

[Gster]

I think I finished the stat the way I want it but unfortunately I don't know of any good way to test to see if it's working properly.

Could you please tell me if this stat follows the following description:
"The amount of times player 3-Bet from Blinds vs Button or Cutoff steal attempt over the amount of times player had the opportunity to 3-Bet from Blinds vs Button or Cutoff steal attempt."

((cnt_sb_steal_raise + cnt_bb_steal_raise_btn_cutoff) / (cnt_steal_def_btn_cutoff_opp_bb + cnt_steal_def_opp_sb)) * 100

I have 2 original columns these are:
1)cnt_sb_steal_raise
2)cnt_steal_def_opp_sb
I didn't feel I needed to change these as you will never face a steal raise from the sb when you are sb yourself

...and 2 custom columns (modified Raise vs steal attempt)
1)cnt_bb_steal_raise_btn_cutoff

sum(if[ holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.cnt_p_raise > 0
AND NOT (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9), 1 , 0 ])

2)cnt_steal_def_btn_cutoff_opp_bb

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b
AND NOT (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9), 1, 0])

Please let me know if it's working or if I have to change something.
Thank you =D

[kraada]

I think that should work properly.

[Gster]

Thx kraada,

I notice I have a difficulty making sure that my custom stats are working properly after I finish making them.
Could I perhaps post up a few more in this thread to get your stamp of approval? =D

Thanks again guys

[WhiteRider]

Sure, post away.

The method I use to test stats I'm not sure about is described here.

[Gster]

Does the below match the following description: The amount of times the player made a raise from the button or cutoff when folded to over
the amount of times the player had the opportunity to make a raise from the button or cutoff when folded to.

(cnt_steal_att_btn_or_co / cnt_steal_opp_btn_or_co) * 100

I have 2 custom columns
1) cnt_steal_att_btn_or_co

sum(if[holdem_hand_player_statistics.flg_steal_att AND (holdem_hand_player_statistics.position=0 OR holdem_hand_player_statistics.position=1), 1, 0])

2) cnt_steal_opp_btn_or_co

sum(if[holdem_hand_player_statistics.flg_steal_opp AND (holdem_hand_player_statistics.position=0 OR holdem_hand_player_statistics.position=1), 1, 0])

[kraada]

Yes that will work. You can also use the default stat "Att to Steal" in LP in the HUD for the same results.

[Gster]

Would they really yield the same results all the time?

If I were to do it the way you suggested wouldn't it follow the table whiterider posted in one
of his tutorials? (the one that changes the definition of what is considered LP MP and EP based on the amount of players seated at the table)

Because if that is the case doesn't that mean that the stats won't necessarily match the one's I posted?
For example: In a full ring game of 9 players wouldn't the Hijack also be taken into account because it would be considered "LP"?

I'm under the impression that because I included this "(holdem_hand_player_statistics.position=0 OR holdem_hand_player_statistics.position=1)"
in the boolean the positions I'm taking into account remain static in other words the position 0 and 1 will always represent the button and the cutoff respectively.

Please let me know if I'm making sense or if I'm missing something.
Thanks

[kraada]

Oh good point - with 4 or fewer players this will be different.