RFI Bet Size

[IA06]

I´m using the following stats:

Preflop 2Bet Size% 2BB
(cnt_p_2bet_2x / cnt_p_raise_first_in) * 100

cnt_p_2bet_2x
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.amt_p_raise_made <= 2.2 * cash_limit.amt_bb , 1, 0])

cnt_p_raise_first_in
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp, 1, 0])

Preflop 2Bet Size% 2.5BB
(cnt_p_2bet_25x / cnt_p_raise_first_in) * 100

cnt_p_2bet_25x
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.amt_p_raise_made BETWEEN 2.21 AND 2.7 * cash_limit.amt_bb , 1, 0])


Preflop 2Bet Size% 3BB
(cnt_p_2bet_3x / cnt_p_raise_first_in) * 100

cnt_p_2bet_3x
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.amt_p_raise_made >= 2.71 * cash_limit.amt_bb , 1, 0])


I have these in a popup in my HUD and there they are displayed for every position (I have changed the position under the Item properties in the Hud Profile Editor). So all three stats for every position.

As an example I have one V that RFI from EP 27 times. But Preflop 2Bet Size% 2BB = 0% (0/27), Preflop 2Bet Size% 2.5BB = 0% (0/27) and Preflop 2Bet Size% 3BB = 7% (4/27).
My problem, or question is, for example in EP, shouldn´t these three togheter add up to 100%?
Where are the other 23 hands from EP?

Be advised that the amount raised isn´t exactly what the stat names suggest.

I have rebuild my custom cache.

[WhiteRider]

I suspect that your problem lies in this part:

cash_hand_player_statistics.amt_p_raise_made BETWEEN 2.21 AND 2.7 * cash_limit.amt_bb

That is probably not giving you what you expect.
I think it will be doing this:

cash_hand_player_statistics.amt_p_raise_made BETWEEN 2.21 AND (2.7 * cash_limit.amt_bb)

Probably you would need to do either:

cash_hand_player_statistics.amt_p_raise_made BETWEEN (2.21 * cash_limit.amt_bb) AND (2.7 * cash_limit.amt_bb)

..or:


(cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) BETWEEN 2.21 AND 2.7

[IA06]

Both

cash_hand_player_statistics.amt_p_raise_made BETWEEN (2.21 * cash_limit.amt_bb) AND (2.7 * cash_limit.amt_bb)

and

(cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) BETWEEN 2.21 AND 2.7

seams to be working fine.
Thanks for the support.

[IA06]

So now that I got this working, I want to make some use of the information.

I would like to see in a Hand Report the hands when V is deviating from their normal RFI size (I understand that these will have to go to showdown of course in order to see V actuall cards).
I have a Player Pool Hand Report, so that is done.
Best would be if here could be a check box column in the hand report that shows when V is deviating.
The Hand Report would also need to include V position when deviating.

For example if V is RFI 2bb from the CO 5%, RFI 2.5bb from the CO 85% and RFI 3bb from the CO 10%, I would like to find those 5% and 10% hands.
I´ve tried playing around with som custom hand stats and read the forum, but not really getting anyware.

Maybe you could help get started or point me in the right direction?

[Flag_Hippo]

You can't add/reference player statistics/values in a hand report. You could use an expression filter to filter for hands where the actual RFI size varies from a given value if that helps. For example:

Code: Select all

cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp and (2.5 - (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) <= -0.5)

The Hand Report would also need to include V position when deviating.

There is a built-in hand statistic called 'Position' which will display the players position.

[IA06]

So if I understand it right this

Code: Select all

cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp and (2.5 - (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) <= -0.5)

would give me the hands where V is RFI 2.5BB +- 0.5BB?
If so, that doesn´t really help me unfortunately.

What I need would be something lika an expression filter lokking like this:

Code: Select all

(cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.amt_p_raise_made <= 2.2 * cash_limit.amt_bb)
AND ((cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.amt_p_raise_made <= 2.2 * cash_limit.amt_bb) /
(cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp) *100 ) <=10

Because this would (in theory) sort out every hand V RFI up to 2.2BB, but only if the totalt times V used 2.2BB RFI size is equal to or under 10%?
But I guess that isn´t possible then (I get it as NOT valid)?

[Flag_Hippo]

That type of filtering will require an expression filter with a subquery but unfortunately I've been unable to come up with anything that works for this as it's beyond my SQL knowledge I'm afraid.

[IA06]

No worries. Should you come up with something, please get back to me.