A Pick 3 System Based On "Digits In Common With Previous Draws"Prev Topic Next Topic

New Topic New Poll

mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 30, 2019, 8:13 pm
Greetings everyone! I’ve been working on a system for Pick 3 based entirely on trends of “digits common to the previous drawing”, and while I’ve come up with a nifty tool, I’m struggling with how exactly to use the information the tool spits out to narrow down the field for the next drawing. Every strategy I’ve come up with is ALMOST, but not quite, repeatable.

The premise of the system is relatively simple: narrow the field of possibilities for the next drawing to combinations that meet the requirements of three flavors of “digits common to the previous drawing” filters. These filters are:
- CWP (the number of digits in common with the previous Pick 3 drawing)
- CWX (the number of digits in common with the previous Pick 4 drawing)
- OUT (the number of digits in common with a list of numbers that have not appeared in the last 2 draws)
All three filters range from 0 to 3 and I concatenate them into a Structure Code that looks like, for example, 1-2-0. Using this example, for a Pick 3 combination to be deemed “viable” for the next draw, it must have exactly 1 digit in common with the previous Pick 3 draw, exactly 2 digits in common with the previous Pick 4 draw, and exactly 0 digits on the “Out Numbers” list.

With three filters that range from 0 to 3 there are 64 possible combinations but I limit my analysis to only 20 of the 64. Based on backtesting in my state (Connecticut), these 20 are the most frequently occurring Structures and account for 90% of all hits in the last 10 years (I initially tried tracking all 64 but the Excel Macro I use to do all the legwork did NOT like it). Here’s the list of 20:

Now I run a Macro that calculates the number of combinations that are “viable” for each of the 20 Structures, and further breaks down how may combinations each of the 9 Root Sums contribute to the total for each Structure. See the Matrix below (only the top 5 Structures are shown, the Matrix goes off to the right to cover all 20 Structures). What does this Matrix say? For example, Structure 1-1-1 has a total of 144 combinations in its bucket, with 18 coming from combinations that have a Root Sum of 1, 36 from a Root Sum of 2, etc. Or you can read it horizontally: combinations with a Root Sum of 1 have 18 in the 1-1-1 bucket, 15 in the 1-0-1 bucket, etc. (Side note: the number 937 highlighted in blue is a cross-check to confirm the Root Sum and Structure buckets add up to the same number, it’s not 1,000 because I used 20 Structures instead of the full 64 as noted above).

Now what the %&$$@!! do I do with this? My first thought (and the reason I broke down by Root Sum) was to narrow down the field by my making an educated guess as to the 2 to 3 most likely Root Sums to be drawn next, then re-create the Matrix to see which Structure(s) were most likely to hit on the next draw based on the reduced fields. Taking the matrix above and re-running for Roots Sums 1, 3, and 5, here’s what we get:

Now it gets interesting. If I’m convinced Root Sums 1 or 3 will come out, and if I’m further convinced Structure 1-1-1 will come out, 30 combinations (18 + 12) will cover all possibilities. And the numbers get better as you go off to the right of the Matrix (the Matrix is sorted by the number of combinations generated by each Structure, descending, left to right) . . .

. . . but now I’m stuck. Looking for any insights as to how this may be useful, other than the obvious (play the top 1 – 3 Structures and/or the top 1 – 2 Root Sums). Any thoughts?

PS - If anyone would like to tinker with my Excel File feel free to let me know, I'm more than happy to share.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,804 Posts
Offline

May 30, 2019, 8:46 pm

I would be interested.

Thanks
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 30, 2019, 8:57 pm

I figured you would, I've seen many contributions from you in this Forum relative to Excel-ing stuff!
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 30, 2019, 9:05 pm

Quote: Originally posted by winsumloosesum on May 30, 2019
I would be interested.

Thanks

I don't think I've ever shared a file here, what's the best way to do this? Can I post a link to the Excel file, it's saved in the same location as the images that are linked in my post.
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
25,188 Posts
Offline

May 30, 2019, 11:55 pm

Quote: Originally posted by mitachoo on May 30, 2019
I don't think I've ever shared a file here, what's the best way to do this? Can I post a link to the Excel file, it's saved in the same location as the images that are linked in my post.

