Welcome, Guest. Please login or register.
June 03, 2023, 11:31:04 PM
Home Help Login Register
News:

Shanky Technologies Poker Bot Support Forum  |  General Category  |  PPL Support (Moderator: sngbot)  |  Topic: Preflop Hand Range PPL Generator 0 Members and 1 Guest are viewing this topic.
Pages: [1] Print
Author Topic: Preflop Hand Range PPL Generator  (Read 16422 times)
cosmo27
Sellers
Extreme Botter
*****

Karma: 70
Posts: 2675


Bots are better than pros


« on: March 24, 2016, 06:17:08 PM »

Well it's been a while since I've given back to the botting community (for free) so here is my good deed for the day. After starting to make some new profiles I forgot what a pain in the butt it is to create preflop hand ranges so I created a preflop hand range generator to do it for you. Just specify the individual hand ranges you wish to have and BOOM! Instant ppl code you can copy and paste into your text file. Pretty self explainatory but ask questions if you have any. I think I protected the Google Sheet version well enough that people can't jack it up but just in case please copy and save your own version!

Google Sheets Version
https://docs.google.com/spreadsheets/d/1_v5w0ClJ16bizXyMmgRKLlFLCwJGhECt5HUj0JepktQ/edit?usp=sharing

Excel Version
http://www.mediafire.com/download/oy27h64slgly7bk/Hand_Range_Generator_%28PPL%29.xlsx
« Last Edit: March 25, 2016, 12:25:57 AM by cosmo27 » Logged

KGB Profile: Proven Winners: Royal Tested - ROI: 40.8%, ITM: 19.6% over 400+ tournaments!!!
cosmo27
Sellers
Extreme Botter
*****

Karma: 70
Posts: 2675


Bots are better than pros


« Reply #1 on: March 25, 2016, 12:35:20 AM »

Google sheets version is unlocked and excel version is uploaded. If you don't have excel and need a google sheet version just email me  beer
Logged

KGB Profile: Proven Winners: Royal Tested - ROI: 40.8%, ITM: 19.6% over 400+ tournaments!!!
ykcip75
Experienced Botter
*****

Karma: 70
Posts: 402


Shanky Bonus Bots Rock!


« Reply #2 on: March 25, 2016, 09:45:31 AM »

Nice work but you can still improve it by adding some simplification rules in your code for example 22+ = pairinhand A2+ = A
if you have common hands between suited and unsuited hands just write the hand without the suited.
for example : A5s+,ATo+ -> hand = AK or hand = AQ or hand = AJ or hand = AT or hand = A9 suited or hand = A8 suited or hand = A7 suited or hand = A6 suited or hand = A5 suited.

There is also the not simplification but I don't like it for hand ranges

example : for 44+ , I prefer (hand = AA or hand = KK .... until hand = 44) than (pairinhand and not (hand = 22 or hand = 33))
Logged
cosmo27
Sellers
Extreme Botter
*****

Karma: 70
Posts: 2675


Bots are better than pros


« Reply #3 on: March 25, 2016, 05:22:01 PM »

Agreed, the simpler the better. Will see what I can do for the next update.
Logged

KGB Profile: Proven Winners: Royal Tested - ROI: 40.8%, ITM: 19.6% over 400+ tournaments!!!
botfan12
Wide-Eyed Newbie
*

Karma: -2
Posts: 13


« Reply #4 on: May 18, 2016, 12:34:01 PM »

i start with my first profile tweaking today and I just can say thank you so much man ;)

you are a very fair person and also your KGB additional fee for new updates is absolutley ok ;)

Thx  bowdown bowdown bowdown
Logged
johngr
Botter
***

Karma: 10
Posts: 166


« Reply #5 on: August 28, 2017, 12:34:50 PM »

Nice work but you can still improve it by adding some simplification rules in your code for example 22+ = pairinhand A2+ = A
if you have common hands between suited and unsuited hands just write the hand without the suited.
for example : A5s+,ATo+ -> hand = AK or hand = AQ or hand = AJ or hand = AT or hand = A9 suited or hand = A8 suited or hand = A7 suited or hand = A6 suited or hand = A5 suited.

There is also the not simplification but I don't like it for hand ranges

example : for 44+ , I prefer (hand = AA or hand = KK .... until hand = 44) than (pairinhand and not (hand = 22 or hand = 33))

The "NOT" method is far more elegant, readable and easier to determine if you're missing something after you get down to the 6s or 7s pairs or side cards.
Logged
ykcip75
Experienced Botter
*****

Karma: 70
Posts: 402


Shanky Bonus Bots Rock!


