[HELP] UTG raise when 7bb or less

[scoker]

Hi!

Could someone help me with following stat:
I would like to have in my tourny hud stat representing raise(can be AI) from UTG when he has 7 big blinds or less...

[kraada]

Create two new columns:

cnt_p_utg_raise_when_short: sum(if[tourney_holdem_hand_player_statistics.position = (tourney_holdem_hand_summary.cnt_players - 3) and tourney_holdem_hand_player_statistics.flg_p_first_raise and (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb) <= 7, 1, 0])

cnt_p_utg_open_opp_when_short: sum(if[tourney_holdem_hand_player_statistics.position = (tourney_holdem_hand_summary.cnt_players - 3) and tourney_holdem_hand_player_statistics.flg_p_open_opp and (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb) <= 7, 1, 0])

Put the former over the latter, and multiply by 100. This will give you the percentage of the time he raises UTG (regardless of table size) given that he has 7bb or less. For more on creating custom statistics please see the Tutorial: Using Custom Statistics and Reports.

[scoker]

Thanks a lot!
I think its working properly:) One thing theres mistake with braces it should end "])" not like ")]".

I have one more question. Could you tell me if there is a way to filter stats by big blinds rather than current blind level?

[kraada]

I fixed the braces order in the post above - thanks for pointing that out.

Could you elaborate a little more on what you mean by filtering to big blinds?

[scoker]

You can choose for tounament hud to filter all stats by blinds level (configure->configure hud->hud options tab and in filters you have option Stats from current tournamet level only).
Now i would like to have filters that sort things by big blinds (not by blinds level) for example:
I want to make following ranges:
0 - 5bb
6 - 10bb
10 bb and more
and now for blind level 50 - 100 where u have 400 in your stack will appear same stats as you are on blind level 120 - 240 and 700 in your stack.



And another question is: can I bind blind levels? For example now i have stats for 30-60 blind level and seperate stats for 25-50 blind level. I would like to merge those two blind levels and have only one stats for those levels.

[kraada]

You could split custom stats down into these divisions if you would like but there is no function in the software to do it for you automatically like it can for blind levels. This sort of feature has been requested previously and is on the list for our development team to consider for the future.