Tournament starting stack?

[erdnase17]

Is the tournament starting stack size stored in some database table?

Thanks.

[kraada]

Yes. Absolute stack size is tourney_hand_player_statistics.amt_before. Effective stack size is tourney_hand_player_statistics.amt_p_effective_stack.

[erdnase17]

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?

[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.

[erdnase17]

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

[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.