Hello fellow poker geeks! I have a new tool up at ProPokerTools in pre-release and wanted to open it up to a few more people. The tool can be found here:

ProPokerTools PQL

This new tool allows you to ask poker probability questions using a general-purpose query language. It is very much a work in progress.
As I always I welcome your questions and comments. I include an excerpt from the documentation below to whet your appetite.

- bachfan of ProPokerTools


If we want to know the equity of aces vs a random hand in holdem, we would write the following PQL query:

select avg(equity(hero, river)) as heroEquity from game='holdem', hero='AA', villain='**'

Let's suppose we want to know how often a hand with two aces in omaha which starts as a favorite on the flop gets outdrawn on the turn by a random hand, but then goes on to win the river. We can answer that with the following query:

select count(equity(villain, turn) > 0.5 and winsHi(hero)) as suckAndResuck
from game='omahahi', hero='AA**', villain='****'
where equity(hero, flop) > 0.5

The following query will tell you how often A2 gets quartered (or sixthed) in omaha-8 against two decent hands when it makes the nut low on a given board:

select count(tiesLo(hero)) as lostSomeChips
from game='omaha8', hero='A2**', board='8s7c5hKsJd', villain1='15%', villain2='15%'
where not (winsHi(hero) or tiesHi(hero))

This will show you what hand types (pair, two pair, etc.) win in holdem in a 9-handed random race:

select histogram(winningHandType())
from game='holdem', p1='**', p2='**', p3='**', p4='**', p5='**', p6='**', p7='**', p8='**', p9='**'

Looks pretty cool...Ill get back to you once I have some time to work w/ it a bit more.

-Mike

Nice work bachfan. Looks really nice.

Just saw this new feature. Looks very nice. Nice work bachfan! Now I just need to learn how to use it.

Me too! I'll be putting in some work soon to make the learning curve a little less steep.

- bachfan

Amazing, man! I worked a lot at it last hours lol I even sent a sugestion

Is there a space where we can discuss with other users about the commands? Here at this thread?

I have another suggestion, u have the command outsToHandType. Is it possible to create a command like nutoutsToHandType? I really loved this command!

And how about comands about the flop, like the number of times the flop would have some especific cards, or some specific card and another in a group of cards, ex: We have 5789 and we want to know how many times the flop would have 6 and or one of the 5, 7, 8 or 9, or the probability of hitting exactly 4 and 6 on the flop, for reasons of calculate the probability of flopping a wrap with the rundowns. I always remmber this when I think about the probability of flopping 2 exactly cards, that I think it is about 25:1, I'm not sure about that.

Very nice tool, I'm using a lot! And Im wainting for the ProPokerTools program!

Thanks bachfan and ProPokerTools!

looks really cool, will definitely check it out when i have more time

thanks!

I may have to bite the bullet and make my own ProPokerTools forum website.

As for new functions, yes, what you suggest is a good idea. I have a lot of good suggestions for new functions - I'll probably implement most of them in one form or another at some point.

The downloadable PPT will have PQL support, and will include some more user-friendly ways to construct custom queries.

Cheers,
bachfan

Just found out how to use PQL. I'm not very good at it, but like the way it can test simple short stack strategies!