can anyone help with blackjack simulation card/win-lose data

can anyone help with blackjack simulation card/win-lose data? i have a friend, who asked me for this.

it can be CSM or manually.
it is like this:

player wins: player: 6,7,8, dealer: 8,5,T.
dealer wins: Player: 4,6, double, 5 dealer: 6,7,5
.....

at least 10000, hands.

i cannot find them in wizardofodds, i can only find baccarat data:
Following are 1000 randomly generated baccarat shoes. The shoe contained six decks and was dealt until the number of cards remaining in the shoe was less than 6. Following are the fields in each comma delimited record.

Field 1: Winning outcome (P = Player win, B = Banker win, T = Tie win)
Field 2: Point value of banker hand
Field 3: Point value of player hand
Field 4: Point value of banker's first card
Field 5: Point value of banker's second card
Field 6: Point value of banker's third card if taken, x otherwise
Field 7: Point value of player's first card
Field 8: Point value of player's second card
Field 9: Point value of player's third card if taken, x otherwise

Shoe Number 1

B,9,1,0,9,x,1,0,x
P,2,7,4,8,0,0,5,2
B,6,2,6,0,x,0,0,2
P,0,6,0,0,0,0,6,x
B,7,0,1,4,2,3,2,5
P,0,9,6,4,x,0,9,x
B,8,6,2,6,x,1,5,x
P,0,4,2,8,0,0,1,3
P,3,7,9,4,0,4,0,3
T,4,4,4,6,4,1,0,3
B,9,5,2,7,x,1,4,x
P,8,9,4,4,x,0,9,x
P,0,4,0,0,0,1,3,0
P,4,9,9,5,x,5,4,x
B,8,6,4,6,8,0,6,x
B,3,0,1,0,2,2,1,7
B,9,6,8,1,x,8,8,x
B,9,7,9,0,x,2,5,x
T,2,2,8,4,0,7,5,0
P,2,4,8,4,0,0,0,4
P,5,7,2,3,x,4,0,3
P,6,9,7,9,x,2,7,x
P,0,8,5,5,x,0,8,x
P,6,7,6,0,x,2,5,x
B,7,2,0,7,x,0,0,2
B,8,5,2,6,x,7,8,x
B,9,5,0,9,x,8,7,x
B,8,5,0,8,x,4,1,x
P,8,9,7,1,x,0,9,x
B,6,3,9,7,x,9,4,0
P,1,9,1,0,x,9,0,x
B,9,2,6,3,x,2,0,x
B,7,6,3,4,x,6,7,3
P,0,3,0,0,0,6,7,0
P,2,5,3,9,0,0,0,5
P,2,8,2,0,x,8,0,x
B,8,1,1,7,x,0,1,x
P,8,9,0,8,x,2,7,x
B,4,3,0,1,3,0,3,0
B,9,6,0,9,x,6,0,x
B,8,2,0,0,8,9,5,8
B,9,5,0,0,9,2,0,3
B,5,0,0,5,x,0,0,0
P,4,7,0,3,1,7,0,x
B,9,7,5,5,9,1,6,x
P,7,9,7,0,x,4,8,7
B,8,0,1,7,x,5,5,x
B,8,2,8,0,x,0,2,x
B,9,1,3,6,x,3,8,x
B,6,5,0,6,x,5,0,0
T,7,7,1,6,x,8,3,6
B,9,6,6,3,x,5,1,x
B,8,5,5,3,x,5,0,x
B,7,0,7,5,5,0,0,0
P,0,5,5,9,6,2,0,3
B,7,6,7,0,x,6,0,x
T,3,3,7,7,9,9,2,2
P,0,9,0,0,0,6,6,7
B,3,1,2,1,0,7,4,0
P,2,8,9,3,x,0,8,x
B,9,7,0,9,x,9,8,x
B,8,0,4,4,x,1,9,x
T,8,8,8,0,x,0,8,x
P,3,7,0,3,0,0,1,6

Banker Wins = 34
Player Wins = 25
Tie Wins = 5

Shoe Number 2

