Please help with donk/f stat

[walter1953]

hi,

i want to know how often an opponent donks and then folds to my raise on the flop (turn , river).


i have a custom donk/f stat here, but it doesnt seem to do right.

i just checked my last month and it seems that i donked 30 times, got raised 3 times and then foldet 1 time to the raise. so my donk/f stat should be 33% (1/3).
the stat i use shows me 4,54% (1/22)- guess 22 is the amount of my donks in single raised pots overall.

my stat is: (which sould be right)

Code: Select all

(cnt_f_donk_fold / cnt_f_donk_fold_opp) * 100

so, "cnt_f_donk_fold" should be ok, but "cnt_f_donk_fold_opp" is not ok.


can you please look over the opp column and tell me what i have to change that it works like i want it to?
here is the opp column:

Code: Select all

sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_detail.flg_f_open_opp and flg_f_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 AND (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1))) , 1 , 0])

thanks a lot in advance :)

[kraada]

This stat is available for free download in our warehouse - take a look at what is there and that should help you get everything working properly.

[walter1953]

This stat is available for free download in our warehouse - take a look at what is there and that should help you get everything working properly.

i have used the one from the warehouse.
i downloaded this one (can't find other donk/f stats):

Donk Flop and Fold to Raise
by stevi3p Dec. 08, 2008


and exactly this one produced wrong(4,54% (1/22)) donk/f values like I explained in the example above. correct would be 33% (1/3) in my example.

so unfortunately this doesn't really help me

[kraada]

I think this will work but could you elaborate a little on why you used (holdem_hand_player_detail.val_p_raise_aggressor_pos != (holdem_hand_summary.cnt_players-1) ?

[walter1953]

Sorry, i cannot, because i didn't created the stat and columns. I Have no clue why he used that expression

[kraada]

I don't think it'll ever rule out any hands at all so I don't see it hurting anything, for what it's worth. Which is why I was curious what you thought it did :)

[walter1953]

can't i just eliminate (or adapt) an expression, so that it only counts when there was actually a raise facing to the donk?

[kraada]

Ah I see what's missing - you need to add AND holdem_hand_player_statistics.flg_f_bet to the opportunity column. Right now it's not checking that you actually made the donk bet just that you had a chance to and faced a raise. Just because you faced a raise doesn't automatically mean that you made a bet!

[walter1953]

wow, is working now!

thank you very much, I really have to say the support of you guys is superior! :)