Page 1 of 1

Tournament starting stack?

PostPosted: Sun Nov 25, 2012 12:23 am
by erdnase17
Is the tournament starting stack size stored in some database table?

Thanks.

Re: Tournament starting stack?

PostPosted: Sun Nov 25, 2012 12:21 pm
by kraada
Yes. Absolute stack size is tourney_hand_player_statistics.amt_before. Effective stack size is tourney_hand_player_statistics.amt_p_effective_stack.

Re: Tournament starting stack?

PostPosted: Sun Nov 25, 2012 12:28 pm
by erdnase17
kraada wrote:Yes. Absolute stack size is tourney_hand_player_statistics.amt_before. Effective stack size is tourney_hand_player_statistics.amt_p_effective_stack.


amt_before is the player stack in the previous hand, I would like to know the starting stacks for that particular Heads up tournament. This information was available in PT3 as tourney_holdem_type.amt_chips.
How can I get this information in PT4?

Re: Tournament starting stack?

PostPosted: Sun Nov 25, 2012 3:04 pm
by kraada
There was no table tourney_holdem_type; I just looked in the schema. Perhaps you meant tourney_holdem_table using the live stats? If so the way to see that in PT4 us to use the built in column live_amt_stack. Also for HU play we also have live_table_min_stack which may be useful for you. These are only usable for the HUD and live play though.

Re: Tournament starting stack?

PostPosted: Sun Nov 25, 2012 3:14 pm
by erdnase17
kraada wrote:There was no table tourney_holdem_type; I just looked in the schema. Perhaps you meant tourney_holdem_table using the live stats? If so the way to see that in PT4 us to use the built in column live_amt_stack. Also for HU play we also have live_table_min_stack which may be useful for you. These are only usable for the HUD and live play though.


Then what is this table? https://www.pokertracker.com/guides/PT3 ... holdemtype

Re: Tournament starting stack?

PostPosted: Sun Nov 25, 2012 3:30 pm
by kraada
I looked in the actual schema PT3 uses to create databases and I did not see that table listed there. I do not know why it is listed in our documentation.