donk fold flop question

[js2002]

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open and substring(lookup_actions_f.action from 1 for 2) = 'BF' 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 AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

What does the marked text stand for, what does it check?

f.e. BB vs CO, BB is donk folding.
val_p_raise_aggressor_pos = 1
holdem_hand_summary.cnt_players-1=1 ---> so the whole term returns FALSE, why?

EDIT: ah its not cnt flop players right?

I need this stat for turn and river, so these little changes are good?

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_t_open and substring(lookup_actions_t.action from 1 for 2) = 'BF' AND NOT holdem_hand_player_statistics.flg_t_cbet_opp
AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

[js2002]

holdem_hand_player_statistics.flg_t_donk

I added this to the nominator


A question to denominator:

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_t_open_opp and flg_t_face_raise AND NOT holdem_hand_player_statistics.flg_t_cbet_opp
AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

turn: hero checks, PFA bets, MrX raises

Is the denominator TRUE here? because hero faces a turn raise and had the opp to open.
What is a good denominator for this "donk / fold turn" stat?

maybe a check like AND NOT turn "BF" ???? so that c/f, c/c, b/c, b/r are in there?

Or should I put for donk/call donk/raise donk/fold into the denominator? So that the stat says: of all times villians donks turn, x% he folds, 100-x = donk call and donk raise

[js2002]

Analog tohttp://www.pokertracker.com/forums/vi ... 18&t=18809

I should really insert "...t_donk" into the denominator!

If you doubt raise a plea otherwise I ll build that.

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_t_open_opp AND substring(lookup_actions_t.action from 1 for 2) = 'B%' and flg_t_face_raise AND NOT holdem_hand_player_statistics.flg_t_cbet_opp
AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

[js2002]

sum(if[
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_detail.flg_t_open_opp AND
substring(lookup_actions_t.action from 1 for 2) = 'BF' and
flg_t_face_raise AND
NOT holdem_hand_player_statistics.flg_t_cbet_opp
AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])
_____________________________________________
sum(if[
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_detail.flg_t_open_opp
AND substring(lookup_actions_t.action from 1 for 2) = 'B%' and
flg_t_face_raise AND
NOT holdem_hand_player_statistics.flg_t_cbet_opp
AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

Shows me 1/0 !

[js2002]

the problem is the B%, why?

[js2002]

sum(if[
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_detail.flg_t_open_opp AND
substring(lookup_actions_t.action from 1 for 2) = 'BF' and
flg_t_face_raise AND
(NOT holdem_hand_player_statistics.flg_t_cbet_opp)
AND holdem_hand_player_statistics.flg_t_donk AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_detail.flg_t_open_opp AND
substring(lookup_actions_t.action from 1 for 1) = 'B' AND
flg_t_face_raise AND
(NOT holdem_hand_player_statistics.flg_t_cbet_opp) AND
holdem_hand_player_statistics.flg_t_donk AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

shows me 1/1, but when I take out "t_donk" off both it shows me 5/21.

[js2002]

new easy stat shows 1/1 which ist way to few (cause 5/25 sound more reasonable, 15k hands sample)
This is the "easy" (wrong) version.

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_t_donk AND flg_t_face_raise AND
holdem_hand_player_statistics.flg_t_fold AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])
___________
sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_t_donk AND flg_t_face_raise AND (holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

[kraada]

We've been talking about this via PM for quite a while, but one thing that I don't know if I mentioned is that in the (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1) the cnt_players is the number of players dealt into the hand. I'm really not sure what good that section is supposed to do for you here.

[js2002]

for all readers:
It just the old Headsup Check / workaround.
We have a new better one ....

[Oakrdrzfan]

for all readers:
It just the old Headsup Check / workaround.
We have a new better one ....

what is wrong with the other one?