Page 1 of 3

set of stats for wet/dry flops

PostPosted: Thu Dec 26, 2013 8:44 pm
by Mushmellow
Is there a way I can get a specific cbet stat for wet flops and one for dry flops? How would I go about doing this. I saw on Ben Sulsky's hud he has this so I know it's possible I'm just not sure how to do it.
Thanks!

Re: set of stats for wet/dry flops

PostPosted: Fri Dec 27, 2013 9:48 am
by kraada
You'd need to define in code exactly what makes a wet flop and what makes a dry flop. Once you have that definition you can add it in to new versions of the columns that already exist to build the standard stats and then you'll get the information you want. This kind of building is probably one of the toughest types of things to build.

Re: set of stats for wet/dry flops

PostPosted: Sun Jan 05, 2014 10:28 am
by Mushmellow
Thanks so much for the help. So basically I'd have to do something like:
-manually code out all the permutations of dry flops (assuming there is more dry flops then wet flops)
-do NOT dry flops (to get all the other flops I deem as wet)

Then, build out that stats and create my own stat and add it to HUD?

Cheers!

Re: set of stats for wet/dry flops

PostPosted: Sun Jan 05, 2014 10:38 am
by Mushmellow
Ok I just researched how to build the columns via this link
https://www.pokertracker.com/guides/PT4 ... e#overview

Could you give a small example SQL code that I need to write to let's say program "dry flop" as only consisting of K :spade: 5 :club: 2 :diamond: ?

Once I have this I'm going to write a Python script to generate all the permutations, but I need help with just doing this simple version first.

Re: set of stats for wet/dry flops

PostPosted: Sun Jan 05, 2014 12:25 pm
by WhiteRider
Board cards are stored in the database fields "cash_hand_summary.card_1" to "...card_5" - 1 to 3 are the flop, 4 is the turn and 5 is the river.
The values stored in these fields represent the individual cards - details in this post (this was written for PT3 so the database fields are different but the values are the same in PT4).

You can compare the three flop card values to determine whether the board is wet or dry using mathematical functions (a few simple examples in the linked post) depending on how you define wet or dry. e.g. By checking that each card is a different rank, there is a certain gap between cards, or they are different suits, etc. These expressions will likely get pretty complex, but it sounds like you have a grasp of how to do this kind of thing.
If you get stuck with a specific example please ask.

Re: set of stats for wet/dry flops

PostPosted: Mon Feb 17, 2014 3:25 pm
by js2002
Hi,

did anyone make some wet/dry stats für PT4?

I want to filter things like that:

"two cards of the flop are 'near' to each other" ==> 'near' means: They only have a gap <= 2 cardranks f.e.
So, If I do this as PT4 expression, I could check some fields like 13 (Ace) gap to 11 (Q) is 'true' on 'near'.
Do I have to check 26 gap to 22 also? and so on?

Re: set of stats for wet/dry flops

PostPosted: Mon Feb 17, 2014 3:39 pm
by kraada
That certainly is doable. I don't recall anybody having posted a large set of them.

Re: set of stats for wet/dry flops

PostPosted: Mon Feb 17, 2014 3:57 pm
by js2002
Let's see what I can do :-)

Re: set of stats for wet/dry flops

PostPosted: Wed Mar 12, 2014 8:40 am
by js2002
plz take a look:

http://gyazo.com/329cb55ca3c48f9a9dbf7749509fe834

how do I address these filters in columns?
EDIT: I found the complex expression in the logs, but its way to hard to find you whcih one is for what....
So, are there flags for these?

Re: set of stats for wet/dry flops

PostPosted: Wed Mar 12, 2014 11:02 am
by kraada
There aren't flags for these, and they need to be built out of the existing data. If you use just one filter at a time you might be able to see better how these things are built.

highfalutin