Question about custom stat

[jaxx]

when I use two AND, do I need additional brackets or something? or this is enough:

sum( if[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open
AND tourney_holdem_hand_player_detail.amt_before != tourney_holdem_hand_player_detail.amt_p_raise_made
, (tourney_holdem_hand_player_detail.amt_p_raise_made / tourney_holdem_blinds.amt_bb), 0])

[kraada]

That's sufficient; logically A AND (B AND C) is equivalent to (A AND B) AND C. So using parentheses to force a specific order of operations is unnecessary.

[jaxx]

Thanks
Another question:

Are there stats VPIP (from SB) and VPIP from (BB)? - I need them for HU SNGs
Also I need a statistic which is showing how often the player folded to a raise when limped, but the current limp fold statistic which I have is -
(cnt_p_limp_fold / cnt_p_limp) * 100, however I need something like (number of times the player limped and folded to a raise / number of times the player limped and there was a raise)
Can you help me for these?
Thanks

[WhiteRider]

VP$IP SB is a built in stat.
There isn't a BB version but it will be easy to build by duplicating the SB version and changing the checks for the blinds round in the column.
Custom Reports guide

There are a set of limp / (fold/call/raise) stats in the Repository, posted by me.
They are cash versions but you can import and convert them for tournament use (if you are using Beta 30.7) using the "Convert To" option on the Statistics tab in the custom stats window.

[jaxx]

I imported and converted the limp statistics and everything is ok

However I did not understand about VPIP BB.
Currently VPIP SB is (cnt_vpip_sb / cnt_sb) * 100
So I have to duplicate also both columns and change the formula inside them?

Currnetly cnt_sb is
sum( if[tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s, 1, 0])

and

cnt_vpip_sb is
sum( if[tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_vpip, 1, 0] )

What should be the change?

[kraada]

cnt_bb:
sum( if[tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_s = false, 1, 0])

and

cnt_vpip_bb is
sum( if[tourney_holdem_hand_player_statistics.flg_blind_b AND tourney_holdem_hand_player_statistics.flg_blind_s = false AND tourney_holdem_hand_player_statistics.flg_vpip, 1, 0] )

[jaxx]

Thanks. it's working.

some more questions:
- why we check both if player is bb and is not sb? isn't checking for bb enough?
- cbet turn statistic - is it necessary to be the preflop raiser so as to be counted as cbet turn? I.e. is bet flop/bet turn enough or it must be raise preflop/bet flop/bet turn?
- is there a way in case of Heads up table (SNG), a special HUD, which I've prepared for heads up, to appear automatically?

[kraada]

Checking for just the blind you are in is sufficient but I wanted to keep the column in the same format so that you could see the differences I made.

In order to cbet the turn a player must have raised preflop and cbet the flop and not faced a raise.

If you set a HUD Profile as Default for the heads up tournament it should be selected as the default HUD for that kind of tournament in the future.

[preparac]

Or could I use also

AND NOT
(tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action LIKE 'R')

to exclude situations where a players first action is raising allin?

[kraada]

That should exclude those situations yes.