Advanced Hud Config for Tourney's

[kraada]

You're both very welcome; I can also confirm that the issue that caused the .pt3hud file to break will be fixed for the next release. I'm still not sure if it's on the export side or the import side, but from the sounds of it, either way there'll be a working version of my HUD out there in the not too distant future.

preparac:

I just took another look at the columns for limp/fold and it does look like there may have been an error there.

Look at cnt_limp_fold_rz, do you have this:

Code: Select all

sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='F

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) <= 5)


', 1, 0] )

?

If so, you need to edit it so it looks like this:

Code: Select all

sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='F' and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) <= 5)

, 1, 0] )

(Put the ' on the other side of the F, add an 'and', remove the ' before the ,)

I'm not sure how it got like that, but it's obviously checking for the string to match that . . . which is never going to happen, hence a value of 0. You'll need to recache after the fix, of course, and anybody else who downloaded these stats with the HUD should make these fixes as well to all cnt_limp_fold_Xz columns. My apologies for the typo.

[foldyhawn]

Kraada, your HUD is very advanced and shows what is possible with PokerTracker and its stats. I'm still working on removing the tourney_tourney typos, so i can try it out in the wild.

But actually I am still looking for a "simple" mzone stat. Your advanced HUD takes the mzone onto an even higher level than i want it to be, so i thought i could just "take" your piece of the stat that calculates the mzone. Unfortunately that doesn't work and I can just not figure out why. As far as i can see it can be calculated inside a stat, why can it not just be a stat on itself, or am i doing things the worng way.

If this:

((tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) <= 20)

evaluates to true or false depending on the outcome of

tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante))

should produce a number, otherwise how can it be evaluated.

So I added the piece above in the Columns, just like the other stats but it doesn't

Can anyone confirm that it doesn't work (or am i the only wanting to have an mzone stat?)?

I added all the columns and tried them as stats, that didn't work either.

Regards

[WhiteRider]

You can't build an M stat this way. What Kraada is doing is seeing how often each player does certain things when their stack is within a certain zone - across all hands.
I guess what you want is to see M for a specific hand?
You can do this, but you can't display it on the HUD (because HUD stats are based on all of a player's hands, not the current hand), and the stat would have to be in the Holdem Tournament Hands section.
I built this stat and it is available in the Repository, but you can only use it in reports for analysis.

[foldyhawn]

Well i do hope it will be in a future version on poker tracker as it is a kinda important stat in tournaments. And if it can be used in the calculation of one stat it does mean it can be calculated. Its probably because certain data is in a different group, so far i can understand the logic. However if you can use column a to calculate stat x, why is it not available in another stat. I mean there is an outcome in the stat kraada produced, it must evaluate to something. Its in the players group so it seems to be usable in the player statistics.

Well i only understand half of why it shouldn't be available, and since it doesn't work i guess debating it is kinda useless . I can only hope the dev team does something with it in the near future, so i'm going to check the feature requests see if a request is already there.

thanks for the reply

[kraada]

Let me explain what happens when a HUD stat is calculated and maybe that will clarify:

The only stats that can be displayed on the HUD are stats in the Player Statistics section (this is true for both cash and tournaments). When columns in this section are created they are created by looping over every hand in the database and calculating that column's total value. So you can't just tell the HUD to look at the last hand. You can tell the HUD to look at every hand, and add up the time someone's M was in a given range and see what they did (which is what I did in the HUD). There are other stat sections that you can use in reports, like the Hand section, which you can use to look at the M of a person in each specific hand. But you can't display that information on the HUD, and I don't expect that you'll ever be able to display information from this section on the HUD.

Does that help a bit?

[preparac]

I just took another look at the columns for limp/fold and it does look like there may have been an error there.

Look at cnt_limp_fold_rz, do you have this:

Code: Select all

sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='F

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) <= 5)


', 1, 0] )

?

If so, you need to edit it so it looks like this:

Code: Select all

sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='F' and

(tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) <= 5)

, 1, 0] )

(Put the ' on the other side of the F, add an 'and', remove the ' before the ,)

I'm not sure how it got like that, but it's obviously checking for the string to match that . . . which is never going to happen, hence a value of 0. You'll need to recache after the fix, of course, and anybody else who downloaded these stats with the HUD should make these fixes as well to all cnt_limp_fold_Xz columns. My apologies for the typo.

Kraada, you tested this adjusted stat? ... I made your adjustment but I still get the same 0.00% results ...

[kraada]

It's the same limp/fold stat I use in the cash game stats all the time and I know it works there.

I'll do some more testing to make sure this works, but I can't see why it wouldn't. You obviously need to make the changes to the oz, yz, gz and bz columns too, and you'd need to recache if you want to get the historical data up to date also.

[preparac]

yes I forgot to update the cache. My mistake. Everything works fine with your adjustments

[kraada]

Glad to hear it, you had me worried for a minute

[R3mbrandt]

When will the downloads possible again?