P,4,8,0,4,x,4,4,x
B,5,2,6,8,1,0,0,2
B,9,5,0,0,9,7,3,5
P,3,7,0,0,3,0,0,7
B,6,0,7,9,x,4,7,9
P,5,7,0,0,5,8,2,7
B,9,7,4,5,x,5,2,x
B,9,0,1,2,6,1,9,0
P,1,8,0,1,x,2,6,x
B,9,4,0,9,x,0,4,x
B,7,6,7,0,x,2,0,4
......

hi, Romes,

are u there?

it is well known that you know everything about blackjack.

can u help with up needed?

May be your friend also asked another person? Check this out?

A Similar Request on WOO

maybe.

i guess there is some one in this forum, who is smart and generous, and hard working, and will publish it for free.

like Wizard and Romes.

especially Romes, he is so powerful and an expert in blackjack.

hi, Romes,

will u take this challenge?

Quote: tomchina123

...is some one in this forum, who is smart and generous, and hard working, and will publish it for free...

There are probably quite a few who could generate this type of info - but not necessarily for free. Remember some people here make a living for providing advice on gaming and have probably developed simulators as part of their work. The other thing, only based on info I have seen, is that these things are either to confirm House Edge, countability issues or used during the initial design of a game. I'm guessing they typically only look at one hand versus the dealer - certainly that's all I've done.

Quote: tomchina123

i guess there is some one in this forum, who is smart and generous, and hard working, and will publish it for free.

Why is everybody looking at me like that?

I'm confused as to what the original post wants. Does he (assuming a male) want 10,000 hands dealt out and shown card-by-card, with notes as to when the player doubled (and, presumably, split)?

Note that this would require some assumptions as to what strategy to use.

Quote: ThatDonGuy

Why is everybody looking at me like that?

I'm confused as to what the original post wants. Does he (assuming a male) want 10,000 hands dealt out and shown card-by-card, with notes as to when the player doubled (and, presumably, split)?

Note that this would require some assumptions as to what strategy to use.

He confused you with Don S. on BJTF.

Quote: ThatDonGuy

....Does he (assuming a male) want 10,000 hands dealt out and shown card-by-card, with notes as to when the player doubled (and, presumably, split)?...

Who knows? Perhaps something like this....

I would agree this is what he wanted. Player plays basic strategy, playing 10,000 hands.

yes, that is right. best be like wizard's way, of doing bacarrat:

500 computer generated baccarat shoes using eight decks. (1.2 MB)

Following are 1000 randomly generated baccarat shoes. The shoe contained eight decks and was dealt until the number of cards remaining in the shoe was less than 6. Following are the fields in each comma delimited record.

