Custom stats considering specific sizes in BB

[juanchi]

Hello! My braing burning trying to create these stats. First I searched them on the download warehouse with no luck and now I'm trying to create the using chat gpt but also without luck. All the times there is some invalid code, either the stat, or a column or a variable. Do you have any idea how to work it out? I would be very grateful of any help.

- Call 3bet equal or greater than X bb
- Call from any position vs open raise or ROL equal or greater than X bb

[Flag_Hippo]

All the times there is some invalid code

If you have a column expression that is not validating then please copy/paste it here so we can see what's wrong.

[juanchi]

Thank you for your response.

for example I tried to create a stat that indicates the frequency of a player calling (from any position) an open raise or ROL equal or greater than 3,5bb.
So first I tried to create two different columns and both were invalid:

A. Times that a player calls an OR ≥ 3,5bb
Name: cnt_call_vs_open_3p5bb_cash

Expression:
sum(if[
cash_hand_player_statistics.facing_preflop_raise = true
and cash_hand_player_statistics.preflop_action = 'CALL'
and lookup_actions_p.raise_amount >= 3.5, 1, 0])

B. Opportunities to call an OR ≥ 3,5bb
Name: cnt_call_vs_open_3p5bb_opp_cash

Expression:
sum(if[
cash_hand_player_statistics.facing_preflop_raise = true
and lookup_actions_p.raise_amount >= 3.5, 1, 0])

[Flag_Hippo]

facing_preflop_raise
preflop_action
lookup_actions_p.raise_amount

Your column expressions are not validating because none of these terms exist in the PokerTracker 4 database schema. The schema for PokerTracker 4 hasn't been published but you can check the file used to create the database in your PokerTracker4 installation folder:

C:\Program Files (x86)\PokerTracker 4\Data\Schemas\schema.postgres.sql

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

PokerTracker 3 Database Schema Documentation