Was wondering what the coding is in PQL on propokertools to figure out what the probability is someone with KKxx single and double suited flops a set and/or flush draw?

Thanks

select count(
flopHandCategory(Hero)=flopset
or fourFlush(Hero,flop))
from game='omahahi', Hero='KK$ds,KK$ss'

(FourFlush is a special function which evaluates to True is the player has a 4-flush on the given street. This can't be obtained by using flopHandCategory because it returns only made hand categories like flopsecondpair, flopbottomtwo etc.)

This counts what you told to, but you should be cautious in your wishes because I guess you don't want to play KK suited not to a king and wouldn't mind flopping anything better than a set . Also, you probably wanted to do separate calculations for KK double suited 'KK$ds' and for KK suited to a king 'KxKyyz' (x,y,z refer to an arbitrary triple of different suits). So it should be more like that:

select count(
flopHandCategory(Hero)>=flopset
or fourFlush(Hero,flop))
from game='omahahi', Hero='KxKyyz'

perfect, thanks.

whats the answer?

^?

I thought you knew how to use PQL, MFN. If you don't have Odds Oracle Pro version, go to http://propokertools.com/pql, open the 'PQL runner' tab there and copypaste a query (like the first and last paragraphs of my previous post) into the form. If you have Oracle Pro, do the same in its PQL Interpreter with more accuracy.

You'll get smth like a 38% chance to flop a set+/FD for ds KK (replace 'KxKyyz' by 'KK$ds' in my second query) and 26% for KK** suited to the king, which is a striking difference. It depends on connectivity, though.

No I don't kow how to use PQL and don't really want to.

That number is higher than my estimate which was 34%. Its all about the calibration.

thx