bacmac
bacmac
Joined: Feb 3, 2020
  • Threads: 1
  • Posts: 3
February 3rd, 2020 at 6:28:16 PM permalink
Hello everyone, is there any one smart and kind enough to set up a simple Baccarat simulator using Excel or whatnot? The shoe simulator should generate 25,000+ shoes at a time, using eight decks, following all the rules, have a cut card beginning and end of shoes and each shoe should have around 75 hands. The result should be random as possible and use each card but doesn't need to show the actual card values in the results. It only needs to have the shoe number and B,P,T for banker, player and tie.

1BPPPPTBPBBPTPBPBP..........
2PPPBBBBPPPBTTPBPBPPT........
3PBBBPBPT........
..........
........
25000PPBBTPTPPB.......

I've already used 250,000 and 100,000 shoes i found online. I wish to have more samples. Thank you.
Ace2
Ace2
Joined: Oct 2, 2017
  • Threads: 24
  • Posts: 1118
February 3rd, 2020 at 6:58:26 PM permalink
What are you trying to count/analyze? Streaks ?
Itís all about making that GTA
Wizard
Administrator
Wizard
Joined: Oct 14, 2009
  • Threads: 1399
  • Posts: 23628
February 4th, 2020 at 5:23:18 AM permalink
One can just use the probabilities of each winning outcome (player, banker, or tie) from my site and map a random number from Excel to get a random outcome.
It's not whether you win or lose; it's whether or not you had a good bet.
bacmac
bacmac
Joined: Feb 3, 2020
  • Threads: 1
  • Posts: 3
February 4th, 2020 at 7:41:55 AM permalink
Can you please walk me thru a little more? I dont really know how to use excel and i want to get a few million shoes for my sample. thank you.
7craps
7craps
Joined: Jan 23, 2010
  • Threads: 18
  • Posts: 1977
February 4th, 2020 at 9:20:35 AM permalink
Quote: bacmac

The result should be random as possible and use each card

"random as possible" should mean, as one is simply shuffling the 8 decks of cards, 1 of the possible shoe orderings
from all 416! possible shoes and not have a duplicate(s).

416! is a very large number (911 digits long)
and with many duplicate value cards one could look at fewer possible shufflings that will produce the BPT sequence.
416! / ((32!)^9 * (128!)) = 377 digits
164944883791287598411943116655903865118824068362
983914007087347084013829196364680846614865667459
022964650355867714652074291682596726831437397546
695056560355540746705637562240501155776567564785
022522219704232111595011221458008894065762070053
057540438153207938737327767112605303189053871399
047436327387252956448398946650681893111055183549
42178373831442020424406884197134050000000

some shoes will produce the very same BPT sequence
(possibly a fun math exercise.
How many possible BPT sequences, following normal rules, are there from 8 deck Bacc shoe?)
and these must be considered as being possible

your request for more samples seems to be a very LARGE waste of time
as you may seem to be trying to solve a problem or many problems that do not require 'sample shoes'.
winsome johnny (not Win some johnny)
bacmac
bacmac
Joined: Feb 3, 2020
  • Threads: 1
  • Posts: 3
February 4th, 2020 at 2:03:22 PM permalink
I don't understand surely what you're saying.. I just want a sample of two million shoes.. I figured it wouldn't be too complicated by using Excel
charliepatrick
charliepatrick
Joined: Jun 17, 2011
  • Threads: 34
  • Posts: 2495
February 4th, 2020 at 4:11:14 PM permalink
Quote: bacmac

...I dont really know how to use excel and i want to get a few million shoes for my sample. thank you.

It may be easier to write a program than use excel. To do it properly you need to good random number generator and the one in excel, certainly in older versions, might not be good enough.

One possible approach is to generate lots of random numbers and use rank to shuffle the deck (e.g. RANK=1-8 = As etc.) Then work your way through the shoe working out each hand. The problem is you need to ensure you don't keep repeating the same shoes as bad RNG's tend to have a cycle. Personally I shuffle the deck by swapping cards rather than creating a new one each time.

  • Jump to: