Flop Bet Opp

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

Flop Bet Opp

Postby spapia00 » Mon Mar 29, 2010 4:59 am

I want to know how many times a villain bets out of position on the flop when he called preflop raise (not 3bet+)of his opponent.
Also, want to see the same stat when he raise, opp 3bet, he called on the preflop.

P.S. Is this "Donk flop", right?
spapia00
 
Posts: 16
Joined: Fri Apr 04, 2008 3:42 am

Re: Flop Bet Opp

Postby kraada » Mon Mar 29, 2010 9:14 am

Donk Flop is for non-3-bet cases. To make a case for when you get 3bet change flg_p_face_raise to flg_p_3bet_def_opp in the column definition.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Flop Bet Opp

Postby spapia00 » Tue Mar 30, 2010 2:05 am

Where can I find the definition of Donk Flop?
spapia00
 
Posts: 16
Joined: Fri Apr 04, 2008 3:42 am

Re: Flop Bet Opp

Postby vicnice » Tue Mar 30, 2010 2:20 am

spapia00 wrote:Where can I find the definition of Donk Flop?


If you have the stat installed go to Configure---> Configure Stats----> Select the Sections tab---> Select Holdem Cash Player Statistics ---> Select the Statistics tab ----> Scroll down to Donk Flop and select it

You should be able to see the expression on the right: (cnt_f_donk / cnt_f_donk_opp)*100

It involves the columns cnt_f_donk and cnt_f_opp. To see the expressions for the columns select the Columns tab and scroll down to select them and you'll see the expression on the right. It basically uses several constructs and fields from the database to compute the number of opportunities a player had to donk bet the flop and also the number of times in which they did.

Just in case you don't know the naming conventions and stuff for the stats you can take a look here viewtopic.php?f=45&t=22599&p=111132#p111132
vicnice
 
Posts: 437
Joined: Tue May 20, 2008 5:56 pm

Re: Flop Bet Opp

Postby spapia00 » Tue Mar 30, 2010 5:08 am

Well, I'm using PT3 b30.08 and there is no "Donk Flop" in the statistics tab. Am I missing something?
spapia00
 
Posts: 16
Joined: Fri Apr 04, 2008 3:42 am

Re: Flop Bet Opp

Postby kraada » Tue Mar 30, 2010 10:18 am

Donk Flop will be built in automatically in Beta 30.9 - it's defined as when a player who just called preflop bets out of position before the preflop raiser can act in a singly raised pot.
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 2 guests