Hand Range Popup for group of hands

[mrekco]

Probable been asked this a 100 times but here goes,

Is it possible to create a hand range popup that would display % of time a group of hands a player would have raised/called pre flop?

Form example Pocket pairs, Broadway, or Big Ace's.

I've seen kraada's create hand range popup post and tried creating a few with no luck (keep getting weird numbers like 200/1).

What I mean is something like this;
(pure speculation)

Call PFR Pocket pair
(cnt_PFR_show_PP/ cnt_PFR_known) * 100

cnt_PFR_show_PP -
sum( if[holdem_hand_player_statistics.flg_p_PFR AND
holdem_hand_player_statistics.id_holecard = 1 or holdem_hand_player_statistics.id_holecard = 26 or
holdem_hand_player_statistics.id_holecard = 49 or holdem_hand_player_statistics.id_holecard = 70 or holdem_hand_player_statistics.id_holecard = 89 or holdem_hand_player_statistics.id_holecard = 106 or holdem_hand_player_statistics.id_holecard = 121 or holdem_hand_player_statistics.id_holecard = 134 or holdem_hand_player_statistics.id_holecard = 145 or holdem_hand_player_statistics.id_holecard = 154 or holdem_hand_player_statistics.id_holecard = 161 or holdem_hand_player_statistics.id_holecard = 166 or holdem_hand_player_statistics.id_holecard = 169, 1, 0])

cnt_PFR_known - sum( if[holdem_hand_player_statistics.flg_p_PFR AND holdem_hand_player_statistics.flg_showdown, 1, 0])

So what I'm hoping for is it find:
Player PFR with
AA=4
Aks=2
QQ=6
44=2
it adds this up to =14
then divides this by the all hand that went to showdown 60
which would by about 23%
Call PFR w/PP 23% of the time

It seems possible if you can do it for one hand why not for a group. Would also reduce the columns that you would need.
Thanks
mrekco

[kraada]

That would work but flg_p_PFR is not a valid value. You'll want to use (holdem_hand_player_statistics.cnt_p_raise > 0)

[mrekco]

Thanks kraada,

Built the PFR Pocket pairs stat with your suggestions, but it's not working properly. I tested in a small database to make it easier for my to check.

This is what I've done;

Call PFR w/PP

Code: Select all

(cnt_PFR_show_PP/ cnt_PFR_known) * 100

 

cnt_PFR_show_PP - 

Code: Select all

sum( if[holdem_hand_player_statistics.cnt_p_raise > 0 AND
holdem_hand_player_statistics.id_holecard = 1 or holdem_hand_player_statistics.id_holecard = 26 or 
holdem_hand_player_statistics.id_holecard = 49 or holdem_hand_player_statistics.id_holecard = 70 or holdem_hand_player_statistics.id_holecard = 89 or holdem_hand_player_statistics.id_holecard = 106 or holdem_hand_player_statistics.id_holecard = 121 or holdem_hand_player_statistics.id_holecard = 134 or holdem_hand_player_statistics.id_holecard = 145 or holdem_hand_player_statistics.id_holecard = 154 or holdem_hand_player_statistics.id_holecard = 161 or holdem_hand_player_statistics.id_holecard = 166 or holdem_hand_player_statistics.id_holecard = 169, 1, 0])

cnt_PFR_known -

Code: Select all

sum( if[holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_showdown, 1, 0]) 

The issue I'm finding is my cnt_PFR_show_PP expression is counting all PP that went to showdown even if there is no pre flop raise.
My cnt_PFR_known expression is only counting the pre flop raised hands.

This ends up giving me weird stats of like 300% (3/1) for some players.

Any insight would by helpful.
Thanks,
mrekco

[kraada]

This may have to do with AND/OR considerations and order of operations. Try the following and see if that works better:

sum( if[holdem_hand_player_statistics.cnt_p_raise > 0 AND (holdem_hand_player_statistics.id_holecard = 1 or holdem_hand_player_statistics.id_holecard = 26 or holdem_hand_player_statistics.id_holecard = 49 or holdem_hand_player_statistics.id_holecard = 70 or holdem_hand_player_statistics.id_holecard = 89 or holdem_hand_player_statistics.id_holecard = 106 or holdem_hand_player_statistics.id_holecard = 121 or holdem_hand_player_statistics.id_holecard = 134 or holdem_hand_player_statistics.id_holecard = 145 or holdem_hand_player_statistics.id_holecard = 154 or holdem_hand_player_statistics.id_holecard = 161 or holdem_hand_player_statistics.id_holecard = 166 or holdem_hand_player_statistics.id_holecard = 169), 1, 0])

[mrekco]

Got same results,
Thinking maybe I should scrap the PFR idea for now and just focus on what range (PP) of cards he took to showdown.

So I'll leave the cnt_PFR_show_PP the same since it counts all PP and change the cnt_PFR_known to something that counts all the hands someone took to showdown and showed their cards.

For example I have stats on a player where he went to showdown 31 time but only 18 time I see his cards. From those 18 time he showed PP twice so that's a 10% use of PP to showdown.

If I can get these maybe with your help I can work the rest back to PFR and all the rest i may want to do.

Just having trouble on what to use so it can count all known showdown cards.
Have any ideas?
Thanks,
mrekco

[WhiteRider]

For unknown hole cards holdem_hand_player_statistics.id_holecard = 0, so for known cards you can check for holdem_hand_player_statistics.id_holecard > 0.

[mrekco]

Thanks for the help guys.
Seems to be working, just have to run more tests and do some more adjustments.
If your interested I'll get back to you guys on how I make out with these.
mrekco

[kraada]

Please do keep us posted.