PioR0T wrote:does anyone have any idea how this can be done?
See
this guide for the basics on custom statistics creation and
this guide for a deeper walkthrough. The latter was written for PokerTracker 3 but the techniques all apply to PokerTracker 4, the interface is just slightly different.
PioR0T wrote:based on the types of boards
You can do lots of things depending on what you want. For example board cards can be tested in many ways - a flop that has no card higher than a 6 looks like this:
- Code: Select all
cash_hand_summary.card_1 % 13 BETWEEN 1 AND 6 AND cash_hand_summary.card_2 % 13 BETWEEN 1 AND 6 AND cash_hand_summary.card_3 % 13 BETWEEN 1 AND 6
This post has more information on how the modulo function works. You can also test based on the players hand strength when their cards are known e.g. having a flush draw. -
this post lists all the
id_x_hand_strength values.
PioR0T wrote:and make a difference between SRP
If you mean a single raised pot that can be done with:
- Code: Select all
char_length(cash_hand_summary.str_aggressors_p) = 2
This post has information on how the actors and aggressors strings work.
This thread and
this thread discuss how you can compare/test the strings and for more detail on pattern matching in PostgreSQL such as LIKE, SIMILAR e.t.c see
this guide.
PioR0T wrote:and MW.
If you mean multiway then that can be tested whether by the number of players on each street. For example 3 or more players looks like:
- Code: Select all
cash_hand_summary.cnt_players_x >= 3
where x is the street identifier (p, f, t, or r).