Building a Report based on River Board Texture

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Building a Report based on River Board Texture

Postby eric1099 » Wed Nov 17, 2010 3:02 am

I'm trying to build a Holdem Cash Hand report of my hands that by the river have a paired board with 3 or 4 of the same suit and also raising or facing a raise. I tried setting the simple filters with limited success as It seems to be focused on whether the board paired on the turn, flop, or river. Is there a way to filter the final board regardless of which street paired?

Thanks for any help you can provide.
eric1099
 
Posts: 9
Joined: Sat Jun 13, 2009 5:49 pm

Re: Building a Report based on River Board Texture

Postby WhiteRider » Wed Nov 17, 2010 5:01 am

Make sure that you have your filters linked together in the correct way - you will need to link the pair on each street with OR, for instance.
Tutorial: Filters

Can you tell us exactly what filters you are using?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Building a Report based on River Board Texture

Postby eric1099 » Sat Nov 20, 2010 10:35 pm

I think I have it now, thanks to the tutorial.

What I want to see is any hand that by the river has at least 3 flush cards and a paired board. I'm interested to see the hand strengths that will call or bet these boards. My filters are as follow now:

flg_showdown
amt_bb_won >=15 or amt_bb_won <= -15

--Simple Filters--
Any River Bet OR Any River Call
(River:4 Flush OR River: 3 Flush) OR Monotone Board OR (Turn:Four-Flush Board OR Turn: Completes Flush Draw)
(Board Paired, High or Board Paired, Low) OR (Turn: Pairs top card OR Turn: Pairs middle card OR Turn: Pairs bottom card) OR (River: Pairs top card OR River: Pairs middle card OR River: Pairs bottom card)
eric1099
 
Posts: 9
Joined: Sat Jun 13, 2009 5:49 pm

Re: Building a Report based on River Board Texture

Postby kraada » Sun Nov 21, 2010 9:54 am

That looks good to me.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: Google [Bot] and 10 guests

cron
highfalutin