A high flops

[jynxy]

Would it be possible for someone to whip up a set of stats for A high boards such as bet, check/raise, check/fold, fold to cbet?

I'd do it myself but it is damn confusing!!

[kraada]

I don't have a set of stats for you handy at the moment, but I can give you the piece of SQL you need in order to build these.

Adding:

(cash_hand_summary.card_1 % 13 = 0 OR cash_hand_summary.card_2 % 13 = 0 OR cash_hand_summary.card_3 % 13 = 0)

to an existing column will get you the value for that column when the flop contained an ace. This also works for turn and river (using card_4 and card_5 respectively) should you be interested.

The numerics for these cards counts up starting with the 2c (so 2c = 1, 3c = 2 ... As = 52). As a result we can use modulo (%) to get cards that are a specific rank - modulo gives you the remainder after dividing. So for example 8 % 3 = 2 or 14 % 13 = 1. Since there are 13 cards in each suit we use % 13 to map each rank of card to a single number - aces are 0, deuces are 1, treys are 2 up to kings which are 12.

I hope that helps, and if I get some time I'll try to build and attach some of these to this thread for you.