tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 6th, 2015 at 6:59:50 AM permalink
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
......
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 6th, 2015 at 7:15:12 PM permalink
hi, Romes,

are u there?

it is well known that you know everything about blackjack.

can u help with up needed?
UCivan
UCivan
  • Threads: 84
  • Posts: 843
Joined: Sep 3, 2011
November 6th, 2015 at 7:35:16 PM permalink
May be your friend also asked another person? Check this out?

A Similar Request on WOO
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 7th, 2015 at 9:14:18 AM permalink
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?
charliepatrick
charliepatrick
  • Threads: 39
  • Posts: 2998
Joined: Jun 17, 2011
November 7th, 2015 at 12:23:11 PM permalink
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.
ThatDonGuy
ThatDonGuy
  • Threads: 122
  • Posts: 6594
Joined: Jun 22, 2011
November 7th, 2015 at 2:32:04 PM permalink
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.
Ibeatyouraces
Ibeatyouraces
  • Threads: 68
  • Posts: 11933
Joined: Jan 12, 2010
November 7th, 2015 at 2:37:34 PM permalink
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.
DUHHIIIIIIIII HEARD THAT!
charliepatrick
charliepatrick
  • Threads: 39
  • Posts: 2998
Joined: Jun 17, 2011
November 7th, 2015 at 2:50:36 PM permalink
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....

Dl: T55 Pl: 7T D:20 P:17 Lose
Dl: T9 Pl: 89 D:19 P:17 Lose
Dl: 7K Pl: 233532 D:17 P:18 Win
Dl: 967 Pl: J52 D:0 P:17 Win
Dl: T Pl: 75T D:10 P:-1 Lose
Dl: 9J Pl: T7 D:19 P:17 Lose
Dl: A7 Pl: 669 D:18 P:21 Win
Dl: 46T Pl: 66/Q (6)8 D:20 P:16 Lose P:14 Lose
Dl: 4Q7 Pl: 56dJ D:21 P:21 Tie dbl
Dl: Q Pl: 448T D:10 P:-1 Lose
Dl: 676 Pl: 44/5d3 (4)T D:19 P:12 Lose dbl P:14 Lose
Dl: 9K Pl: TT D:19 P:20 Win
Dl: AT Pl: 9A D:111 P:20 Lose
Dl: 598 Pl: TT D:0 P:20 Win
Dl: 7725 Pl: KK D:21 P:20 Lose
Dl: 5K5 Pl: 4Ad5 D:20 P:20 Tie dbl
Dl: KJ Pl: J7 D:20 P:17 Lose
Dl: 286K Pl: Q6 D:0 P:16 Win
Dl: 6466 Pl: 5Q D:0 P:15 Win
Dl: T9 Pl: Q63 D:19 P:19 Tie
Dl: J Pl: 94AAQ D:10 P:-1 Lose
Dl: KK Pl: A35 D:20 P:19 Lose
Dl: 2724Q Pl: 55d3 D:0 P:13 Win dbl
UCivan
UCivan
  • Threads: 84
  • Posts: 843
Joined: Sep 3, 2011
November 7th, 2015 at 3:20:46 PM permalink
I would agree this is what he wanted. Player plays basic strategy, playing 10,000 hands.
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 8th, 2015 at 1:25:31 AM permalink
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.
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 13th, 2015 at 11:10:09 PM permalink
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?
UCivan
UCivan
  • Threads: 84
  • Posts: 843
Joined: Sep 3, 2011
November 14th, 2015 at 9:27:33 AM permalink
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.
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
November 14th, 2015 at 9:58:32 AM permalink
Like this (second card is dealer's up-card, # is for split, doubles, doubles after split and surrender according to basic strategy)?
Player: D8/SJ # C8/H3/H4 # C8/C2/D7 # H8/HA, Dealer: D6/C2/C2/S2/C4/C2
Player: D8/D3/HA, Dealer: D5/DK/SA/H6
Player: D7/D9, Dealer: S6/CK
Player: HA/HJ, Dealer: HA/S9
Climate Casino: https://climatecasino.net/climate-casino/
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 14th, 2015 at 10:11:10 AM permalink
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.
tomchina123
tomchina123
  • Threads: 43
  • Posts: 305
Joined: Aug 26, 2015
November 14th, 2015 at 10:16:19 AM permalink
yes, it is like this.

i will need it to be put excel.

and see wins and loses shown clearly in excel.
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
November 14th, 2015 at 10:16:41 AM permalink
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.
Climate Casino: https://climatecasino.net/climate-casino/
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
November 14th, 2015 at 10:20:08 AM permalink
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.
Climate Casino: https://climatecasino.net/climate-casino/
  • Jump to: