Create boards texture (columns)

[ZZMidway]

I'd like to create a list of boards in columns to use in stats, because there's nothing like that in columns/stats.

To see how much the aggressor c-bets ip in an SRP where 2 people have reached the flop, but what I need are the board textures.

- Monocolor flop
- Flop 2345 (i.e., low cards with only those cards played)
- Flop 9876 (same as above)
- Broadway flop (A-T)
- Double-card flop.

Thank you very much.

[Flag_Hippo]

The flop cards dealt in order are cash_hand_summary.card_1, cash_hand_summary.card_2 and cash_hand_summary.card_3 - this post covers the card values. If you start PokerTracker 4 with logging enabled (turn that on via 'Configure -> Options') you can check the PokerTracker 4 log file for these queries. To do that run a simple custom report and then add a built-in filter for the 'Board Texture' you want. Next select the 'File -> Open User Data Folder' option, go into the 'Logs' folder and open the 'PokerTracker4.log' file in a text editor. At the bottom of that file you can extract the SQL that was used for the query. For example this is the query used for a monotone flop:

Code: Select all

(cash_hand_summary.card_1 > 0 and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13))

This post has more information on how the modulo function works.