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.

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.

February 3rd, 2020 at 6:58:26 PM
permalink

What are you trying to count/analyze? Streaks ?

It’s all about making that GTA

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.

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.

February 4th, 2020 at 9:20:35 AM
permalink

"random as possible" should mean, as one is simply shuffling the 8 decks of cards, 1 of the possible shoe orderingsQuote:bacmacThe result should be random as possible and use each card

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)

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

February 4th, 2020 at 4:11:14 PM
permalink

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.Quote:bacmac...I dont really know how to use excel and i want to get a few million shoes for my sample. thank you.

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.