Thread Rating:

Artemis
Artemis
Joined: Nov 20, 2010
  • Threads: 20
  • Posts: 441
July 31st, 2015 at 1:51:50 PM permalink
I need some help from an Excel-expert in order to convert Wizard's simulation data.

Hello Guys, will an Excel-expert do me a favor?

Will you write me an excel macro program to extract the Wizard's Baccarat simulations into a standard output like the sample in the linked excel spreadsheet?

I'm able to import a simulation into my excel spreadsheet, but it will take me too long to convert the data manually. That's why I ask you for your help.


Please click on this link. It will take you to my Excel spread sheet. You can write your macro program in there.
https://docs.google.com/spreadsheets/d/18WqP37r-Z5kvt-9wKdepPDl8u40tZI3vRnCLufPeWss/edit?usp=sharing
I'm OK with Corps which pick and choose clienteles. Both insurance companies and casinos have the right to pick and choose customers. They may keep profitable ones and kicked out the rest. But, I'm not OK with a casino supervisor who says counting cards... is like stealing food from a buffet (a foodlifting offense), or video-taping a movie in a cinema (a piracy offense).
RS
RS
Joined: Feb 11, 2014
  • Threads: 62
  • Posts: 8623
July 31st, 2015 at 2:39:59 PM permalink
Seems interesting. I hate excel, but might be able to write a script (not in excel) to do what you're trying to do.


Basically you're doing columns of streaks? Whenever the streak is broken by a Tie, then T is the bottom-est value in that column? If it's broken by Player or Banker, the newest value is the first value in the next column? What about a streak of Ties? What would the following look like?:

BBTPTTTBPTB



Also, what is the purpose of doing this?
Artemis
Artemis
Joined: Nov 20, 2010
  • Threads: 20
  • Posts: 441
July 31st, 2015 at 7:09:47 PM permalink
Quote: RS

Seems interesting. I hate excel, but might be able to write a script (not in excel) to do what you're trying to do.


Basically you're doing columns of streaks? Whenever the streak is broken by a Tie, then T is the bottom-est value in that column? If it's broken by Player or Banker, the newest value is the first value in the next column? What about a streak of Ties? What would the following look like?:

BBTPTTTBPTB



Also, what is the purpose of doing this?



BBTPTTTBPTB would be extracted and reformatted as follows:





Trust, but verify. The purpose is to confirm or refute a Bac-Expert's claim. For example, the expert recommends to wait until the Banker pops up 4 times before placing a bet on the Player. Hey, is he right or wrong? Well, he's right based on this scorecard.


But, Wizard sez to test it out with his 250,000 simulated eight-deck shoes before wasting money.

Quote: Wizard


Commandment#6

Thou shalt not believe in betting systems

For every one legitimate gambling writer there are a hundred charlatans trying to sell worthless betting systems promising an easy way to beat the casinos. I know it sounds like a cliché, but if it sounds too good to be true it probably is.

....Simulations....
Before you go and waste your money with a betting system in the casinos, test it out on my 250,000 simulated eight-deck shoes.

I'm OK with Corps which pick and choose clienteles. Both insurance companies and casinos have the right to pick and choose customers. They may keep profitable ones and kicked out the rest. But, I'm not OK with a casino supervisor who says counting cards... is like stealing food from a buffet (a foodlifting offense), or video-taping a movie in a cinema (a piracy offense).
mustangsally
mustangsally
Joined: Mar 29, 2011
  • Threads: 25
  • Posts: 2463
August 1st, 2015 at 10:04:05 AM permalink
Quote: Artemis

The purpose is to confirm or refute a Bac-Expert's claim. For example, the expert recommends to wait until the Banker pops up 4 times before placing a bet on the Player.

hehehehe
a Bac-Expert
so funny...

but please for the record name that Expert!


haha
==============================++<<>>==

the myth of this
is when some use
like
notepad++
to count the patterns (this has been known for some time)

and when this is done 1st (count)
B,B,B,B, <<< this means there will be another decision

