Preflop Hand Ranges Stats - Doublecheck

[kraada]

Thanks for these. I've edited your post with the incorrect definition so that nobody inadvertently uses it.

[WhiteRider]

Haven't looked into it yet, but can I upload the whole package as one link? Can PT3 import the whole thing all at once?

Once you have exported all your stats you can zip them (select them all; right click > Send to Compressed Folder) then you can submit the zip file to the Repository. Please make good notes so that everyone can understand what your stats are all about. You might want to include a link to this thread.
If there are several logical groups of stats within this you might want to make a few separate submissions.
To install these you would then unzip them and you can import multiple stats at once.

[bloodndef]

Taking longer than expected, but will submit the stats in a day or two. I've been test driving them and they work well. Not all are useful, but the ones that are help immensely. I had to make another stat when I learned that the SB and BB are not included in the cold-calling stat.

So hopefully this is the last in the package:

Called a Raise Preflop from the SB or BB

example:

Call-SB/BB:SolidPr

if (cnt_p_call_sbbb_solidpr > 0, 'QQ-88','')

cnt_p_call_sbbb_solidpr

sum(if[(holdem_hand_player_statistics.position = 8 OR holdem_hand_player_statistics.position = 9) AND holdem_hand_player_statistics.cnt_p_call AND (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), 1, 0])



Am I correct in thinking that this call action does not include completing from the SB? That is considered a limp and not a call, right?
And just to doublecheck, have I covered all preflop first actions besides folding?

1. Limping first in (4 positions)
2. Limping With Previous Callers
3. Cold Calling Preflop
4. Calling a Raise Preflop from the SB or BB
5. Put In the First Raise Preflop (2 positions)
6. Raised First In (2 positions)
7. Raised With Previous Callers (2 positions)
8. Raised SB Limper from BB
9. 3-bet Preflop
10. 4-bet Preflop

16 actions x 7 hand ranges = 112 stats


Thank you kraada and WhiteRider for your help throughout this.
After upload, I'll create an official thread with a comprehensive description of all stats.

[bloodndef]

Dang it, did it again. Example above should read:

Call-SB/BB:SolidPr

if (cnt_p_call_sbbb_solidpr > 0, 'QQ-88','')

cnt_p_call_sbbb_solidpr

sum(if[(holdem_hand_player_statistics.position = 8 OR holdem_hand_player_statistics.position = 9) AND holdem_hand_player_statistics.cnt_p_call>0 AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.flg_p_limp=false AND (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), 1, 0])


Ok, now have I covered all preflop first actions besides folding?

[kraada]

A limp is considered a call, I believe, since you are calling the blinds.

If you want to catch calling exactly one raise, the first thing that comes to mind is:

NOT(holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp) and holdem_hand_player_statistics.flg_p_face_raise AND lookup_actions_p.action LIKE '%C'

We check that you're not facing a 3bet or a 4bet (you could just remove those if you want calls of 3bets/4bets to count), you do face some raise, and your actions end in call. LIKE '%C' means that the last thing you did preflop was call, so you have to be calling that raise (since you didn't face a further raise), whether or not you limped.

[bloodndef]

I'd like the stat to reflect the first action a player takes preflop. In this case all I am going for is something like a cold-call from the SB or BB stat. This could be cold-calling a 3-bet or a 4-bet. But when the player first makes an action it is a call. In this case I think we need (holdem_hand_player_statistics.cnt_p_call>0 AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.flg_p_limp=false). Doesn't this ensure that a player's first and last or only action is a call? But if calling is including limps from the SB, it should read (holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.cnt_p_call>0 AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.flg_p_limp=false) to take SB limps out of the equation.

So this is what I have:

sum(if[(holdem_hand_player_statistics.position = 8 OR holdem_hand_player_statistics.position = 9) AND holdem_hand_player_statistics.cnt_p_call>0 AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.flg_p_limp=false AND holdem_hand_player_statistics.flg_p_face_raise AND (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), 1, 0])


But isn't the (holdem_hand_player_statistics.flg_p_limp=false) unnecessary then?


Thanks always.

[kraada]

It ensures that the first action they take is a call of some kind of raise. They then may call more raises though: If the button raises, the SB calls the BB 3 bets, the BTN calls and the SB calls, cnt_p_call > 0, cnt_p_raise = 0 and flg_p_limp = false.

That's the only case I can think of where they do more than just call once, though, and if that's okay by you, your definition should be good.

[WhiteRider]

You can use:
lookup_actions_p.action LIKE 'C%'
..to identify the first action as a call (with any, or no, further action).

To count only initial calls of raises (not "limps") you could use my limp-opportunity expression with the BB check removed, and NOT the whole thing.

limp-opp = (NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise

So "cold call from the blinds" =
NOT((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND lookup_actions_p.action LIKE 'C%'

[Mike88]

Hello bloodndef,

have you already finished your statistics and is there a way to get them? It sounds very interessting what you have done!

Thank you in advance!

[Trip_L]

I'm with Mike88, been looking forward to these for awhile, any update on how long?