Donkbet/fold

[gennysennin]

It doesn't work, don't you create these 2 stats so that I can download them please?

[Stratocaster]

Still something is wrong with cnt_f_donk_raise column. I checked my DB and it's shows 19 hands where I had opp. to 3bet after F donk. This number is ok, denominator has the same value. I had 4 hands where I play donk/3bet and the stats shows me 7/19 and I rly dunno why. The expression looks good :

Code: Select all

 sum(if[cash_hand_player_statistics.flg_p_face_raise AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_f.action LIKE 'BR%' AND ((cash_hand_summary.cnt_players > 2 AND cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND   

[kraada]

How exactly did you check the database for those hands?

[gennysennin]

I changed the active player and chose a player that donks a lot.Then I filtered all the hands in which he donks and I checked these hands writing the cases where he donks/folds, donks/calls and donks/raise. The results are:
donk/fold 1 2
donk/call 1 2 3 4 5 6
donk/raise 1 2 3
There are two hands, in one hero donks all in, and in the other hero donks and oppo pushes. What happens in these hands?

[gennysennin]

Still something is wrong with cnt_f_donk_raise column. I checked my DB and it's shows 19 hands where I had opp. to 3bet after F donk. This number is ok, denominator has the same value. I had 4 hands where I play donk/3bet and the stats shows me 7/19 and I rly dunno why. The expression looks good :

Code: Select all

 sum(if[cash_hand_player_statistics.flg_p_face_raise AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_f.action LIKE 'BR%' AND ((cash_hand_summary.cnt_players > 2 AND cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND   

My stat is equal to this and the results are always them.

[gennysennin]

I changed the active player and chose a player that donks a lot.Then I filtered all the hands in which he donks and I checked these hands writing the cases where he donks/folds, donks/calls and donks/raise. The results are:
donk/fold 1 2
donk/call 1 2 3 4 5 6
donk/raise 1 2 3
There are two hands, in one hero donks all in, and in the other hero donks and oppo pushes. What happens in these hands?

There are some particular hands:
in one hero donks all in;
in the other hero donks and oppo pushes;
In the last hero donks, oppo1 calls, oppo2 raises, hero calls, oppo1 3bet, 2 folds.
Can one of these create problems?

[Stratocaster]

(Bet Flop Donk Bet) AND (Raise Opportunity 3Bet) 19 hands: BF=8h, BC=7h and stats shows the same numbers, BR=4h but Donk/3bet stat show 7/19. Ofc 3bet opp. from Flop Opp>Raise Opp.