and
B,B,B,B,T
B,B,B,B,P
B,B,B,B,B

B,B,B,B,P is the clear winner by far!!
I mean BIG TIME WINNER!!!!!!!!!!

try it you will see and rest old Excel for computing

but it is poor counting as it should first count these
T,B,B,B,B,
P,B,B,B,B,

where a clear switch has occurred

try it for free
my notepad++ version was free and i love it!
so much faster than Excel too in counting these patterns

the best way to know what will follow this
P,B,B,B,B,
is to track all the cards that have been removed and calculate the winning probs
if they are higher than from the 1st round
go with the higher
or gamble and flip a coin


have fun with test test test
Mully
I Heart Vi Hart
mustangsally
mustangsally
Joined: Mar 29, 2011
  • Threads: 25
  • Posts: 2463
June 27th, 2018 at 9:04:33 AM permalink
Quote: Artemis

The purpose is to confirm or refute a Bac-Expert's claim.
For example,
the expert recommends to wait until the Banker pops up 4 times before placing a bet on the Player.
Hey, is he right or wrong? Well, he's right based on this scorecard.

He is wrong, yes.
(sample size too small or expert looked at different data)
as to what bet has the over all highest probability to win the very next hand (without card counting)

using notepad++ (stopped using windows notepad years ago) to count
over the Wizard new 250k shoe collection (and I thought my Mom has lots of shoes!)
(sequence:count)
BBBBB:217576
BBBBP:379259
now BBBBP could be in a streak of Bs

so we need to count this way (as the scorecard records)
TBBBBB:36501 <<<<still winner and champ B
TBBBBP:35634

PBBBBB:171913 <<<<still winner and champ B
PBBBBP:163922

so the Wizard 250k shoes shows after a Banker 'pop' of 4
B is more likely to be the very next winner
Quote: Artemis

But, Wizard sez to test it out with his 250,000 simulated eight-deck shoes before wasting money.

As to the OP request of having Excel do the work
here is what I have (can be adjusted too in the vba code)
I have a T in it's own column (because I like it that way!)
I do NOT have long streaks going to the right (but the code can do it)

now,
a snap of what I get (I am using the Wizards shoes.


I 1st remove the commas after placing the shoe string (!!) in Excel B1
in a working only sheet (this is easily done in notepad++)


next run the macro SplitBTPstring (each version of Excel I think has it's own way to get to the macros)

results place in column A (sweet!) in a split-split second

next run the macro BigRoadBaccaratScorecard

results ready for you to do (I move them into a final sheet)


*****sorry, I tried to place place my Excel in Google Docs for any one to download if wanted
but Google removes the macros. (Excel does it too)
hope one knows how to install/use a macro (it is actually very easy. Instructions on the web)
the 2 macros here
Sub SplitBTPstring()

Dim str As String
str = Cells(1, 2).Value 'place string in cell B1

For i = 1 To Len(str)
'output string 1 character at a time to column A (A1)
Cells(i, 1).Value = Mid(str, i, 1)
Next i

End Sub

Sub BigRoadBaccaratScorecard()

Dim Rng As Range, Dn As Range, Temp As String, c As Long, ac As Long, i As Long

Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
ac = 2 '1st cell print to is C1

For Each Dn In Rng
If Not Temp = Dn.Value Then
c = 0: i = 0: ac = ac + 1
End If
c = c + 1

If c > 50 Then 'adjust value to have long streaks turn right
i = i + 1: Cells(50, ac + i) = Dn.Value
Else
Cells(c, ac) = Dn.Value
End If

Temp = Dn.Value
Next Dn
End Sub

I also have a macro that takes the BTP string and turns it into column A in Excel
I do that 1st
then run the BigRoad macro to complete the scorecard

hope some can use this
and no, I am not an Excel vba expert
that is why I stopped doing this project
I really wanted the macro to create the complete sheet instead of just shoes at a time
maybe I get back to it

Sally
I Heart Vi Hart

  • Jump to: