create stat: minraise flop

[dumdidum]

Unfortunately, I don't know *any* SQL.

I would like to create a stat "min-raised flop." I first create a column named c_f_min_raise with expression

sum(if[ (holdem_hand_player_detail.amt_f_raise_made=(holdem_hand_player_detail.amt_f_bet_facing*2) AND holdem_hand_player_detail.amt_p_raise_facing > 0), 1 , 0])

and then create a statistic with expression

cnt_f_min_raise

and format /%.2f. I do this trying to test if I correctly count the absolute number of min-raises (of course, I want to make this a percentage later on to have a stat that describes what percentage of the time a player min-raises when given the opportunity).

The results of this exercise appear to be garbage. Of course, I know the saying "garbage in, garbage out" but I cannot figure what's the garbage I put in :lol:

Any pointers on how to do this right?

[kraada]

I've been wondering if you could build this one for a while but haven't had a chance to take a deep look at it. I'll take a look at this stat more closely and get back to you with why this isn't working quite right.

[WhiteRider]

First thought is that you are using: holdem_hand_player_detail.amt_p_raise_facing
..which is a preflop field, and you're using that to tell when you are facing a raise, but you might not be facing a raise if you are facing a bet.

[dumdidum]

Thanks to both of you. That is indeed a mistake, I didn't mean to use a PF stat, I'll correct that first and see what happens..

[kraada]

Please keep us posted, as if it doesn't work I'd like to make sure that whatever needs to gets fixed promptly.

[dumdidum]

Ok, just a quick update, I made the change and it didn't work. I didn't really have time to think about this yet. I will experiment more before I ask you further questions.

My idea was that I want to only consider hands for which a player is both facing a flop bet (holdem_hand_player_detail.amt_f_bet_facing is true) and he makes a flop raise for which it is true that the flop raise size is two times the size of the bet the player is facing.

Once again, no need at all for you guys to get back to me. I'll post again, might be a few days though.

[Animosius]

shouldnt it be facing a bet and not a raise?

sum(if[ (holdem_hand_player_detail.amt_f_raise_made=(holdem_hand_player_detail.amt_f_bet_facing*2) AND holdem_hand_player_detail.amt_f_bet_facing > 0), 1 , 0])

[WhiteRider]

shouldnt it be facing a bet and not a raise?

sum(if[ (holdem_hand_player_detail.amt_f_raise_made=(holdem_hand_player_detail.amt_f_bet_facing*2) AND holdem_hand_player_detail.amt_f_bet_facing > 0), 1 , 0])

Good spot!