call flop cbet fold turn cbet

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

call flop cbet fold turn cbet

Postby GORANBAXY » Sat Nov 27, 2010 5:18 pm

Is there a stat that tell us this: call flop cbet fold turn cbet

So basicly, how many times player have called cbet on flop and folded on turn / call flop & turn cbet
GORANBAXY
 
Posts: 65
Joined: Mon Jun 01, 2009 1:50 pm

Re: call flop cbet fold turn cbet

Postby kraada » Sat Nov 27, 2010 5:47 pm

There isn't a stat that does exactly that, but you could certainly build one to do it.

You'd want to build two new columns:

cnt_call_f_cbet_fold_t_cbet: sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.enum_t_cbet_action = 'F', 1, 0])

cnt_call_f_cbet_face_t_cbet:sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])

You can use these to then build the stat you want. For more on creating custom statistics please see the Tutorial: Using Custom Statistics and Reports.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: call flop cbet fold turn cbet

Postby GORANBAXY » Sun Nov 28, 2010 1:35 pm

I'm geting an error while validating the any column, error is: "The statement is not valid SQL"
GORANBAXY
 
Posts: 65
Joined: Mon Jun 01, 2009 1:50 pm

Re: call flop cbet fold turn cbet

Postby kraada » Sun Nov 28, 2010 2:33 pm

Both expressions are validating for me - note that the bit before the : is the name of the proposed new column.
kraada
Moderator
 
Posts: 54430
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: No registered users and 0 guests