Can't find betting information tables in database back-end

[Toddhoy]

Hello, I have begun trying to access the Pokertracker 4 database via Python to do more detailed analysis. I have read the documentation here https://www.pokertracker.com/guides/PT3 ... umentation which relates to the PT3 database schema, which is still very similar to PT4.

Where I am stuck is finding the table holdem_hand_player_detail or any table or fields that have taken its place in PT4. I have inspected the database schema and cannot work out how bet sizes or other actions are stored for given hands.

The basic information seems to be in cash_hand_summary but I seem to be missing tables to join to hand_id for the additional info such as bet sizings. If somebody can point me in the direction of table names or what I am missing that would be great!


Cheers!

[Flag_Hippo]

That would be in cash_hand_player_statistics. Everything from the player_detail tables is in player_statistics in PokerTracker 4 (and holdem and omaha were combined).

The total amount a player bet (wagered) on each street is:

Code: Select all

cash_hand_player_statistics.amt_bet_x

where 'x' is the street (p for preflop, f for flop e.t.c.)

If you only want the players size of postflop bets only and not the total amount wagered then that would be:

Code: Select all

cash_hand_player_statistics.amt_x_bet_made

If you want the players postflop bet size as a percentage of the pot that would be:

Code: Select all

cash_hand_player_statistics.val_x_bet_made_pct