CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

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

CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 4:17 am

THIS IS WHT I FIND IN CNT_F_DONK:
sum(if[holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.flg_f_bet AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position),1,0])

BUT IF I MAKE A 4BET AND THE VILLAIN RERAISE AGAIN AND I CALL, IF ILL LEAD OUT ON FLOP (BEING OOP), MY ACTION IS A DONK BET NOT COUNTED BY THAT CNT_F_DONK.
WOULD BE MORE ACCURATE IF:
sum(if[holdem_hand_player_statistics.flg_p_face_raise AND NOT lookup_actions_p.action LIKE '%R' AND holdem_hand_player_statistics.flg_f_bet AND AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position),1,0])

OR

sum(if[holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position),1,0]).

NOW: holdem_hand_player_statistics.flg_r_donk, AND holdem_hand_player_statistics.flg_t_donk HOW ARE CALCULATED?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby WhiteRider » Tue Oct 13, 2009 4:43 am

The donk flop stat in the repository has been updated (although it may not yet have been validated, so may not yet be available).
Donk turn and river are built-in to PT3 so the database fields have the correct value without any calculation.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 5:11 am

what do you think about my corrections?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby kraada » Tue Oct 13, 2009 9:06 am

Honestly the reason I put it together the way that I did was that I thought most people would not want 3-bet pots to count as donkbet opportunities, or at a minimum, they'd want them separated into their own statistic.

In my experience, 3-bet pots have a totally different dynamic than singly raised pots, and including them together like this might cause nontrivial skew.

You are welcome to edit your own to read with either of your definitions, if you would prefer them to work that way.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 9:36 am

i think you are right. would be better use 2 different donkbet. (but i have 1850 column :lol: !!! and im going to 1900 today ) i hope will be fixed the proble with cache limted to 1600.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 9:44 am

thinking about your last post that separate 3-bet pot in count of opportunity of donk bet, what say about flag_donk_t and flag donk_r?
they are true if i donkbet in 3bet pot? or are not considered like opportunity when im not the last raiser on flop and (first to act) bet on the turn?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby kraada » Tue Oct 13, 2009 9:48 am

As I said in response to your other post, the easiest way to think about a donkbet is a player can donkbet when, if he checked, and his opponent bet, he would be facing a cbet. A donkbet is betting into your opponent instead of checking in these spots.

With regards to the 1600 column limit I'm not aware of when that will get fixed, though I agree, it would be nice if it were sooner rather than later.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 10:24 am

then if i have understood, (sorry if i repeat) the flag_donk_t (about player B)
preflop:
utg raise, mp 3-bet,utg call. (MP is PFA)
flop:
utg bet (your count is not DONKbet, why the pot is 3-bet)
but about flag_donk.... if:
preflop:
utg raise, mp 3-bet,utg call. (MP is PFA)
flop:
utg check, mp c-bet, utg call.
turn:
utg bet (flag donk about UTG is true why has anticipated the c-bet, also if the pot is 3bet, and you wish consider this action with logic different from donkbet in rased pot)

a doubt about FLOAT: THE LOGIC IS THE SAME OF DONK (I MEAN THAT THE BETTOR OF PREVIUOS STREET MUST BE THE PFA AND MUST BE THE BETTOR IN EACH PREVIOUS STREET WITHOUT BEING RAISED?)

flag_float_t (about player B) SURELY is true if: player A is PFA and bet on flop, and on turn A check and player B bet (B has position against A).
BUT WHAT ABOUT FLOAT BET IF:
A is not PFA but take the control on flop being called by player B in position (NOW A is the aggressor, but not PFA). on turn A check...now, an evenctual bet of B is not float, why A wasnt PFA... right? or floatbet can be executed also when the last aggressor (no matter about PFA) dont bet being oop?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby kraada » Tue Oct 13, 2009 10:45 am

It sounds like you understand the donkbet part.

In response to:
marvin wrote:BUT WHAT ABOUT FLOAT BET IF:
A is not PFA but take the control on flop being called by player B in position (NOW A is the aggressor, but not PFA). on turn A check...now, an evenctual bet of B is not float, why A wasnt PFA... right? or floatbet can be executed also when the last aggressor (no matter about PFA) dont bet being oop?


B's bet is not a float because A wasn't the PFA. Floats and donks both work like this.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CNT_F_DONK OBSOLETE (OR WITH BUG), AND flg_t_donk?

Postby marvin » Tue Oct 13, 2009 11:10 am

then i can say that in a limped pot (a pot where nobody has raised preflop) cant be made c-bet, float-bet or donk bet. right? :?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests