Welcome Guest
Log In | Register )
You last visited December 9, 2016, 6:13 pm
All times shown are
Eastern Time (GMT-5:00)

SoniQ BOOM, a new P3/P4 system (Excel)

Topic closed. 116 replies. Last post 11 years ago by xavier102772.

Page 1 of 8
PrintE-mailLink
hypersoniq's avatar - 8ball
Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
Posted: December 29, 2005, 10:01 pm - IP Logged

How would everyone like to help develop a system in progress?

I call this one the SoniQ BOOM system, excruciating detail on development is in my blog, but in a nutshell...

take 2 draws (examples)

12/1/2005  6-7-2

12/2/2005  8-1-1

the first draw is the PRECURSOR draw, the second one is just the draw.

vertical pairs are created by position

Position 1 = 6-8

Position 2 = 7-1

Position 3 = 2-1

for position 1, we look back in the entire game history to count how many times each of the digits 0-9 followed a 6-8 "vertical pair

example

0=14

1=2

3=11

4=15

5=13

6=9

7=10

8=10

9=12

picking the most frequent, the pick for the first position the next draw is 4 (15 matches after a 6-8)

this is done for each position... the numbers that have followd the pairs in history are ANNOUNCERS. (If my terminology is off, so be it, that's how I understand the terms for now, corrections can be made later ;-)  )

I have the excel backtest files available for viewing/toying with/development at my website (see signature or click http://home.comcast.net/~hypersoniq and look for sb3.xls and sb4.xls)

these are REFERENCE files, to save space the formulas have been stripped (except the last row, so you can see how I did it and can modify for your own state, if you don't mind LONG recalc times)

warning to dial-up users: sb3.xls = 5.49MB and sb4.xls = 5.57MB

right now it is for the PA pick3 and pick 4 EVENING ONLY, and the backtest was only for straight hits since it is a positional system.

NOT DONE YET, but on the right track...

sb3 matched 64 straight hits in 28 years (32k profit, see blog for breakdown)

sb4 matched 11 straight hits in 25 years (40+k profit)

This is an OPEN system, free for all, but please help make it better and refine it

Playing more than one ticket per game is betting against yourself.

    Avatar
    Anna, TX
    United States
    Member #26720
    November 21, 2005
    263 Posts
    Offline
    Posted: December 29, 2005, 10:07 pm - IP Logged

    sign me up, what do you want me to do?

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: December 29, 2005, 11:16 pm - IP Logged

      What needs to be done on the volunteer's part? 

       

      L ttaL   T

        hypersoniq's avatar - 8ball
        Pennsylvania
        United States
        Member #1340
        April 6, 2003
        2450 Posts
        Offline
        Posted: December 30, 2005, 5:33 am - IP Logged

        right now, the sheets available are the full bloated backtest versions so everyone can see the history of the system's performance and where the numbers come from. the biggest help right now would be to check the formulas in the last row and see if there is a way to do what I did faster or more efficiently, and to see if there are any errors that I overlooked.

        eventually I would like to get this don to a "production" version that has the state's game history on one worksheet and an interactive form on another that allows you to enter results and generate the next pick... any ideas there would be great ;-)

        Right now, I have observed the mechanism that breaks ties in picking the number most frequent always picks the lowest number in the tie, one thing I will be doing is altering this to see if the highest picks more winners. Another of my experiments is to take the pick4 sheet and re-do it for MASS lottery results to see how well it does in another state, remember, to use different data, you need to autofill ALL of the formulas from the last row up to the 3rd row.

         

        Playing more than one ticket per game is betting against yourself.

          powerplayer's avatar - Lottery-022.jpg

          United States
          Member #17834
          June 28, 2005
          2083 Posts
          Offline
          Posted: December 30, 2005, 5:45 am - IP Logged

          Thank you hypersoniq

          Sounds interesting!!

          If I can help in any way please let me know

          Thanks

          PP

          Good luck to everyone!!!

            jordi marey's avatar - Lottery-039.jpg

            United States
            Member #17354
            June 17, 2005
            102 Posts
            Offline
            Posted: December 30, 2005, 9:33 am - IP Logged

            right now, the sheets available are the full bloated backtest versions so everyone can see the history of the system's performance and where the numbers come from. the biggest help right now would be to check the formulas in the last row and see if there is a way to do what I did faster or more efficiently, and to see if there are any errors that I overlooked.

            eventually I would like to get this don to a "production" version that has the state's game history on one worksheet and an interactive form on another that allows you to enter results and generate the next pick... any ideas there would be great ;-)

            Right now, I have observed the mechanism that breaks ties in picking the number most frequent always picks the lowest number in the tie, one thing I will be doing is altering this to see if the highest picks more winners. Another of my experiments is to take the pick4 sheet and re-do it for MASS lottery results to see how well it does in another state, remember, to use different data, you need to autofill ALL of the formulas from the last row up to the 3rd row.

             

            This looks really promising.  I want to help, if I can.  Will you create a simple step by step Legend for us to better understand what you have done and are doing.  So far, I am understanding that you have gone back through the PA daily Lottery Results by position and totaled the number of occurrences for each of the ten (0-9) that followed.  Then based on the digit that has followed most often,  will then become the predicted digit to play in that position? 

              cmpmcg25's avatar - 8ball
              Missouri
              United States
              Member #23091
              October 7, 2005
              262 Posts
              Offline
              Posted: December 30, 2005, 10:11 am - IP Logged

               hypersoniq, When you say entire history,Do you mean when the game frist started, Our we can go back 3 to 4 years to back check. 

                Snakeyes's avatar - 8579390479 65f71643cf_m.jpg
                Cleveland, Ohio
                United States
                Member #11445
                February 13, 2005
                1303 Posts
                Offline
                Posted: December 30, 2005, 10:18 am - IP Logged

                HQ, I'll upload it tonight and check out your calc's. I thought I was insane w/ Excel. LOL!

                Thanks for all you do.

                 

                Snakeyes

                  lottaloot's avatar - AvatarZ56
                  Redford/MI
                  United States
                  Member #3396
                  January 18, 2004
                  4867 Posts
                  Offline
                  Posted: December 30, 2005, 10:57 am - IP Logged

                  Looks good Hyper. 

                  L ttaL   T

                    Blackapple's avatar - nw rogue2.jpg
                    Wyncote,Pa
                    United States
                    Member #3206
                    January 3, 2004
                    60746 Posts
                    Offline
                    Posted: December 30, 2005, 12:36 pm - IP Logged

                    Thank you

                    Hypersoniq

                    Happy New YearsParty

                      Avatar
                      Richmond/Virginia
                      United States
                      Member #14154
                      April 21, 2005
                      20 Posts
                      Offline
                      Posted: December 30, 2005, 2:43 pm - IP Logged

                      System, is a great idea. Where do you in-put the two draws? You guys are great. Keep them coming!

                        hypersoniq's avatar - 8ball
                        Pennsylvania
                        United States
                        Member #1340
                        April 6, 2003
                        2450 Posts
                        Offline
                        Posted: December 30, 2005, 5:49 pm - IP Logged

                         hypersoniq, When you say entire history,Do you mean when the game frist started, Our we can go back 3 to 4 years to back check. 

                        honestly, I don't know yet. That's one thing that can be checked out, limiting the history to a few years (no meaningful data emerges for the first 400-500 draws though... picks are 000 or 0000)

                        Playing more than one ticket per game is betting against yourself.

                          hypersoniq's avatar - 8ball
                          Pennsylvania
                          United States
                          Member #1340
                          April 6, 2003
                          2450 Posts
                          Offline
                          Posted: December 30, 2005, 6:07 pm - IP Logged

                          jordi:

                          here is the column guide for the SB3 sheet, SB4 is similar...

                          A = Draw Number
                          B = Draw Date
                          C = Number entered as a Combo
                          D = First Digit of Combo in C (DRAW)
                          E = Second Digit of Combo in C
                          F = Third Digit of Combo in C
                          G = Digit Preceding Digit of D (PRECURSOR)
                          H = Digit Preceding Digit of E
                          I = Digit Preceding Digit of F
                          J = Digit Following D (ANNOUNCER-will read 000 for last draw)
                          K = Digit Following E
                          L = Digit Following F

                          M = First Position VERTICAL PAIR (column G digit*10 + column D digit)
                          N = Secondt Position VERTICAL PAIR (column H digit*10 + column E digit)
                          O = Third Position VERTICAL PAIR (column I digit*10 + column F digit)

                          P = Intentionally Blank (for readability)

                          Q-Z = number of times each digit in row 1 of Q-Z followed the vertical pair in M
                          AA = highest number in the Q-Z count range
                          AB = Intentionally Blank (for readability)
                          AC-AL = number of times each digit in row 1 of AC-AL followed the vertical pair in N
                          AM = highest number in the AC-AL count range
                          AN = Intentionally Blank (for readability)
                          AO-AX = number of times each digit in row 1 of AO-AX followed the vertical pair in O
                          AY = highest number in the AO-AX count range
                          AZ = Intentionally Blank (for readability)

                          BA = FIRST POSITION PICK for the next draw
                          BB = SECOND POSITION PICK for the next draw
                          BC = THIRD POSITION PICK for the next draw
                          BD-BF = Hit test, for example, if BA=M, then it is an X, otherwise blank
                          BG = counts "x"'s in BD-BF, 3's are straight hits! you can see the gaps by using Data: Filter: AutoFilter on this column to show only "3"s

                          Playing more than one ticket per game is betting against yourself.

                            hypersoniq's avatar - 8ball
                            Pennsylvania
                            United States
                            Member #1340
                            April 6, 2003
                            2450 Posts
                            Offline
                            Posted: December 30, 2005, 6:13 pm - IP Logged

                            rock50, I am not done that version yet... to make this work for new draws, add the next draw info to the bottom row and

                            IMPORTANT TO ALL USERS: YOU MUST hit F9 to Manually recalculate after ANY changes... auto-recalc was disabled to speed up development.

                            Playing more than one ticket per game is betting against yourself.

                              hypersoniq's avatar - 8ball
                              Pennsylvania
                              United States
                              Member #1340
                              April 6, 2003
                              2450 Posts
                              Offline
                              Posted: December 30, 2005, 6:59 pm - IP Logged

                              Another angle would be how to apply this type of system to jackpot games? can it be? the rules are totally different...

                              Something relatively easy with not too many numbers and no bonus ball... PA cash5 comes to mind as an early candidate, since it has a great deal of historical draws and the ball range is 1-39.

                              Playing more than one ticket per game is betting against yourself.