limp call preflop fold to CBet flop check please!

[js2002]

Hi,

I made this stat:

http://rapidshare.com/files/177522805/p ... d.rar.html

WhideRider, can u check it plz? I think the stat is self explaining?! If not, ask.

Summary:
NOMINATOR IS:
sum( if[holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.cnt_p_call > 1 AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND
holdem_hand_player_statistics.enum_f_cbet_action = 'F'
, 1, 0] )

DENOMINATOR IS:
sum( if[holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.cnt_p_call > 1 AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_statistics.flg_f_cbet_def_opp
, 1, 0] )

I tried to use sum (if[cnt_p_limp_call(my column) > 0 AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1 , 0]) instead of using the large statement again, but this "is no valid SQL". I dont know why, so I had to use it redundantly.

[WhiteRider]

That looks pretty good.

You can't use your other columns like you want to because of the way they are built - remember each column iterates through each hand to sum things up - if you included another column it would be including that column's total value for each hand..

[js2002]

well ok, the dev have to protect some things, thats ok. I testet some fixed limit hands with this new stat and think it is ok.

Can I filter somehow to number of players at the flop? It would be nice to see if it was headsup at flop or not....

[WhiteRider]

Of course..
holdem_hand_summary.cnt_players_f

[js2002]

nice, but lot work now 4 me ;)