Some of the most difficult decisions in poker can be made vastly easier if we know what hands our opponent plays in what fashions. Each hand we can eliminate will make our decisions that much easier.
(1) This information can take a very long time to approach accuracy. We only know our opponent's hand if he reaches showdown, so if our opponent limp/reraises 76s and AA in early position and only
shows down AA, our view of his limp/reraising hands would be inaccurate. While this is not a problem that we can resolve, it is worth noting that these popups will take quite a while to populate completely. That is not to say they are not useful however. I once played against an opponent whose Reraise hands showed just K5s and Q3o - when he reraised and I had AQ, I knew I should be very happy.
(2) There is a maximum number of custom columns that can be added to the PT3 system. The total number of columns cannot exceed 1600. Each chart for a situation will use 170 columns. As such, we need to consider carefully which charts are worth building and displaying.
(3) Each additional column extends housekeeping time. Unless you are doing large scale datamining, this will likely not be a problem, but it is worth mentioning.
For the purposes of this tutorial we will look to build those columns that would be needed in order to make a grid of hands shown down after limping.
Each hole card combination in the PT3 database is assigned a number from 1 to 169 for Holdem and 1 to 1820 for Omaha. For the purposes of this tutorial (and our sanity) we will only discuss Holdem. The same ideas can be extended to Omaha, though building the entire chart is obviously not possible as per caveat (2).
We need to know the value of the hole cards. The details on these values can be found in this post
Now we can start building. We can build cnt_limp_show_aa: sum( if[holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.id_holecard = 1, 1, 0]) then cnt_limp_show_aks: sum( if[holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.id_holecard = 2, 1, 0]) and so on. We also need to build cnt_limp_known: sum( if[holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_showdown, 1, 0]) - this is the number of hands that they have limped and reached showdown with.
Once we have all of the 169 hole card combinations built as columns, we can build the statistics: (cnt_limp_show_aa / cnt_limp_known) * 100 will be the percentage of hands that he player limped and showed that were AA. We have 169 of these to build - so it is a very tedious process.
With time and effort, though, you can build a popup that looks like this:
(click on the image to see the full size version)