The EuroMillions Predictor is a simple application that collects some statistics from the past EuroMillions results and tries to guess which numbers/combinations could be more successful on future draws.
- createdb euromillions-predictor -U postgres
- ... EuroMillionsPredictor db migrate src/main/resources/conf.yaml
- src/main/resources/dumps/restore.sh
- bug in combinations (MathHelper) for 30C3
- check formulas with distinct template or no template return similar results
- review prizes after draw >= 991
- fix crons
- move web driver to resources
Create draw record in migrations.xml with stars and numbers Drop DB Migrate DB Run the Draw Prizes integration tests to generate the prized migrations XML Drop DB Migrate DB Restore DB Run the DrawStatsManagerIntegrationTest Run the DrawTemplatesManagerIntegrationTest Run the FormulasStatsManagerIntegrationTest Update the DRAW_ID in the dump.sh file Dump DB
src/main/resources/dumps/dump.sh src/main/resources/dumps/restore.sh
dropdb -U postgres euromillions-predictor createdb -U postgres euromillions-predictor
TensorFlow
- https://medium.com/google-cloud/how-to-do-time-series-prediction-using-rnns-and-tensorflow-and-cloud-ml-engine-2ad2eeb189e8
- http://mourafiq.com/2016/05/15/predicting-sequences-using-rnn-in-tensorflow.html
| Formula | Wins | Winnings | Earnings | Earning Factor | Points (Numbers+Stars) |
|---|---|---|---|---|---|
| S(ITSIS)S.N(RF-RI)N | 3 | 27.21 | 2.21 | 0.0890 | (0+0) 0 < (1+0) 1 < (0+0) 0 < (1+0) 1 < (2+1) 3 < (0+0) 0 < (0+1) 1 < (1+0) 1 < (2+0) 2 < (1+2) 3 |
| S(ILIS)S.N(RF-RI)N | 3 | 27.21 | 2.21 | 0.0889 | (0+0) 0 < (1+0) 1 < (0+0) 0 < (1+0) 1 < (2+1) 3 < (0+0) 0 < (0+1) 1 < (1+0) 1 < (2+0) 2 < (1+2) 3 |
| S(ISIS)S.N(RF-RI)N | 3 | 27.21 | 2.21 | 0.0889 | (0+0) 0 < (1+0) 1 < (0+0) 0 < (1+0) 1 < (2+1) 3 < (0+0) 0 < (0+1) 1 < (1+0) 1 < (2+0) 2 < (1+2) 3 |
| S(ITLIS)S.N(RF-RI)N | 3 | 27.21 | 2.21 | 0.0889 | (0+0) 0 < (1+0) 1 < (0+0) 0 < (1+0) 1 < (2+1) 3 < (0+0) 0 < (0+1) 1 < (1+0) 1 < (2+0) 2 < (1+2) 3 |
SELECT formula_name AS name, COUNT(*) AS draws, SUM(costs) AS costs, SUM(CASE WHEN winnings > 0 THEN 1 ELSE 0 END) AS wins, SUM(winnings) AS winnings, SUM(earnings) AS earnings, AVG(earnings_factor) AS earnings_factor, string_agg(points, ' < ' ORDER BY draw_id DESC) AS points
FROM formulas_stats
WHERE draw_id >= 1072 AND draw_id <= 1081
GROUP BY formula_name
HAVING COUNT(*) = 10 AND AVG(earnings_factor) > 0 AND SUM(CASE WHEN winnings > 0 THEN 1 ELSE 0 END) > 0
ORDER BY SUM(CASE WHEN winnings > 0 THEN 1 ELSE 0 END) DESC, AVG(earnings_factor) DESC, formula_name ASC
LIMIT 100;