RFI Bet Size

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

RFI Bet Size

Postby IA06 » Sun Sep 17, 2023 12:06 pm

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.
IA06
 
Posts: 15
Joined: Thu May 21, 2020 3:45 am

Re: RFI Bet Size

Postby WhiteRider » Sun Sep 17, 2023 2:59 pm

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
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI Bet Size

Postby IA06 » Wed Sep 20, 2023 2:28 pm

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
 
Posts: 15
Joined: Thu May 21, 2020 3:45 am

Re: RFI Bet Size

Postby IA06 » Fri Sep 22, 2023 10:12 am

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?
IA06
 
Posts: 15
Joined: Thu May 21, 2020 3:45 am

Re: RFI Bet Size

Postby Flag_Hippo » Sat Sep 23, 2023 12:11 pm

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)

IA06 wrote: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.
Flag_Hippo
Moderator
 
Posts: 15123
Joined: Tue Jan 31, 2012 7:50 am

Re: RFI Bet Size

Postby IA06 » Sun Sep 24, 2023 9:12 am

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)?
IA06
 
Posts: 15
Joined: Thu May 21, 2020 3:45 am

Re: RFI Bet Size

Postby Flag_Hippo » Mon Sep 25, 2023 5:06 am

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.
Flag_Hippo
Moderator
 
Posts: 15123
Joined: Tue Jan 31, 2012 7:50 am

Re: RFI Bet Size

Postby IA06 » Mon Sep 25, 2023 2:07 pm

No worries. Should you come up with something, please get back to me.
IA06
 
Posts: 15
Joined: Thu May 21, 2020 3:45 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 11 guests

cron