River c-bet with big size stat

[Dan_Jazz_Man]

I'm trying to build a stat that would show which % of river c-bets that are big overbets are strong hands (at least top pair).
Somehow if I add this stat to a Player report it shows every player multiple times. Also, this stat stat does not seem to be available in the HUD.

Could you help me out here? Thanks!

[Flag_Hippo]

Code: Select all

sum(
  cast((cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_showdown AND val_r_bet_size = 8 AND flg_r_tp) as int
  )
)

1. You should use an if[] syntax instead of cast.
2. val_r_bet_size does not exist in the database schema. A players bet size as a percentage of the pot is cash_hand_player_statistics.val_r_bet_made_pct.
3. flg_r_tp does not exist in the database schema. You will need to test for the relevant hand strengths using cash_hand_player_combinations - this post lists all the id_x_hand_strength values.

This thread also has some more information on creating a similar type of custom statistic.

[Dan_Jazz_Man]

1. Switched to the if[] syntax but that didn't change anything - the report still shows every player multiple times
2. val_r_bet_size does exist in Statistics -> Columns. It's defined like this

Code: Select all

if[not(cash_hand_player_statistics.flg_r_bet), 0, if[cash_hand_player_statistics.val_r_bet_made_pct <= 25, 1, if[cash_hand_player_statistics.val_r_bet_made_pct <= 100/3 AND cash_hand_player_statistics.val_r_bet_made_pct > 25, 2, if[cash_hand_player_statistics.val_r_bet_made_pct <= 50 AND cash_hand_player_statistics.val_r_bet_made_pct > 100/3, 3, if[cash_hand_player_statistics.val_r_bet_made_pct <= 200/3 AND cash_hand_player_statistics.val_r_bet_made_pct > 50, 4, if[cash_hand_player_statistics.val_r_bet_made_pct <= 75 AND cash_hand_player_statistics.val_r_bet_made_pct > 200/3, 5, if[cash_hand_player_statistics.val_r_bet_made_pct <= 100 AND cash_hand_player_statistics.val_r_bet_made_pct > 75, 6, if[cash_hand_player_statistics.val_r_bet_made_pct <= 150 AND cash_hand_player_statistics.val_r_bet_made_pct > 100, 7, if[cash_hand_player_statistics.val_r_bet_made_pct > 150, 8, 9]]]]]]]]]

3. flg_r_tp is my custom column, defined like this

Code: Select all

NOT (cash_hand_player_combinations.flg_r_highcard OR
     (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3))

[Flag_Hippo]

1. Switched to the if[] syntax but that didn't change anything - the report still shows every player multiple times

I don't know what you are currently using but your custom columns will need to be in the following format:

Code: Select all

sum(if[expression, then, else])

The thread I linked you to in my original reply uses columns similar to the ones you will need.

2. val_r_bet_size does exist in Statistics -> Columns. It's defined like this

That is a database column and it does not form part of the database schema. Columns are built using elements from the database schema such as cash_hand_player_statistics.val_r_bet_made_pct which is being used in this column. Also this column is used to group statistics in a report so it's not suitable for what you are trying to create.

3. flg_r_tp is my custom column

You cannot reference columns in other columns. Columns are built using elements of the database schema. Statistics use columns. Please refer to this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. While the latter was written for PokerTracker 3 and the user interface is different the techniques still apply to PokerTracker 4. We have not published the schema like we did for PokerTracker 3 however you can find the files used to create the database in your PokerTracker4 installation folder:

C:\Program Files (x86)\PokerTracker 4\Data\Schemas

The meaning of database fields with the same names haven't changed in any significant way from PokerTracker 3.

PokerTracker 3 Database Schema Documentation

[Dan_Jazz_Man]

I was able to make the stat work, thanks for your help, Flag_Hippo