I would like to automate a search and return script of historical winning results. I want an interface to enter the parameters. The results are to be displayed and exported.
Looking for a contractor to do this. Read on.
A script to search Pick 3 and Pick 4 lottery databases by winning number or date, retrieving a specified number of consecutive winning numbers before or after the search date.
A number search of historical results in State A will produce prior winning dates for that number. Those dates will be used to search historical results in State B. A specified number of results before and after the date will be retrieved from State B historical data. The number of results preceding and proceeding the date will be specified by user as integers, range 0 to 25.
ILLUSTRATION
1. Choose state and number. [Example State = Maryland, Number = 232 Game = Pick 3. Maryland is State A in this example]
2. Search Maryland past results (all history) for dates of all instances of 232. [Example: July 14, 1980, March 3, 1981, …] NOTE: the resultant dates will be used to search past results of other state(s).
3. Choose another state, State B, and search past results for each date returned above. For each date retriieve the consecutive “x” number of results prior and “y” number of results after the date, where x and y are integers ranging from 1 to 25. Should be able to set a defaults for x and y. [For demonstration purposes, we use the dates listed above: July 14, 1980 and March 3, 1981
State B = Illinois, Game = Pick 3, with 2 drawings per day
Date July 14, 1980
July 15, 1980: 732, 487
July 16, 1980: 860, 221 ….
If n = 5, we get. 732, 487, 860, 221, 861 (this 861 not actual. Included for later reference)
Date March 3, 1981
March 4, 1981: 861, 458
March 5, 1981: 347, 274
If n = 5, we get. 861, 458, 347, 274, 487 (this 487 not actual. Included for later reference)
If there were 21 past instances of 232 in Maryland, there would be 21 sets of data collected from Illinois.
Summary at end:
1. Total Number of dates = integer [Ex: 21]
2. list repeated numbers, if any
3. For each, list / display:
- number of sets in which it appeared
- search date (not date of result) and position within the consecutive results.
Total sets: 21
Repeated:
861. Repeated = 2 of 21
Position 5, July 14, 1980
Position 1, March 3, 1981
487 Repeated = 2 of 21
Position 2, July 14, 1980
Position 5, March 3, 1981
So, this creates a new table date. Table is based on chosen index states and index numbers. In our example that would be Maryland and 232.
The database grows with each variation of index state and index number, as well as with every chosen comparative state. In this example, the Index State = Maryland, Index number = 232, and the Comparative State = Illinois. There can be multiple comparatives states, with a corresponding search and data retrieved from past results of each. The data derived from each comparative state analyzed separately.
I want to be able to go back and add comparative states to an existing index state and index number at any time.
INPUTS:
1. Index State
2. Game: Pick 3 or Pick 4 (Pick 3 is default)
3. Index number (validate based on game. 3 digits required for Pick 3 and 4 digits for Pick 4)
>>> this will yield dates of prior occurrences of index number. Those dates will be used to search comparison state past results.
4. Comparative State
5. Number of results prior to date
6. Number of results after date
>>> using dates from State A search, search past results of appropriate Game in State B, retrieving consecutive winning numbers as specified.