« Reply #6 on: September 05, 2017, 11:42:42 PM »

The "NOT" method is far more elegant, readable and easier to determine if you're missing something after you get down to the 6s or 7s pairs or side cards.

I agree with you but only when it's well used.
Misused and without real gain it's terrible !
Logged
johngr
Botter
***

Karma: 10
Posts: 166


« Reply #7 on: September 08, 2017, 09:08:24 AM »

I agree with you but only when it's well used.
Misused and without real gain it's terrible !

Appropos that, I have a question: would

WHEN HAND = A3 AND NOT (HAND = A2) OR HAND = KT RaiseMax Force

give the same result as,

WHEN (HAND = A3 AND NOT (HAND = A2)) OR HAND = KT RaiseMax Force

i. e., do I need the parentheses around the the aces or would it push only with A3+ and disregard the rest of the statement without them? I have my own Nash code/PPL generator, it excees Excel's formula length limitation, and paring down the NOT statements would save 100 or so characters (if the ()'s are superfluous).
[/quote]
Logged
ykcip75
Experienced Botter
*****

Karma: 70
Posts: 402


Shanky Bonus Bots Rock!


« Reply #8 on: September 08, 2017, 10:36:51 AM »

Appropos that, I have a question: would

WHEN HAND = A3 AND NOT (HAND = A2) OR HAND = KT RaiseMax Force

give the same result as,

WHEN (HAND = A3 AND NOT (HAND = A2)) OR HAND = KT RaiseMax Force

i. e., do I need the parentheses around the the aces or would it push only with A3+ and disregard the rest of the statement without them? I have my own Nash code/PPL generator, it excees Excel's formula length limitation, and paring down the NOT statements would save 100 or so characters (if the ()'s are superfluous).


It's logically true but semantically false.
There is no universal priority rules for boolean expression like there are for numerical expressions and it depends on the application.
Unless you know how the operators priority are handled you cannot do such statements that's why parentheses are there to make sure that each expressions are separated.
You don't need the not hand = A2 here unless you play omaha.
Now you have exceeded the formula length limitation you should use excel macros.
Logged
johngr
Botter
***

Karma: 10
Posts: 166


« Reply #9 on: September 08, 2017, 01:23:26 PM »

That's okay, I have abandoned the "blast the Nash range text sequentially against every possible PPL statement" approach, which doesn't work to make it Excel-friendly even with cell references that have short range names for each Nash notation, in favour of parsing the Nash text within array lookups (which has its own problems  banghead). Thanks for the info, anyway though. thanks

You don't need the not hand = A2 here unless you play omaha.
I mixed up Nash notation and PPL there -- meant to write, "HAND = A"
« Last Edit: September 09, 2017, 02:22:20 PM by johngr » Logged
Sleeper
Botter
***

Karma: 14
Posts: 132


« Reply #10 on: September 08, 2017, 02:45:30 PM »

Precedence for ppl
User Guide:

3.2.2 Operators:

‘Not’ and ‘And’ and ‘Or’ have their standard meanings. ‘Not’ has a higher precedence than ‘And’ which has a higher precedence than ‘Or’.

Nonetheless, brackets do clarify things.
Logged
20beebeeperhundo
Wide-Eyed Newbie
*

Karma: 0
Posts: 16


« Reply #11 on: January 28, 2019, 10:33:20 AM »

Sweet I will use this
Logged
miukumauku
Aspiring Botter
**

Karma: 1
Posts: 61


« Reply #12 on: April 02, 2020, 08:33:09 PM »

How does that work?  Could someone teach?
Logged
Egor
Forum Admin
Extreme Botter
*****

Karma: 377
Posts: 34965



WWW
« Reply #13 on: April 02, 2020, 09:13:16 PM »

just always bracket 'not' conditions and 'or' conditions, its a good habit.

This is how I would write that line:

WHEN HAND = A3 AND NOT (HAND = A2 OR HAND = KT) RaiseMax Force

...of course I would never write that exact line because it doesn't make sense, and I would use lower case personally, but that's the style.
Logged

Please do not PM me about license issues or help stuff - email me or use the Help board. Thanks! -Egor
BOTANIK
Wide-Eyed Newbie
*

Karma: 0
Posts: 5


« Reply #14 on: November 01, 2020, 11:50:03 PM »

good job, thank you !!!!!
Logged
Pages: [1] Print 
Shanky Technologies Poker Bot Support Forum  |  General Category  |  PPL Support (Moderator: sngbot)  |  Topic: Preflop Hand Range PPL Generator
Jump to:  


Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!