look up hole cards for omaha?

[Beng79]

Hi,

I'm trying to built a bunch of stats which show omaha hands for a range of pre-flop situations (eg. raise first in, 3 bet, 4 bet etc)

So far I have been using the columns holecard_1 through holecard_4 in cash_hand_player_statistics.
This works, and I've built some basic stats for things like 3 Bet AA**, however its extremely cumbersome - particularly for identifying ranges of hands

Is there any other simpler way of retrieving hole card values for omaha?
Can this be obtained from the column id_holecard?

Any help appreciated

[kraada]

There is a lookup table that lists all hands for Omaha. You can find it in the lookup_hole_cards table. The id_holecard value there is the same as id_holecard in the hand_player_statistics table. The way this works algorithmically is that id_holecard is 1 for AAAA, 2 for AAAK ... 13 for AAA2. 14 is AAKK, 15 is AAKQ and so on to AAK2 (25) then to AAQQ (26) and this continues to AA22 (91) then AKKK is 92 and so on throughout the aces then the first card becomes a king. There are 1820 total options so you'll forgive me for not listing them all here, but you can see the full list in the schema.postgres.sql file in the PT4 folder in Program Files (x86)/PokerTracker 4/Data/Schemas - just search for AAAA and you'll find it.

[Beng79]

hi
found the DB schema with all the listed hole card look up values for omaha
Thanks!