public void PredictBetBernoulliTimes()
{
var archive = new Archive();
var threeCons = 0;
var fourCons = 0;
var fiveCons = 0;
var sixCons = 0;
//var games = 511;
//for (var i = 1; i <= games; i++)
//{
// var resultArray = simulator.GenerateGameResult();
// archive.AddSequence(resultArray, i);
//}
var bet = archive.PredictSequence();
for (int i = 1; i < Editions; i++)
{
var sequence = simulator.GenerateGameResult();
//if (i % 10 == 0)
//{
bet = archive.PredictSequenceWithBernoulli(i);
//}
var result = Bettor.CheckResult(bet, sequence);
archive.AddSequence(sequence, i);
switch (result)
{
case 3:
threeCons++;
break;
case 4:
fourCons++;
break;
case 5:
fiveCons++;
break;
case 6:
sixCons++;
break;
default:
break;
}
}
var winsCount = threeCons + fourCons + fiveCons + sixCons;
Console.WriteLine($"Total plays: {Editions}, total wins: {winsCount}, total loses: {Editions - winsCount}, win times: {Math.Round((double)winsCount / (double)Editions, 8) * 100}%");
Console.WriteLine($"3 wons {threeCons}, times from total wins: {Math.Round((double)threeCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)threeCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"4 wons {fourCons}, times from total wins: {Math.Round((double)fourCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fourCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"5 wons {fiveCons}, times from total wins: {Math.Round((double)fiveCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fiveCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"6 wons {sixCons}, times from total wins: {Math.Round((double)sixCons / (double)winsCount, 8) * 100}%, chance to win: { Math.Round((double)sixCons / (double)Editions, 8) * 100}% ");
}
public void PredictEightBetsEachTenTimes()
{
var archive = new Archive();
var betsToPlayOnce = 42;
var bets = archive.PredictSequences(betsToPlayOnce);
var threeCons = 0;
var fourCons = 0;
var fiveCons = 0;
var sixCons = 0;
for (int i = 0; i < Editions; i++)
{
var sequence = simulator.GenerateGameResult();
//if (i % 1 == 0)
//{
bets = archive.PredictSequences(betsToPlayOnce);
//}
archive.AddSequence(sequence, i);
for (int b = 0; b < betsToPlayOnce; b++)
{
var res = Bettor.CheckResult(bets[b], sequence);
switch (res)
{
case 3:
threeCons++;
break;
case 4:
fourCons++;
break;
case 5:
fiveCons++;
break;
case 6:
sixCons++;
break;
default:
break;
}
}
}
var winsCount = threeCons + fourCons + fiveCons + sixCons;
Console.WriteLine($"Total plays: {Editions}, total wins: {winsCount}, total loses: {Editions - winsCount}, win times: {Math.Round((double)winsCount / (double)Editions, 8) * 100}%");
Console.WriteLine($"3 wons {threeCons}, times from total wins: {Math.Round((double)threeCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)threeCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"4 wons {fourCons}, times from total wins: {Math.Round((double)fourCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fourCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"5 wons {fiveCons}, times from total wins: {Math.Round((double)fiveCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fiveCons / (double)Editions, 8) * 100}%");
Console.WriteLine($"6 wons {sixCons}, times from total wins: {Math.Round((double)sixCons / (double)winsCount, 8) * 100}%, chance to win: { Math.Round((double)sixCons / (double)Editions, 8) * 100}% ");
}
public static Archive getExcelArchiveFile(string fileLocation)
{
var archive = new Archive();
//Create COM Objects. Create a COM object for everything that is referenced
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(fileLocation);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
//iterate over the rows and columns and print to the console as it appears in the file
//excel is not zero based!!
for (int i = 1; i <= rowCount; i++)
{
int[] seqence = new int[6];
for (int j = 1; j <= colCount; j++)
{
//new line
if (j == 1)
{
Console.Write("\r\n");
}
if (i > 1 && j >= 3 && j <= 8)
{
seqence[j - 3] = Int32.Parse(xlRange.Cells[i, j].Value2.ToString());
}
//write the value to the console
if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null)
{
Console.Write(xlRange.Cells[i, j].Value2.ToString() + "\t");
}
}
if (i > 1)
{
archive.AddSequence(seqence, i - 1);
}
}
//cleanup
GC.Collect();
GC.WaitForPendingFinalizers();
//rule of thumb for releasing com objects:
// never use two dots, all COM objects must be referenced and released individually
// ex: [somthing].[something].[something] is bad
//release com objects to fully kill excel process from running in the background
Marshal.ReleaseComObject(xlRange);
Marshal.ReleaseComObject(xlWorksheet);
//close and release
xlWorkbook.Close();
Marshal.ReleaseComObject(xlWorkbook);
//quit and release
xlApp.Quit();
Marshal.ReleaseComObject(xlApp);
return(archive);
}
static void Main(string[] args)
{
var simulator = new Simulator();
//int Editions = 20000;
//var archive = new Archive();
//var archiveGames = 5000;
//var attemptsToCompare = 100;
//var gamesToBeComparedIn = 10;
//var threeCons = 0;
//var fourCons = 0;
//var fiveCons = 0;
//var sixCons = 0;
//var bernWon = 0;
//var randWon = 0;
//var predWon = 0;
//for (int a = 1; a <= attemptsToCompare; a++)
//{
// archive.archive.Clear();
// archive.Initialize();
// for (int i = 1; i < archiveGames; i++)
// {
// var sequence = simulator.GenerateGameResult();
// archive.AddSequence(sequence, i);
// }
// var betPrediction = archive.PredictSequence();
// var betRandom = simulator.GenerateGameResult();
// var betBernoulli = archive.BestCombination(archiveGames);
// for (int i = 1; i <= gamesToBeComparedIn; i++)
// {
// bool won = false;
// var sequence = simulator.GenerateGameResult();
// var resultPred = Bettor.CheckResult(betPrediction, sequence);
// var resultRand = Bettor.CheckResult(betRandom, sequence);
// var resultBern = Bettor.CheckResult(betBernoulli, sequence);
// if (resultPred > 3)
// {
// predWon++;
// won = true;
// }
// if (resultRand > 3)
// {
// randWon++;
// won = true;
// }
// if (resultBern > 3)
// {
// bernWon++;
// won = true;
// }
// if (won)
// break;
// }
//}
//Console.WriteLine($"predicted wons {predWon}");
//Console.WriteLine($"radnom wons {randWon}");
//Console.WriteLine($"bern wons {bernWon}");
//Console.WriteLine($"win times: { Calculator.Bernoulli(0.01, 1000, 10) * 100}% ");
//Console.WriteLine($"win times: { Calculator.Bernoulli(0.01, 1000, 1) * 100}% ");
//var archive = new Archive();
//var betsToPlayOnce = 42;
//var threeCons = 0;
//var fourCons = 0;
//var fiveCons = 0;
//var sixCons = 0;
//int[][] bets = new int[betsToPlayOnce][];
//for (int i = 1; i <= Editions; i++)
//{
// var sequence = simulator.GenerateGameResult();
// if (i >= 1000)
// {
// if (i % 10 == 0) {
// Console.WriteLine($"Predicting for {i}, {Editions - i} remaining.");
// //bets = archive.PredictSequences(betsToPlayOnce);
// bets = archive.PredictSequencesWithBernoulli(betsToPlayOnce, i);
// }
// }
// archive.AddSequence(sequence, i);
// if (i >= 1000)
// {
// for (int b = 0; b < betsToPlayOnce; b++)
// {
// var res = Bettor.CheckResult(bets[b], sequence);
// switch (res)
// {
// case 3:
// threeCons++;
// break;
// case 4:
// fourCons++;
// break;
// case 5:
// fiveCons++;
// break;
// case 6:
// sixCons++;
// break;
// default:
// break;
// }
// }
// }
//}
//var winsCount = threeCons + fourCons + fiveCons + sixCons;
//Console.WriteLine($"Total plays: {Editions}, total wins: {winsCount}, total loses: {Editions - winsCount}, win times: {Math.Round((double)winsCount / (double)Editions, 8) * 100}%");
//Console.WriteLine($"3 wons {threeCons}, times from total wins: {Math.Round((double)threeCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)threeCons / (double)Editions, 8) * 100}%");
//Console.WriteLine($"4 wons {fourCons}, times from total wins: {Math.Round((double)fourCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fourCons / (double)Editions, 8) * 100}%");
//Console.WriteLine($"5 wons {fiveCons}, times from total wins: {Math.Round((double)fiveCons / (double)winsCount, 8) * 100}%, chance to win: {Math.Round((double)fiveCons / (double)Editions, 8) * 100}%");
//Console.WriteLine($"6 wons {sixCons}, times from total wins: {Math.Round((double)sixCons / (double)winsCount, 8) * 100}%, chance to win: { Math.Round((double)sixCons / (double)Editions, 8) * 100}% ");
//var casinoBlackOneFrom5 = Calculator.Bernoulli(0.5, 1, 1);
/*var totalNumbers = 10;
* var po4 = 4;
* var comb = Calculator.Combination(10, 4);
* var value = (double)(1 / comb);
* //var probSeq = ;
* var casinoBlackOneFrom5 = Calculator.Bernoulli(Calculator.HyperGeometricProbability(49, 6, 6, 6), 100, 1);
* Console.WriteLine((double)casinoBlackOneFrom5 * 100 + "%");
* Calculator.PrintProbabilityToOdds(casinoBlackOneFrom5);
*/
//// Probabilities to win in 6 from 49
//var seq = Calculator.Combinations(49, 6);
//var comb = Calculator.Combination(49, 6);
//var expectedWonTimes = Calculator.HyperGeometricProbability(49, 3, 6, 3);
//var chanceToWin4 = Calculator.HyperGeometricProbability(49, 4, 6, 4);
//var chanceToWin5 = Calculator.HyperGeometricProbability(49, 5, 6, 5);
//var chanceToWin6 = 1 / comb;
//Console.WriteLine((double)expectedWonTimes);
//Console.WriteLine((decimal)(double)chanceToWin4);
//Console.WriteLine((decimal)(double)chanceToWin5);
//Console.WriteLine((decimal)(double)chanceToWin6);
//Calculator.PrintProbabilityToOdds(expectedWonTimes);
//Calculator.PrintProbabilityToOdds(chanceToWin4);
//Calculator.PrintProbabilityToOdds(chanceToWin5);
//Calculator.PrintProbabilityToOdds(chanceToWin6);
//// Probabilities to win in 6 from 45
//comb = Calculator.Combination(45, 6);
//expectedWonTimes = Calculator.HyperGeometricProbability(45, 3, 6, 3);
//chanceToWin4 = Calculator.HyperGeometricProbability(45, 4, 6, 4);
//chanceToWin5 = Calculator.HyperGeometricProbability(45, 5, 6, 5);
//chanceToWin6 = 1 / comb;
//Console.WriteLine((double)expectedWonTimes);
//Console.WriteLine((decimal)(double)chanceToWin4);
//Console.WriteLine((decimal)(double)chanceToWin5);
//Console.WriteLine((decimal)(double)chanceToWin6);
//Calculator.PrintProbabilityToOdds(expectedWonTimes);
//Calculator.PrintProbabilityToOdds(chanceToWin4);
//Calculator.PrintProbabilityToOdds(chanceToWin5);
//Calculator.PrintProbabilityToOdds(chanceToWin6);
//// Probabilities to win in 5 from 36
//comb = Calculator.Combination(36, 5);
//expectedWonTimes = Calculator.HyperGeometricProbability(36, 3, 5, 3);
//chanceToWin4 = Calculator.HyperGeometricProbability(36, 4, 5, 4);
//chanceToWin5 = 1 / comb;
//chanceToWin6 = 1 / (comb * 4);
//Console.WriteLine((double)expectedWonTimes);
//Console.WriteLine((decimal)(double)chanceToWin4);
//Console.WriteLine((decimal)(double)chanceToWin5);
//Console.WriteLine((decimal)(double)chanceToWin6);
//Calculator.PrintProbabilityToOdds(expectedWonTimes);
//Calculator.PrintProbabilityToOdds(chanceToWin4);
//Calculator.PrintProbabilityToOdds(chanceToWin5);
//Calculator.PrintProbabilityToOdds(chanceToWin6);
//// Probabilities to win in KENO
//var seq2 = Calculator.Combination(60, 20);
//var chanceToWin10f10 = Calculator.HyperGeometricProbability(60, 10, 20, 10);
//var chanceToWin9f10 = Calculator.HyperGeometricProbability(60, 10, 20, 9);
//var chanceToWin8f10 = Calculator.HyperGeometricProbability(60, 10, 20, 8);
//var chanceToWin9f9 = Calculator.HyperGeometricProbability(60, 9, 20, 9);
//var chanceToWin8f9 = Calculator.HyperGeometricProbability(60, 9, 20, 8);
//var chanceToWin7f9 = Calculator.HyperGeometricProbability(60, 9, 20, 7);
//var chanceToWin8f8 = Calculator.HyperGeometricProbability(60, 8, 20, 8);
//var chanceToWin7f8 = Calculator.HyperGeometricProbability(60, 8, 20, 7);
//var chanceToWin7f7 = Calculator.HyperGeometricProbability(60, 7, 20, 7);
//Console.WriteLine(((double)seq2).ToString("N1", CultureInfo.InvariantCulture));
//Console.WriteLine((decimal)(double)chanceToWin10f10);
//Console.WriteLine((decimal)(double)chanceToWin9f10);
//Console.WriteLine((decimal)(double)chanceToWin8f10);
//Console.WriteLine((decimal)(double)chanceToWin9f9);
//Console.WriteLine((decimal)(double)chanceToWin8f9);
//Console.WriteLine((decimal)(double)chanceToWin7f9);
//Console.WriteLine((decimal)(double)chanceToWin8f8);
//Console.WriteLine((decimal)(double)chanceToWin7f8);
//Console.WriteLine((decimal)(double)chanceToWin7f7);
//Calculator.PrintProbabilityToOdds(chanceToWin10f10);
//Calculator.PrintProbabilityToOdds(chanceToWin9f10);
//Calculator.PrintProbabilityToOdds(chanceToWin8f10);
//Calculator.PrintProbabilityToOdds(chanceToWin9f9);
//Calculator.PrintProbabilityToOdds(chanceToWin8f9);
//Calculator.PrintProbabilityToOdds(chanceToWin7f9);
//Calculator.PrintProbabilityToOdds(chanceToWin8f8);
//Calculator.PrintProbabilityToOdds(chanceToWin7f8);
//Calculator.PrintProbabilityToOdds(chanceToWin7f7);
//// Probabilities to win in 12 from 24
//comb = Calculator.Combination(24, 12);
//expectedWonTimes = Calculator.HyperGeometricProbability(24, 12, 12, 12);
//chanceToWin4 = Calculator.HyperGeometricProbability(24, 12, 12, 0);
//Console.WriteLine((double)expectedWonTimes);
//Console.WriteLine((decimal)(double)chanceToWin4);
//Calculator.PrintProbabilityToOdds(expectedWonTimes);
//Calculator.PrintProbabilityToOdds(chanceToWin4);
var archive = new Archive();
//archive = Serializer.ReadFromBinaryFile<Archive>(@"D:\SerializedArchive636574971181534483.dat");
var archiveGames = 2000;
for (int i = 1; i <= archiveGames; i++)
{
var sequence = simulator.GenerateGameResult();
archive.AddSequence(sequence, i);
}
var comb = archive.BestCombination(archiveGames);
double _q = 1;
for (int i = 0; i < Constants.GameNumbersFallsOut; i++)
{
_q *= (Constants.GameNumbersFallsOut - i) / (double)(Constants.GameTotalNumbers - i);
}
var actualDiffInPerc = (double)(comb.ChanceToMeet / _q * 100) - 100;
for (int j = 0; j < comb.Value.Length; j++)
{
var postfix = (j == comb.Value.Length - 1) ? ".\n" : ", ";
Console.Write(comb.Value[j] + postfix);
}
archive.Print();
Console.WriteLine($"Bern {(double)comb.ChanceToMeet} vs average: {_q} more probable on {actualDiffInPerc}%");
//for (int i = 0; i < combos.Length; i++)
//{
// Console.WriteLine($"{10 - i}: ");
// for (int j = 0; j < combos[i].Length; j++)
// {
// var postfix = (j == combos[i].Length - 1) ? ".\n" : ", ";
// Console.Write(combos[i][j] + postfix);
// }
//}
//foreach (int[] c in Calculator.Combinations(Constants.GameNumbersFallsOut, Constants.GameTotalNumbers))
//{
// Console.WriteLine(string.Join(",", c));
// Console.WriteLine();
//}
/*
*
* var archive = new Archive();
* var threeCons = 0;
* var fourCons = 0;
* var fiveCons = 0;
* var sixCons = 0;
* //var games = 511;
*
* //for (var i = 1; i <= games; i++)
* //{
* // var resultArray = simulator.GenerateGameResult();
* // archive.AddSequence(resultArray, i);
* //}
*
* var combinationsToCheck = Constants.ChanceToMeetSixFromFourtyNine;
*
* var bet = simulator.GenerateGameResult();
* for (int i = 1; i <= combinationsToCheck; i++)
* {
* var sequence = simulator.GenerateGameResult();
* var result = Bettor.CheckResult(bet, sequence);
* //archive.AddSequence(sequence, i);
* switch (result)
* {
* case 3:
* threeCons++;
* break;
* case 4:
* fourCons++;
* break;
* case 5:
* fiveCons++;
* break;
* case 6:
* sixCons++;
* break;
* default:
* break;
* }
* }
*
* Console.WriteLine("Checked");
*
* var expectedWonTimes3 = Calculator.NumberOfWinningsForSubset(49, 6, 3);
* var expectedWonTimes4 = Calculator.NumberOfWinningsForSubset(49, 6, 4);
* var expectedWonTimes5 = Calculator.NumberOfWinningsForSubset(49, 6, 5);
*
* var expectedWonTimes6 = 1;
*
* var actual3diffInPerc = (double)(threeCons / expectedWonTimes3 * 100) - 100;
* var actual4diffInPerc = (double)(fourCons / expectedWonTimes4 * 100) - 100;
* var actual5diffInPerc = (double)(fiveCons / expectedWonTimes5 * 100) - 100;
* var actual6diffInPerc = (double)(sixCons / expectedWonTimes6 * 100) - 100;
*
* var winsCount = threeCons + fourCons + fiveCons + sixCons;
* Console.WriteLine($"Total plays: {combinationsToCheck}, total wins: {winsCount}, total loses: {Constants.ChanceToMeetSixFromFourtyNine - winsCount}, win times: {Math.Round((double)winsCount / (double)combinationsToCheck, 8) * 100}%");
*
* Console.WriteLine($"3 wons {threeCons} won times vs expected {(decimal)(double)expectedWonTimes3}. Difference (actual more than expected) is : {actual3diffInPerc}%");
* Console.WriteLine($"4 wons {fourCons} won times vs expected {(decimal)(double)expectedWonTimes4}. Difference (actual more than expected) is : {actual4diffInPerc}%");
* Console.WriteLine($"5 wons {fiveCons} won times vs expected {(decimal)(double)expectedWonTimes5}. Difference (actual more than expected) is : {actual5diffInPerc}%");
* Console.WriteLine($"6 wons {sixCons} won times vs expected {(decimal)(double)expectedWonTimes6}. Difference (actual more than expected) is : {actual6diffInPerc}%");
*/
}
