PokerTracker

Well I was so impressed with Kraada's New Hud Config, that I began a humble start on a version for Tourney's. I've started to create positional stats, but ran into a problem. Here is the sql. I can't for the life of me figure out why it won't validate. Any ideas?

sum(if[((tourney_holdem_hand_summary.cnt_players = 4 and tourney_holdem_hand_player_statistics.position = 1) or tourney_holdem_hand_summary.cnt_players = 5 and tourney_holdem_hand_player_statistics.position = 2) or (tourney_holdem_hand_summary.cnt_players = 6 and tourney_holdem_hand_player_statistics.position = 3) or (tourney_holdem_hand_summary.cnt_players = 7 and tourney_holdem_hand_player_statistics.position = 4) or (tourney_holdem_hand_summary.cnt_players = 8 and (tourney_holdem_hand_player_statistics.position = 4 or tourney_holdem_hand_player_statistics.position = 5)) or (tourney_holdem_hand_summary.cnt_players = 9 and (tourney_holdem_hand_player_statistics.position = 5 or tourney_holdem_hand_player_statistics.position = 6)) or (tourney_holdem_hand_summary.cnt_players = 10 and (tourney_holdem_hand_player_statistics.position = 6 or tourney_holdem_hand_player_statistics.position = 7))), 1, 0]

Art

Looks like you're missing a ( in front of the tourney_holdem_hand_summary.cnt_players = 5.

For what it's worth, I'm going to be working on this next (with hopefully a few other goodies for tournament players . . .). Not sure exactly how fast I'll be getting this out and it's good practice for you to learn anyway, but just saying . . . I haven't forgotten about tournament players

kraada wrote:Looks like you're missing a ( in front of the tourney_holdem_hand_summary.cnt_players = 5.

For what it's worth, I'm going to be working on this next (with hopefully a few other goodies for tournament players . . .). Not sure exactly how fast I'll be getting this out and it's good practice for you to learn anyway, but just saying . . . I haven't forgotten about tournament players

I took another look at it this morning, and noticed the missing (. However, it was rejected again as invalid. I agree with you that the practice is a great way to learn. Thanks for a great hud for cash. I have started to use it, and find it very easy to work with. With regards to an advanced hud for trny's, I will continue to work away on mine, but I look forward to seeing what all you may find important to include. After doing a quick research into what I may include, I came up with the following.

1. Monitoring vp@ip, pfr, ats, and rfi, as blinds increase.
2. T$@SD but maybe more importantly, BBwon/hand
3. Positional Stats to better understand play skill level, and steal attempts etc.

Apart some standard stats, have you considered any that would be more important than others to include?

Art

Instead of the read based stats popup, I'm planning on doing a breakdown of certain stats by M. I'll split it up into the zones that Harrington uses (red zone M < 5, Orange Zone M >= 5 & M < 10, Yellow Zone M >= 10 & M < 20, and Green Zone M >= 20) and put a bunch of stats by zone. That way someone who might be an uber nit in the green zone but a total maniac when short should come up and be easier to deal with. I'm not set on exactly what stats to include yet, but I'll probably include a good amount (VP$IP, PFR, Call PFR, Raise All-in PF, CBet Flop, WTSD . . . and whatever else strikes me as a good idea . . .)

sounds excellent.. looking forward to it

kraada wrote:Looks like you're missing a ( in front of the tourney_holdem_hand_summary.cnt_players = 5.

For what it's worth, I'm going to be working on this next (with hopefully a few other goodies for tournament players . . .). Not sure exactly how fast I'll be getting this out and it's good practice for you to learn anyway, but just saying . . . I haven't forgotten about tournament players

Kraada
the code for your cnt_hands_ep for the column is missing a ) at the end in your post
ie, holdem_hand_player_statistics.position = 7))) , 1, 0] (missing round bracket)

I went into Custom Stats and took a look at the statement there... and saw the round bracket.
Once I entered it into my own code for Holdem Tournament Player Statistics Column Tab the statement tested valid.
Thought I should mention it here in case others try to copy and past directly from your post.

Thank you for catching that; I've fixed that missing ) (and there was another one; I just reread things over to double check and found one more missing in that same spot). It should be working properly now and I apologize for the confusion.

kraada wrote:Instead of the read based stats popup, I'm planning on doing a breakdown of certain stats by M. I'll split it up into the zones that Harrington uses (red zone M < 5, Orange Zone M >= 5 & M < 10, Yellow Zone M >= 10 & M < 20, and Green Zone M >= 20) and put a bunch of stats by zone. That way someone who might be an uber nit in the green zone but a total maniac when short should come up and be easier to deal with. I'm not set on exactly what stats to include yet, but I'll probably include a good amount (VP$IP, PFR, Call PFR, Raise All-in PF, CBet Flop, WTSD . . . and whatever else strikes me as a good idea . . .)

Kraada I need some help. I've done the ground work in the column's tabs to build my mzone stat. I've tried putting it all together in the statistics tab. I have
sum(tourney_holdem_hand_player_detail.amt_ante)
sum(tourney_holdem_hand_player_detail.amt_before)
sum(tourney_holdem_hand_player_statistics.amt_won
sum(tourney_holdem_hand_player_detail.amt_blind)

In the trny statistics tab...((amt_before + amt_won) / ( amt_blind + amt_antes)) as value expression
In a previous post you wrote sum amt.before + amt.won / blinds and antes for mzone

Although this expression is valid, it is not giving me what I'm looking for. I took it for a test drive and I'm getting high numbers such as 300 or as the trny progresses 94. It seems to me that I need a way of converting the values into mzone categories such as <5 >=5 and <10 >10 and less than 20 and >20. I tried to use color conditions but when I try to enter >=5 and >10, it tells me that the value needs to be a boolean expression. I've tried to find what I'm looking for in the documentation, but I'm stuck.

Could you point me in the right direction?

Thanks
Art

I haven't read fully through this thread again, so forgive me if I missed something you already discussed, but a couple of thoughts...

Firstly, you will need brackets to do something like this:
amt.before + amt.won / blinds + antes
..because / is higher priority than +, so the above expression is actually doing this:
amt.before + (amt.won / blinds) + antes
..which could explain your strange values.

Also - why are you doing 'amt.before + amt.won'?
This gives you M for the next hand.

When you retrieve the blinds make sure you get them from the general limits, not the amount the player paid in blinds personally.

WhiteRider wrote:I haven't read fully through this thread again, so forgive me if I missed something you already discussed, but a couple of thoughts...

Firstly, you will need brackets to do something like this:
amt.before + amt.won / blinds + antes
..because / is higher priority than +, so the above expression is actually doing this:
amt.before + (amt.won / blinds) + antes
..which could explain your strange values.

Also - why are you doing 'amt.before + amt.won'?
This gives you M for the next hand.

When you retrieve the blinds make sure you get them from the general limits, not the amount the player paid in blinds personally.

Thank you for the input. I've made changes the changes. When you refer to retrieving the blinds from the general limits, are you referring to:
tourney_holdem_hand_player_statistics.id_blinds

if so, i was not successful with this expression.

Art