Hello,
I would like to make a board texture report but don't know how to code board textures.
For example:
If I wanted paired boards in 3bet pots, how would i code this?
"3bet or 3bet_def_opp and ???"
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
Flag_Hippo wrote:If you start PokerTracker 4 with logging enabled you can check the log file for these queries. To do that run a simple custom report with only the 'Hands' stat and then add a simple filter for the 'Board Texture'. Next select the 'File -> Open User Data Folder' option and 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 - the relevant parts for the flop cards are cash_hand_summary.card_1 through to cash_hand_summary.card_3.
Evoke_89 wrote:If we don't care about the third flop card, there are 13 possible paired boards.
Evoke_89 wrote:So to do this i need to replace the "???" with something
Flag_Hippo wrote:Evoke_89 wrote:If we don't care about the third flop card, there are 13 possible paired boards.
Each individual card can be dealt first, second or third on the flop so you can't ignore the third flop card and there are 468 possible paired boards (not counting all possible combos of the unpaired card):
Ac Ad x, Ac x Ad, x Ac Ad, Ad Ac x, Ad x Ac, x Ad Ac, Ac Ah x, Ac x Ah e.t.c
but the expression won't be as long due to the use of a modulo operator.Evoke_89 wrote:So to do this i need to replace the "???" with something
I explained how to get the code you need in my original reply - see here for an example.
(((((((cash_hand_summary.card_1 > 0 and ((cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13) OR (cash_hand_summary.card_1 % 13 = cash_hand_summary.card_3 % 13) OR (cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13))))))) AND ((NOT (((((cash_hand_summary.card_1 > 0 and cash_hand_summary.card_1 % 13 = cash_hand_summary.card_2 % 13 and cash_hand_summary.card_2 % 13 = cash_hand_summary.card_3 % 13)))))))))
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: fingerdance, Google [Bot] and 23 guests