Largest Stack Stat

[N0L1M1T]

Hi,
I see live_tourney_table.min_stack but I also want to know the size of the largest stack still to act in the hand so I can make some "tournament life" risk evaluations. From looking at this it seems that a column, or colums, needs adding to the live_toruney_table table. Is that right? Does this mean that it's impossible for me to get that number?

This is something that confuses me about the custom column interface. Clearly there's no point in me manually adding a max_stack column to the live_tourney_table table because nothing will update it. Indeed I've also tried via the custom stat interface and it fails as it's not valid sql - the column doesn't exist in the db. So how do I go about creating a stat like this? Or is this something PT will need to add in a future update?

Regards,
David

[kraada]

PT4 does not know anything about the current hand in play as it unfolds so that data will not be available.

[N0L1M1T]

PT4 does not know anything about the current hand in play as it unfolds so that data will not be available.

But this is known from the end of the previous hand...


Regards,
David

[kraada]

You can know who was the largest stack from the last hand, but you can't know if they're still in this hand. If UTG is a 100BB stack and he folds and everyone else is 20BB deep you don't want to be using the 100BB number. And to know he folded we have to know something about the hand in play.

[N0L1M1T]

You can know who was the largest stack from the last hand, but you can't know if they're still in this hand. If UTG is a 100BB stack and he folds and everyone else is 20BB deep you don't want to be using the 100BB number. And to know he folded we have to know something about the hand in play.

I'm also not quite sure we're on the same wavelength here. The stats I'm interested in don't relate to the current hand at all - only prior hands. So, if I want to compose stats on shoves over limpers, for example, I'm interested in not just the stack size of the guy being raised but also the stack sizes of the players still to act. Effective stack size, while useful, doesn't tell me everything about how much risk I'm taking and how often that risk taking gets punished, or not.

I want to cook up a set of stats based on the effective stacksize of the active player vs the largest stack still to act behind. I'll use these in reports and perhaps in a HUD depending on how useful I think some of it is. Is that possible? If so how do i identify the size of the biggest stack behind and it's position?

Regards,
David

[kraada]

No data is stored about what players are behind you in the live table in the database; I'm afraid the data you are looking for is not available in the live tables.

[N0L1M1T]

No data is stored about what players are behind you in the live table in the database; I'm afraid the data you are looking for is not available in the live tables.

Ok. Can it be added? From what I see in the tables there seems to have been much more thought put into cash tables and fields vs. touneys. Is that being addressed?

And doesn't what you're saying also mean that the effective stack size stat cannot be accurate?


Regards,
David

[kraada]

Effective stack size is set at the time of your first action - if a deep stack early on raises and is still in you are effectively deeper than if he folded and you're left with a bunch of short stacks. Since it is set at the time of your first action and depends on who folds (or not) in front of you, we can't know until the hand is over (we being PT4, obviously you can do this math yourself) what your effective stack was.

I don't know of plans to add more data to the live tables at this time but it is possible that we will do so at some point in the future.

[N0L1M1T]

Effective stack size is set at the time of your first action - if a deep stack early on raises and is still in you are effectively deeper than if he folded and you're left with a bunch of short stacks. Since it is set at the time of your first action and depends on who folds (or not) in front of you, we can't know until the hand is over (we being PT4, obviously you can do this math yourself) what your effective stack was.

I don't know of plans to add more data to the live tables at this time but it is possible that we will do so at some point in the future.

I understand this - it makes sense. So ti seems that what I'm asking for is a new built-in stat that is the active player's effective stack size vs the largest stack of the active villains at the table. Does that, and why I'm asking for it, make sense? What is the mean lead time to implementing a new stat such as this?

While we're on the subject of stack sizes, can you also add a median stack size please? Average stack size is very misleading, especially in tournament situations.

[kraada]

If you mean in the Live table, I don't expect to see functionality like this any time soon (if ever) as parsing data while the hand is in play would be a massive change and could lead to potential problems with the poker sites. If you mean adding in extra stack related information to the database for use in reports later . . . it's more like, but when we change the database like that every PT4 user would have to reimport their hands in order to get the proper data in the database. As such I would not be holding my breath for that kind of change (maybe for PT5 we'd be able to make that kind of change).

Median stack size is something that's a lot more doable. This is the first request I've seen for it but I'll make a note of it and talk to the developers about it when I get a chance.