Shoe Number 1
B,9,7,4,0,5,7,0,x
B,8,7,4,1,3,8,3,6
B,8,6,0,8,x,0,6,x
P,2,8,0,2,x,4,4,x
B,5,3,4,1,x,0,4,9
P,0,2,9,1,0,2,0,0
T,8,8,0,8,x,9,9,x
B,3,2,2,0,1,6,6,0
P,0,6,7,5,8,6,0,x
P,8,9,6,2,x,0,9,x
T,0,0,0,0,0,9,5,6
B,9,6,4,9,6,1,5,x
B,7,1,7,0,x,0,0,1
T,7,7,0,7,x,1,0,6
B,9,8,9,0,x,0,8,x
B,6,2,4,6,6,2,0,0
P,1,7,0,0,1,7,0,x
B,2,0,8,2,2,0,2,8
B,8,6,2,1,5,5,9,2
B,8,2,7,1,x,9,3,x
B,4,0,4,0,x,4,6,0
B,8,6,2,2,4,7,9,x
P,6,8,0,6,x,3,5,x
P,0,8,7,3,0,1,9,8
B,9,0,2,7,x,0,0,x
P,6,7,0,0,6,0,7,x
B,7,3,9,8,x,9,5,9
B,9,7,5,4,x,0,7,x
T,8,8,3,5,x,2,6,x
B,7,5,8,9,x,5,0,0
T,6,6,7,9,x,0,6,x
B,9,4,8,1,x,0,4,x
B,7,4,0,7,x,0,4,0
B,9,6,0,9,x,0,6,x
B,9,6,3,1,5,0,2,4
P,4,8,6,8,x,0,8,x
B,7,6,7,0,x,0,6,x
B,7,6,0,7,x,8,8,x
B,9,0,9,0,x,0,0,x
P,2,6,2,0,0,3,0,3
P,4,6,1,3,0,6,0,x
T,2,2,5,8,9,0,3,9
B,9,3,9,0,x,0,3,x
P,4,6,8,4,2,8,8,x
P,6,7,0,6,x,2,0,5
B,9,6,2,3,4,1,0,5
B,8,6,0,8,x,4,2,x
B,7,5,4,3,x,7,5,3
P,1,7,7,4,0,7,0,x
B,6,2,0,0,6,0,1,1
P,3,8,8,5,x,1,7,x
B,5,2,6,6,3,5,0,7
P,3,5,2,8,3,6,9,0
P,4,6,8,6,x,5,0,1
B,9,5,0,0,9,4,1,0
B,7,2,9,8,x,0,0,2
P,0,9,3,7,x,0,9,x
P,7,8,8,9,x,1,0,7
B,5,4,0,5,0,6,4,4
P,0,9,0,0,x,8,1,x
B,6,4,4,2,x,0,3,1
P,2,9,1,0,1,0,2,7
P,0,5,6,4,0,5,0,0
T,6,6,3,3,x,6,0,x
T,0,0,0,0,0,7,3,0
B,9,0,4,5,x,4,6,x
P,1,5,0,1,0,0,0,5
B,9,3,9,5,5,8,3,2
P,5,6,0,5,0,2,4,x
P,3,9,6,7,x,3,6,x
P,3,6,1,2,0,8,4,4
B,8,7,9,2,7,0,7,x
B,9,5,0,1,8,0,5,0
P,5,6,0,0,5,8,7,1
B,5,0,3,2,0,0,3,7
B,8,7,3,0,5,7,0,x
B,7,4,4,0,3,9,3,2
P,3,8,3,0,x,8,0,x
P,6,9,9,7,x,4,5,x
B,7,6,7,0,x,3,2,1
P,0,8,0,0,x,8,0,x
T,3,3,2,0,1,3,0,0
B,6,4,5,1,x,5,0,9

Banker Wins = 44
Player Wins = 30
Tie Wins = 9

Shoe Number 2

B,9,6,4,0,5,0,1,5
B,5,1,3,8,4,3,2,6
P,0,7,5,5,0,2,1,4
...

500 shoes,

to analyse dragon 7. i used doc to have picked all dragon 7, actually.

,0,0,7,
,0,0,7,
,2,8,7,
,0,0,7,
,0,4,3,
,1,0,6,
,3,0,4,
,9,2,6,
,4,6,7,
,3,7,7,
,0,2,5,
,0,3,4,
,2,8,7,
,0,0,7,
,5,5,7,
,0,3,4,
,0,0,7,
,3,8,6,
,3,0,4,
,4,9,4,
,4,6,7,
,0,0,7,
,7,4,6,
,3,9,5,
,0,0,7,
,0,1,6,
,2,0,5,
,2,0,5,
,0,2,5,
,2,0,5,
,3,0,4,
,0,2,5,
,6,7,4,
,0,2,5,
,0,0,7,
,8,3,6,
,3,0,4,
,0,0,7,
,6,4,7,
,0,3,4,
,8,2,7,
,0,3,4,
,6,4,7,
,5,8,4,
,7,8,2,
,3,0,4,
,8,4,5,
,1,0,6,
,7,6,4,
,8,3,6,
,5,9,3,
,5,8,4,
,0,4,3,
,0,3,4,
,0,0,7,
,6,7,4,
...


for this blackjack data,
if it is like this, it is the best. then it is easy to be put them into excel...

maybe it is not free. i still am hopeful.

i got an offer, to pay USD240.

to get csm blackjack data.

i can do any quantity of hands into excel by the software, with all cards and wins and loses,

is it a good buy?

It's a good buy if

(a) they are exactly what you want - right numbers in exact format (i.e., number, suits, formats, etc)
(b) you will get some type of monetary returns equal to or higher than the cost
(c) you are happy to have a enjoyable toy to play with (no more anxieties) till your next curiosity

Get some sample results, like 100 hands, first before placing the whole order.

