Stat Help, % Raise in SB Btwn Eff BBs

[Crzzy2000]

Hello,
I'm quite new to custom stat creation so bare with me.
I'm trying to create a stat that gives me the Unopened SB Raise % BETWEEN the blinds of 5.5 and 7.5 and for 3-6 handed(not HU)

I understand that I have to create columns first.

cnt_pfr_SB_35_55

sum(if[tourney_hand_player_statistics.cnt_p_raise > 0 AND NOT
(tourney_hand_player_statistics.flg_p_limp) AND
lookup_positions.flg_sb AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 3.5 and 5.5, 1, 0])

cnt_hands_SB_35_55

sum(if[tourney_hand_player_statistics.id_hand > 0 AND
lookup_positions.flg_sb AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 3.5 and 5.5, 1, 0])

Stat:
(cnt_pfr_BTN_35_55 / cnt_hands_BTN_35_55) * 100

I think i must be doing something wrong because when i run this stat in reports and the % output in way too low.
What am i doing wrong?

Also, how would i do this for the BTN/CO/MP/EP?

Any help would be much appreciated!

[kraada]

If you want open raise you want to model your columns off of those for Raise First In, not PFR - PFR counts any raise not just opens.

Also you haven't added anything to specify 3 to 6 handed (which you could do with tourney_hand_summary.cnt_players BETWEEN 3 and 6).

If you're using this in the HUD though you don't need to specify position in the stat - just build a generic stat and change the Position value to the position you want to see - then you can set it to SB/BTN/CO/MP/EP and get every option for 6 handed.

[Crzzy2000]

Ok, so is this column what im modeling after:

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0])?

How do i combine that with BB BETWEEN 3.5 and 5.5 AND tourney_hand_summary.cnt_players BETWEEN 3 and 6?

[Crzzy2000]

I think i figured it out, can you tell em if this looks right?

cnt_p_raise_first_in_35_55_4_6
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 3.5 and 5.5 AND
(tourney_hand_summary.cnt_players) BETWEEN 4 and 6, 1, 0])

cnt_hands_SB_35_55_4_6
sum(if[tourney_hand_player_statistics.id_hand > 0 AND lookup_positions.flg_sb AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 3.5 and 5.5 AND
(tourney_hand_summary.cnt_players) BETWEEN 4 and 6, 1, 0])

(cnt_p_raise_first_in_35_55_4_6 / cnt_hands_SB_35_55_4_6) * 100

[Crzzy2000]

Hmm, it still doesn't work I'm doing something wrong.

[WhiteRider]

You're checking for being in the SB in the cnt_hands column but not in the raise-first-in column - try removing that check. As Kraada said earlier, you don't need to check position in your stat, you can do that in the Hud setup via the properties.
You also don't really need the id_hand bit either since you're checking other things - that is only needed when you're not checking any other conditions.

[Crzzy2000]

ok so i tried this:

cnt_p_raise_first_in_09_11

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])

cnt_hands_09_11

sum(if[tourney_hand_player_statistics.flg_p_open_opp AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 9 and 11, 1, 0])

(cnt_p_raise_first_in_09_11 / cnt_hands_09_11) * 100

When i Go to reports, it says this is at 59.86% which is impossible.
If this is truely ALL hands that i first open with at 9-11 BBs theres no way it can be 60% when my overall vpip at 9-11 BB should be less than 30.

Furthermore if i add the line:
AND (tourney_hand_summary.cnt_players) BETWEEN 4 and 6
i get a out put of "-"

I cant seem to isolate the problem.

[kraada]

Try adding that stat (without the players data) to a report grouped by Position - does it look right for the various positions? It's possible that everyone else is opening so much that despite your much lower VPIP when you get a chance to open you do so at a high rate.

[Crzzy2000]

I figured it out, i accidently had some filters in my reports. (Doh)
If I use the # of players filters in the Hud Options Configuration does that filter on top of my hud stats?
So for example if i have custom stats for 3-6 players, will my hud filter for 3-3/ 4-4/ 5-5 /6-6 if i set those perimeters in the Configuration?

[WhiteRider]

The Hud Options for 'number of players filtered' are applied to every stat.
If you have a custom stat which limits its data to hands when there were between 3 and 6 players, then you will only see data when the 'number of players filtered' ranges overlap.
e.g. When there are between 3 and 6 active players (even if you split it up as 3-3, 4-4, 5-5, 6-6) you will see the data you expect, but if you're in a range of 7-10 then you wouldn't see any data.
If you have a range 5-8 (for example) and the number of active players falls in that range the stat would show you data from hands where there were either 5 or 6 players. This is because the stat range rules out hands with 7 or more players and the Hud filter range rules out those with 4 or less players.

Simple answer - it should work as you expect. :)