BB raising SB

[Darvini]

I tried that BB raising a limping SB stat but it didnt work. I got 0/X results and I know I have done it many times.

(holdem_hand_player_detail.amt_p_raise_made / (holdem_hand_player_detail.amt_p_raise_made + 2 * (holdem_limit.amt_bb))) = holdem_hand_player_detail.val_p_raise_made_pct

This division doesnt make sense to me. First it forgets that val is % and not just relation. Secondly pot doesnt include the raise made.

Val_p_raise_made_pct is defined as (amt_p_raise_made / pot) * 100. So when only SB limps the pot will be 2 * (holdem_limit.amt_bb) and thus we get -> Val_p_raise_made_pct = (amt_p_raise_made / 2 * (holdem_limit.amt_bb)) * 100

So I build my columns as follows:

cnt_p_bb_raise_sb_limp:

sum(if[holdem_hand_player_statistics.position = 8 and holdem_hand_player_statistics.flg_p_first_raise and ((holdem_hand_player_detail.val_p_raise_made_pct / 100) = (holdem_hand_player_detail.amt_p_raise_made / 2 * (holdem_limit.amt_bb))), 1, 0])

cnt_p_bb_raise_sb_limp_opp:

sum(if[(holdem_hand_player_statistics.position = 8 and holdem_hand_player_statistics.flg_p_first_raise and (holdem_hand_player_detail.amt_p_raise_made / (2 * (holdem_limit.amt_bb))) = (holdem_hand_player_detail.val_p_raise_made_pct / 100)) OR (holdem_hand_player_statistics.position = 8 AND lookup_actions_p.action = 'X' AND holdem_hand_player_detail.flg_f_has_position) , 1, 0])

And now the statistic gives believable results in my reports.

[preparac]

This only works when there are no antes, right?

[WhiteRider]

It's much easier if you follow things up in the ticket rather than jumping back and forth.

The columns you've ended up with here are rearrangements of what I gave you in your ticket, yes?

The column expression I gave you in the ticket was this:
cnt_p_bb_raise_sb_limp =
sum(if[holdem_hand_player_statistics.position = 8 and holdem_hand_player_statistics.flg_p_first_raise and round((holdem_hand_player_detail.amt_p_raise_made / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) * 100) = round(holdem_hand_player_detail.val_p_raise_made_pct), 1, 0])

..which is equivalent to what you've changed to.

[WhiteRider]

This only works when there are no antes, right?

Correct, but the same principal could be adapted to work with antes.

[Darvini]

Im not shaiheart and dont know anything about that ticket. The link posted here gets me nowhere. Just saw the columns, tried them and came up with proposal to fix the problem. Should I be able to see the ticket? I dont know how. But since you came up with the same solution I guess it works now.

[WhiteRider]

No, you shouldn't be able to see the ticket - tickets are private.

The columns you need are:

cnt_p_bb_raise_sb_limp =
sum(if[holdem_hand_player_statistics.position = 8 and holdem_hand_player_statistics.flg_p_first_raise and round((holdem_hand_player_detail.amt_p_raise_made / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) * 100) = round(holdem_hand_player_detail.val_p_raise_made_pct), 1, 0])

cnt_p_bb_raise_sb_limp_opp =
sum(if[(holdem_hand_player_statistics.position = 8 and holdem_hand_player_statistics.flg_p_first_raise and round((holdem_hand_player_detail.amt_p_raise_made / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) * 100) = round(holdem_hand_player_detail.val_p_raise_made_pct)) OR (holdem_hand_player_statistics.position = 8 AND lookup_actions_p.action = 'X' AND holdem_hand_player_detail.flg_f_has_position) , 1, 0])

Tutorial - Custom Reports and Statistics