Fold to CBet Raise Turn validate plz!

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

Fold to CBet Raise Turn validate plz!

Postby js2002 » Sun May 10, 2009 6:32 am

Hi,

does this catch it correct?

sum(if[holdem_hand_player_statistics.flg_t_fold AND holdem_hand_player_statistics.flg_t_cbet,1,0])
__________________
sum(if[holdem_hand_player_statistics.flg_t_face_raise AND holdem_hand_player_statistics.flg_t_cbet,1,0])



ps for this stat a HU filter like mentioned in the "uptopia" thread. whould make a lot of sense. I think it should be possible to filter each stat on players = 2. similar to the new filter like "ep or lp ...."
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to CBet Raise Turn validate plz!

Postby kraada » Sun May 10, 2009 9:36 am

Yes that should work. When you say two players, do you mean two players who reached the turn or hands that start with only two players? You could catch either of these scenarios but you'd have to do them each differently.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to CBet Raise Turn validate plz!

Postby js2002 » Sun May 10, 2009 9:50 am

I know how to do them, my concern was more a "feature request", a new checkbox/selectbox in HUD setup at a stat.
In this box we could choose the No of players 2-10 at the street.
In another box we could choose the No of player 2-10 right from the beginning preflop.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to CBet Raise Turn validate plz!

Postby kraada » Sun May 10, 2009 9:58 am

You can do something similar with the Player Ranges section of the Hud Options tab -- you can set it so that you only see data from hands with X to Y players at the table when there are n players at the table when X <= n <= Y. So if you have it set to 7-9, any time there are 7-9 players at the table you see stats from those players in 7-9 handed spots.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to CBet Raise Turn validate plz!

Postby js2002 » Sun May 10, 2009 10:23 am

I know, that is not what I meant.

I have these player range filter:
0-2 2-2 3-3 4-4 5-6 for 6max tables

My thoughs/ideas were at filtering single stats to the no of player subset.

Ihink of the HUD setupview where you put the stat to the right scrollpane which adds then to a hud group.
there you click on a stat and can choose in a combobox 2 to 10 players.
NOW you hover over the stat and see 1. all 2. the session 3. *new feature* a subset of all filtert on no of players?

If you dont understand it now lets skype, this would be way faster.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to CBet Raise Turn validate plz!

Postby WhiteRider » Sun May 10, 2009 1:32 pm

I think there may be problems with that sort of thing - specific filters like that will probably prevent use of the cache, which will really slow things down.
There are plans for further HUD options, but I don't know exactly what will be done.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests