Stats by effective stack size

[joker]

Hi,

is it possible to filter HUD stats by effective stack size? For ex. how many hands opponent raise 7-10bb deep?

Thank you for your answer.

[kraada]

That's not possible as a global HUD filter, but you could build custom stats for effective stack size if you so desire.

[joker]

Yes I want to do it! I already made some custom stats while ago so this should not be problem for me. Can you tell me which columns do I have to use?

[WhiteRider]

The effective stack preflop for a hand is stored in the database field: holdem_hand_summary.amt_p_effective_stack.
Please let us know if you need any more information.

[joker]

It shoved that I forgot almost all what I have learned about building a custom stat, can you pls provide me a little help here? Just tell me where to start and I will finish it with information already available on the forum. Thank you.

[kraada]

In the Configure Statistics window, duplicate the columns you need to create the stat you want - so for example if you wanted to do VP$IP with effective stack < 5bb you might duplicate cnt_vpip to cnt_vpip_eff_lt5. Inside the if statement add "AND holdem_hand_player_detail.amt_p_effective_stack < holdem_limit.amt_bb * 5" (without the quotes of course). Repeat for other columns. Then duplicate the stat on the stats tab and use the new columns instead (and change the name and description appropriately).

For tournaments you use tourney_holdem_hand_player_detail.amt_p_effective_stack and tourney_holdem_blinds.amt_bb

[joker]

Thank you, now I am able to create it and only have one more question - i want to build special stat for exact number of bbs, for ex. 5, not for "under 5bb", will it look like this ?

"AND holdem_hand_player_detail.amt_p_effective_stack < holdem_limit.amt_bb * 6 AND holdem_hand_player_detail.amt_p_effective_stack > holdem_limit.amt_bb * 5"

Thank you

[kraada]

That would work. You can use "=" instead as well but then it would have to be exact - a range of 1BB is probably a good amount for "exactly" since often a player will have a hair more or a hair less than any exact big blind number when their stacks get very small.

[joker]

It says that the statement is not valid SQL, can you pls check it and tell me, where I did a mistake ?

SUM(if[tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.position = 9,1,0 AND tourney_holdem_hand_player_detail.amt_p_effective_stack < tourney_holdem_limit.amt_bb * 8 AND tourney_holdem_hand_player_detail.amt_p_effective_stack > tourney_holdem_limit.amt_bb * 7])

Thank you.

[kraada]

You forgot the bolded bit:

SUM(if[tourney_holdem_hand_player_statistics.flg_steal_att AND tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.position = 9,1,0 AND tourney_holdem_hand_player_detail.amt_p_effective_stack < tourney_holdem_limit.amt_bb * 8 AND tourney_holdem_hand_player_detail.amt_p_effective_stack > tourney_holdem_limit.amt_bb * 7, 1, 0])

The 1 is what you get if it's true, the 0 is what you get otherwise.