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

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

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

Postby Toddhoy » Sun Aug 04, 2024 8:55 am

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!
Toddhoy
 
Posts: 1
Joined: Fri Dec 05, 2014 11:38 pm

Re: Can't find betting information tables in database back-e

Postby Flag_Hippo » Sun Aug 04, 2024 12:46 pm

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
Flag_Hippo
Moderator
 
Posts: 15130
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 10 guests

cron