Fol to Donk Flop needed

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

Fol to Donk Flop needed

Postby js2002 » Fri May 08, 2009 4:08 pm

Hi,

can somebody build it for us?
I got fold to donk turn and river but not flop.

holdem_hand_player_statistics.enum_f_donk_action='F'
and
holdem_hand_player_statistics.flg_f_donk_def_opp

dont exist.

Any ideas?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fol to Donk Flop needed

Postby kraada » Fri May 08, 2009 4:20 pm

cnt_f_donk_def_opp:

sum(if[lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT(holdem_hand_player_detail.flg_f_open_opp), 1, 0])

cnt_f_donk_def_opp_action_fold:

sum(if[lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'F', 1, 0])

Change from 'F' to 'R' for raise and 'C' for call. You can also find these stats in my HUD.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fol to Donk Flop needed

Postby js2002 » Sat May 09, 2009 4:49 am

1. Im little scared to import your cash HUD. Do you insure that this wont overwrite any stats or columns?

2. dont I need "NOT Cbet opp" as a check in both expressions or is it redundant?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fol to Donk Flop needed

Postby WhiteRider » Sat May 09, 2009 5:09 am

CBet-opp is redundant - if you didn't have an opportunity to open the flop then you didn't have an opportunity to c-bet.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fol to Donk Flop needed

Postby js2002 » Sat May 09, 2009 6:22 pm

thx, imported kraadas HUD and got several stats that I didnt develop. thx WR thx kraada
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


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

Who is online

Users browsing this forum: No registered users and 3 guests