Like this (second card is dealer's up-card, # is for split, doubles, doubles after split and surrender according to basic strategy)?

thanks.

i like your way of putting language. you must be a very logical person. and with kind and easy assumption.

i will consider about it.

i will try to firstly to simulate by excel random number. like 1-13, then i put 11,12,12 into 10. because i just want to do csm. it should be ok?

i actually have finished dealer's hands.

for player, it is kind of difficult, because there are split, double, surrender and so on.

i have finished just now the double one:

=IF(H2=11,(IF(OR(S2=2,S2=3,S2=4,S2=5,S2=6,S2=7,S2=8,S2=9),"double")),(IF(H2=10,(IF(OR(S2=2,S2=3,S2=4,S2=5,S2=6,S2=7,S2=8,S2=9),"double")),(IF(H2=9,(IF(OR(S2=3,S2=4,S2=5,S2=6),"double")))))))
=IF(S2=3,(IF(A2=1,(IF(OR(B2=6,B2=7),"double",IF(S2=3,(IF(B2=1,(IF(OR(A2=6,A2=7),"double"))))))))),IF(S2=4,(IF(A2=1,(IF(OR(B2=4,B2=5,B2=6,B2=7),"double",IF(S2=4,(IF(B2=1,(IF(OR(A2=4,A2=5,A2=6,A2=7),"double"))))))))),IF(S2=5,(IF(A2=1,(IF(OR(B2=2,B2=3,B2=4,B2=5,B2=6,B2=7),"double",IF(S2=5,(IF(B2=1,(IF(OR(A2=2,A2=3,A2=4,A2=5,A2=6,A2=7),"double"))))))))),IF(S2=6,(IF(A2=1,(IF(OR(B2=2,B2=3,B2=4,B2=5,B2=6,B2=7),"double",IF(S2=6,(IF(B2=1,(IF(OR(A2=2,A2=3,A2=4,A2=5,A2=6,A2=7),"double")))))))))))))
macao rule.

not sure if i can finish all and maybe too much time taking, then i will consider just buying it.

yes, it is like this.

i will need it to be put excel.

and see wins and loses shown clearly in excel.

Quote: tomchina123

=IF(H2=11,(IF(OR(S2=2,S2=3,S2=4,S2=5,S2=6,S2=7,S2=8,S2=9),"double")),(IF(H2=10,(IF(OR(S2=2,S2=3,S2=4,S2=5,S2=6,S2=7,S2=8,S2=9),"double")),(IF(H2=9,(IF(OR(S2=3,S2=4,S2=5,S2=6),"double")))))))
=IF(S2=3,(IF(A2=1,(IF(OR(B2=6,B2=7),"double",IF(S2=3,(IF(B2=1,(IF(OR(A2=6,A2=7),"double"))))))))),IF(S2=4,(IF(A2=1,(IF(OR(B2=4,B2=5,B2=6,B2=7),"double",IF(S2=4,(IF(B2=1,(IF(OR(A2=4,A2=5,A2=6,A2=7),"double"))))))))),IF(S2=5,(IF(A2=1,(IF(OR(B2=2,B2=3,B2=4,B2=5,B2=6,B2=7),"double",IF(S2=5,(IF(B2=1,(IF(OR(A2=2,A2=3,A2=4,A2=5,A2=6,A2=7),"double"))))))))),IF(S2=6,(IF(A2=1,(IF(OR(B2=2,B2=3,B2=4,B2=5,B2=6,B2=7),"double",IF(S2=6,(IF(B2=1,(IF(OR(A2=2,A2=3,A2=4,A2=5,A2=6,A2=7),"double")))))))))))))
macao rule.

not sure if i can finish all and maybe too much time taking, then i will consider just buying it.

A CSM is not the same as an infinite deck model, which is what you are attempting to do above.

Quote: tomchina123

yes, it is like this.

i will need it to be put excel.

and see wins and loses shown clearly in excel.

What does "win" and "lose" mean when there are multiple splits and doubles after splits? It's not a binary game. You can win one hand and lose the next and be up 7 units (7.5 if surrender is allowed). Another example, you can win one hand and lose the next and be down 6.5 units. Or, you can win one and lose one and be ahead 0.5 units. Fixating on winning or losing hands is a nearly meaningless exercise.

The easiest way to build a model of blackjack (if you don't want to actually code the game) is simply to use the result distribution (as available at https://wizardofodds.com/games/blackjack/appendix/4/ ), generate a random number between 0 and 1, and use that random number together with the distribution to generate the final payout of the hand.