New Statistic, but there's a prob. Can you help me?

[monarco]

Hey guys,

i tried to configure ONE new statistic: how often a player (on the button and in the blinds) 3bets our steal attempt. And all of this in one new value. I get apparently reasonable results for myself (around 10%), but if i add this new statistic to the Player Statistics window (or somewhere else), it says that i have 900k hands, which is way off of course.

Here is the Value Expression:

Code: Select all

((cnt_bu_3bet_steal / cnt_bu_3bet_steal_opp) * 100 + (cnt_bb_steal_raise / cnt_steal_def_opp_bb) * 100 + (cnt_sb_steal_raise / cnt_steal_def_opp_sb) * 100) / 3

cnt_bu_3bet_steal is:

Code: Select all

sum(if[ lookup_positions.position = 0 AND holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_p_3bet_action='R' , 1 , 0 ])

and cnt_bu_3bet_steal_opp:

Code: Select all

sum(if[lookup_positions.position = 0 AND holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp, 1 , 0 ])[/QUOTE]

I just copied the Columns cnt_steal_reraise_def_opp and cnt_steal_reraise_def_action_fold for the last two and added the position component.


Could you tell me what is wrong with it?


I know that new Statistics should be posted in Repository, but it isn't done yet and i don't know if it ever will be.

[WhiteRider]

I don't think you should be using the lookup_positions.position field.
I think you need the position field from: holdem_hand_player_statistics.position

[monarco]

Yeah, you were right. Now i have the right number of hands AND the same results as before. You didn't see any other big mistakes in there?
Anyway, i'm going to upload them to the repository. Thank You!

[WhiteRider]

I'm getting a bit tired now, so I may have missed something, but when you submit them to the Repository they will be checked.
I wonder if you ought to just add up the total steals and divide by the total opps, though, rather than 3 sums and dividing by 3..
(it may well be the same, but as I said I'm tired... ;) )

[monarco]

(1/2 * 100 + 1/2 * 100 + 1/2 * 100)/3 = 150/3 = 50
((1+1+1)/(2+2+2)) * 100 = 1/2 * 100 = 50

Should be the same, i hope :)

Well, we'll see.

[WhiteRider]

LOL - yes, I'm sure you're right.
Must ... go ... to ... bed...