cnt_f_donk still actual?

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 still actual?

Postby js2002 » Sat Sep 19, 2009 5:02 am

Hi Kraada,

are these columns bugfree/correct? Is this ur actual version of the stat?

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_summary.cnt_players > 2 AND holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_b)), 1 , 0 ])

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_detail.flg_f_open_opp) AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) or (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_b)) , 1 , 0 ])

EDIT: Theres the "old" HU fix inside. as u can see.

#############################

I extended them to a "Donk Flop and Bet Turn" Stat:

sum(if[ holdem_hand_player_statistics.flg_t_bet AND 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_summary.cnt_players > 2 AND holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_b)), 1 , 0 ])

sum(if[ holdem_hand_player_statistics.flg_f_bet AND holdem_hand_player_detail.flg_t_open_opp AND 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_detail.flg_f_open_opp) AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) or (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_b)) , 1 , 0 ])

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

Re: cnt_f_donk still actual?

Postby WhiteRider » Sat Sep 19, 2009 5:14 am

Kraada is off for the weekend.

That stat looks OK but won't count times the player 3-bets and is 4-bet then bets out on the flop - but you may not want to count those, it depends on your definition of 'donk'.
Other than that it looks right.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cnt_f_donk still actual?

Postby js2002 » Sat Sep 19, 2009 5:43 am

No, My def of donk flop bet turn == the flop donkbet only gets called and then the donk! has the opp the bet the turn again.

Its very helpful I guess because in FL they donk very often and now I am able to see wheater they donk and check the turn or the donk flop and bet the turn. The first ones I can call more often on flop even with weak draws. ;) !!!

The vs 4bet donkbets I have to create or solve by making notes on players
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: cnt_f_donk still actual?

Postby kraada » Mon Sep 21, 2009 9:38 am

Yes those look like the definitions I'm still using.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cnt_f_donk still actual?

Postby js2002 » Mon Sep 21, 2009 11:19 am

kraada wrote:Yes those look like the definitions I'm still using.


perfect! I used some stats to build new ones:

http://img142.imageshack.us/img142/4426 ... 917135.jpg

Take a look at the specialiast Float Stats and the Donk Flop / Bet turn and the fold to reaction.

not on this shot is a stat that states are "+" "++" "-" and "--" showning if the player ist a winner bigwinner etc.....
I got it in my table so I can quickly see whos a winning TAG f.e. etc

All very helpful extension I think.

have a nice day, OJ
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 0 guests