I'm ready when you are.

Catch ya layer!
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 31, 2019, 12:07 am

Quote: Originally posted by lakerben on May 30, 2019
I'm ready when you are.

Allrigthy, cleaning up the file as we speak . . .
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 31, 2019, 7:14 am

Quote: Originally posted by mitachoo on May 31, 2019
Allrigthy, cleaning up the file as we speak . . .

OK, here we go! You can download the file from the link below. I've added explanatory notes throughout the document but don't hesitate to contact me if you have any questions. I'll start summarizing herein what I have tried in terms of using the generated data to narrow-down the pool for future draws.

http://bit.ly/CWP_System_Rev_L
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,804 Posts
Offline

May 31, 2019, 7:38 am

Quote: Originally posted by mitachoo on May 31, 2019
OK, here we go! You can download the file from the link below. I've added explanatory notes throughout the document but don't hesitate to contact me if you have any questions. I'll start summarizing herein what I have tried in terms of using the generated data to narrow-down the pool for future draws.

http://bit.ly/CWP_System_Rev_L

Thanks for the file. Will take a look at your work today.

Looks very interesting!!
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,781 Posts
Offline

May 31, 2019, 7:49 am

mita and winsum, good approach, you can use the system of three patterns = bigger, smaller and equal
with reference of the last draw, we will cross or combine with your system, it will be a good form of reduction, you can use the will
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,781 Posts
Offline

May 31, 2019, 8:00 am

mita, besides the digits you can also use in each position of the last draws
the patterns / even / odd / low / high
So
criterion = number of patterns repeating from previous
so besides the repetition digits you can also see when you repeat the pattern
ex = 457 previous
613
ex = in the 1st position repeated the pattern pair
in the 2nd position he repeated the odd
and in the 3rd position repeated the odd
In this example there was a repetition of the three positions
can be joined with greater smaller and equal
You have the permission to use this at will.
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,781 Posts
Offline

May 31, 2019, 8:09 am

you can make your system also upright from the 3 positions
of the last 3 draws
ex
458
159
083
1st position = 410
2nd position = 558
3rd position = 893
So you have both horizontal and vertical conditions.
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 31, 2019, 8:10 am

Quote: Originally posted by dr san on May 31, 2019
mita, besides the digits you can also use in each position of the last draws
the patterns / even / odd / low / high
So
criterion = number of patterns repeating from previous
so besides the repetition digits you can also see when you repeat the pattern
ex = 457 previous
613
ex = in the 1st position repeated the pattern pair
in the 2nd position he repeated the odd
and in the 3rd position repeated the odd
In this example there was a repetition of the three positions
can be joined with greater smaller and equal
You have the permission to use this at will.

I actually initially had Lo/Hi and Even/Odd in the mix as will, you can find "remnants" of it in the hidden columns, but I ended up taking it out. Perhaps I was a bit hasty . . .
mitachoo

United States
Member #62,270
June 23, 2008
204 Posts
Offline

May 31, 2019, 8:11 am

Quote: Originally posted by dr san on May 31, 2019
you can make your system also upright from the 3 positions
of the last 3 draws
ex
458
159
083
1st position = 410
2nd position = 558
3rd position = 893
So you have both horizontal and vertical conditions.

Ohhhh . . . now THAT I hadn't thought of . . .
ram

South Texas
United States
Member #11
December 6, 2001
307 Posts
Offline

May 31, 2019, 8:22 am

Quote: Originally posted by mitachoo on May 31, 2019
OK, here we go! You can download the file from the link below. I've added explanatory notes throughout the document but don't hesitate to contact me if you have any questions. I'll start summarizing herein what I have tried in terms of using the generated data to narrow-down the pool for future draws.

http://bit.ly/CWP_System_Rev_L

Thank you for making your work available mitachoo. A concept that's outside the box for sure. I'll

load my databases and see what happens. Much appreciated.

ram
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,781 Posts
Offline

May 31, 2019, 8:24 am

MITA, you can use willpower,
this from the post of repeated positions and patterns ok