set of stats for wet/dry flops

[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!

[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.

[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!

[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 5 2 ?

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.

[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.

[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?

[kraada]

That certainly is doable. I don't recall anybody having posted a large set of them.

[js2002]

Let's see what I can do

[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?

[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.