StrangeMage
StrangeMage
  • Threads: 3
  • Posts: 30
Joined: Oct 22, 2015
October 22nd, 2015 at 11:04:51 AM permalink
I was about to brazenly email the wizard directly with this question, but after I came across MULTIPLE warnings that he is not a personal math tutor I shied away, and alas I am here. Hopefully this catches his eye some how, or another math fiend on this forum will be able to help me.

I want to learn to analyze side bets and learn if things are count-able and how profitable they are. I'm very interested in the math, and moderately interested in the money :P.

I've started with the lucky lady's (blackjack) side bet, and have successfully recreated the same house advantage that Shackleford has calculated on his website Wizard of Odds (although his results differ slightly from Jacobson's on APheat). Now, my next question is "Can I determine EoR using Excel?" I am much more proficient with Excel than C (I have some experience, but limited), but I was hoping I could analyze EoR and develop count systems using Excel. I would be be pretty comfortable writing in VBA if necessary.
Romes
Romes
  • Threads: 29
  • Posts: 5600
Joined: Jul 22, 2014
October 22nd, 2015 at 11:20:21 AM permalink
Well hello StrangeMage, and welcome to the forums. You made the right call not directly emailing/messaging the Wizard. There are a lot of very mathematically advanced members on the forums here who can help point you in the right direction.

I won't go too far down the math road, but what I can tell you is you're doing all the right things but they're not necessary.

The lucky lady side bet is a well known side bet with certain pay tables and HE associated. There has also been extensive research done to show when the side bet becomes profitable to the player (Hi/Low TC +6.5). Lastly, you don't need to create a new count. Simply use the Tens count (profitable at TC +6, pending the number of decks). This will be more accurate for your insurance correlation, and it will provide you a more accurate counting method to attack the Lucky Ladies side bet. There are even very slight variations with all of the math outcomes shown on apheat.net. Simply google "card counting lucky ladies" and it'll be the first hit.

More/less every side bet has been mathematically analyzed by one professional or another (The Wiz, Dr. Jacobson, etc). Unless you want to re-do the math from an educational/experimental standpoint there's really no reason to reinvent the wheel, in my opinion. There's also extensive math analysis on pretty much every beatable side bet there is today, all one would do is google how to beat <insert side bet name here>.
Playing it correctly means you've already won.
MathExtremist
MathExtremist
  • Threads: 88
  • Posts: 6526
Joined: Aug 31, 2010
October 22nd, 2015 at 11:32:52 AM permalink
Quote: StrangeMage

I've started with the lucky lady's (blackjack) side bet, and have successfully recreated the same house advantage that Shackleford has calculated on his website Wizard of Odds (although his results differ slightly from Jacobson's on APheat). Now, my next question is "Can I determine EoR using Excel?" I am much more proficient with Excel than C (I have some experience, but limited), but I was hoping I could analyze EoR and develop count systems using Excel. I would be be pretty comfortable writing in VBA if necessary.

You will quickly outgrow VBA in Excel. You can do it, but it's the wrong tool for the job.
Still, if you want to use Excel for doing EoR analysis, what I'd do is make your analysis based on the dynamically-computed contents of a deck as depicted in a range of cells, rather than hard-coded numbers in your formulas. You'll need 52 for suit-dependent bets like LL, so just have a 52-long column of numbers, with 6 in each for a six-deck game. Have some summations and do your EV analysis based on those summations. Then to do EoR analysis, just set one of the cells to 5 and see how things change.
"In my own case, when it seemed to me after a long illness that death was close at hand, I found no little solace in playing constantly at dice." -- Girolamo Cardano, 1563
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
October 22nd, 2015 at 11:42:25 AM permalink
Quote: StrangeMage

I've started with the lucky lady's (blackjack) side bet, and have successfully recreated the same house advantage that Shackleford has calculated on his website Wizard of Odds (although his results differ slightly from Jacobson's on APheat.

Please be specific. Which results differ?
Climate Casino: https://climatecasino.net/climate-casino/
DJTeddyBear
DJTeddyBear
  • Threads: 207
  • Posts: 10992
Joined: Nov 2, 2009
October 22nd, 2015 at 1:33:28 PM permalink
Quote: teliot

Please be specific. Which results differ?

As a new member, you might not recognize the teliot username. He's Eliot Jacobson.
I invented a few casino games. Info: http://www.DaveMillerGaming.com/ ————————————————————————————————————— Superstitions are silly, childish, irrational rituals, born out of fear of the unknown. But how much does it cost to knock on wood? 😁
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
October 22nd, 2015 at 3:45:10 PM permalink
Quote: DJTeddyBear

As a new member, you might not recognize the teliot username. He's Eliot Jacobson.

Hey, you gave away my real identity! (Kidding)
Climate Casino: https://climatecasino.net/climate-casino/
StrangeMage
StrangeMage
  • Threads: 3
  • Posts: 30
Joined: Oct 22, 2015
October 23rd, 2015 at 7:36:54 AM permalink
I posted this amidst the middle of my work. I know realize that Shackleford used a permutational analysis and you used a combinational analysis. The number of ways to hit a QhQhvsBJ was different between your two analysis, as well as the total number of possible hands. I was comparing 6deck. Shack has 135360 (I got the same), you got 33840 = (6*5*(4*6)*(16*6-2))/2. However you both came to the same house edge. The permutational analysis makes more sense to me intuitively. For example, I can't seem to understand how you got 27,588,756 for total number of hands. Shack's answer of 9,294,695,280 to me is an obvious (52*6) nPr (4).

Same results, different method. My bad.

I'm sure the way I'm calculating these aren't the most efficient way. They're clunky and plenty of room for error. I'm using a permutational analysis to determine EoR, and it seems like I have the correct EoR for 2-8, but I'm a little off on 10, A and 9. Checking my work today.

I'm realizing my method will be extremely limited when it comes to analyzing side bets for play based side bets (bust it, lucky stiff, buster bonus etc). I think once I think I've got a good handle on this, I guess it's time to figure out how to simulate these games and add side bet rules.
StrangeMage
StrangeMage
  • Threads: 3
  • Posts: 30
Joined: Oct 22, 2015
October 23rd, 2015 at 7:38:30 AM permalink
Quote: MathExtremist

You will quickly outgrow VBA in Excel. You can do it, but it's the wrong tool for the job.
Still, if you want to use Excel for doing EoR analysis, what I'd do is make your analysis based on the dynamically-computed contents of a deck as depicted in a range of cells, rather than hard-coded numbers in your formulas. You'll need 52 for suit-dependent bets like LL, so just have a 52-long column of numbers, with 6 in each for a six-deck game. Have some summations and do your EV analysis based on those summations. Then to do EoR analysis, just set one of the cells to 5 and see how things change.



Thanks @MathExtremist , I think I'll give this a try.
teliot
teliot
  • Threads: 43
  • Posts: 2871
Joined: Oct 19, 2009
October 23rd, 2015 at 8:06:29 AM permalink
Quote: StrangeMage

I posted this amidst the middle of my work. I know realize that Shackleford used a permutational analysis and you used a combinational analysis. The number of ways to hit a QhQhvsBJ was different between your two analysis, as well as the total number of possible hands. I was comparing 6deck. Shack has 135360 (I got the same), you got 33840 = (6*5*(4*6)*(16*6-2))/2. However you both came to the same house edge. The permutational analysis makes more sense to me intuitively. For example, I can't seem to understand how you got 27,588,756 for total number of hands. Shack's answer of 9,294,695,280 to me is an obvious (52*6) nPr (4).

I've never heard the expression "permutational analysis," though surely I've solved some problems that way.

My method was to run four nested loops:

For 2 decks:
player_card_1: 1 to 104 
player_card_2: player_card_1 + 1 to 104
dealer_card_1: 1 to 104
continue if dealer_card_1 equal to player_card_1 or player_card_2
dealer_card_2: dealer_card_1 + 1 to 104
continue if dealer_card_2 equal to player_card_1 or player_card_2
score the quadruple (pc1, pc2, dc1, dc2)
This code examines combin(104,2)*combin(102,2) = 27,588,756 quadruples. To me, that seems to be the right answer for the number of combinations in the cycle.
Climate Casino: https://climatecasino.net/climate-casino/
miplet
miplet
  • Threads: 5
  • Posts: 2105
Joined: Dec 1, 2009
October 23rd, 2015 at 12:39:32 PM permalink
Not sure if it will help, but I have copies of my blackjack side bet spreadsheets at http://miplet.net/blackjack/ . They're all deck composition editable. Feel free to ask any questions.
“Man Babes” #AxelFabulous
777
777
  • Threads: 31
  • Posts: 727
Joined: Oct 7, 2015
October 24th, 2015 at 11:25:06 AM permalink
Quote: miplet

Not sure if it will help, but I have copies of my blackjack side bet spreadsheets at http://miplet.net/blackjack/ . They're all deck composition editable. Feel free to ask any questions.



Thanks for sharing.
StrangeMage
StrangeMage
  • Threads: 3
  • Posts: 30
Joined: Oct 22, 2015
October 26th, 2015 at 10:33:33 AM permalink
Quote: MathExtremist

You will quickly outgrow VBA in Excel. You can do it, but it's the wrong tool for the job.
Still, if you want to use Excel for doing EoR analysis, what I'd do is make your analysis based on the dynamically-computed contents of a deck as depicted in a range of cells, rather than hard-coded numbers in your formulas. You'll need 52 for suit-dependent bets like LL, so just have a 52-long column of numbers, with 6 in each for a six-deck game. Have some summations and do your EV analysis based on those summations. Then to do EoR analysis, just set one of the cells to 5 and see how things change.



MathExtremist, what do you recommend is the best tool for the job? I have a good grasp on calculating house edge and EoR for simple side bets now. However, I'm wanting to run some simulations on typical count systems to see if I can reproduce the same results.
StrangeMage
StrangeMage
  • Threads: 3
  • Posts: 30
Joined: Oct 22, 2015
October 26th, 2015 at 10:38:01 AM permalink
Quote: miplet

Not sure if it will help, but I have copies of my blackjack side bet spreadsheets at http://miplet.net/blackjack/ . They're all deck composition editable. Feel free to ask any questions.



Thank you miplet, this was extremely helpful. A question on your busterbj analysis. How did you determine the number of possible ways of busting? It looks like this list was generated not manually.
miplet
miplet
  • Threads: 5
  • Posts: 2105
Joined: Dec 1, 2009
October 26th, 2015 at 4:09:06 PM permalink
Quote: StrangeMage

Thank you miplet, this was extremely helpful. A question on your busterbj analysis. How did you determine the number of possible ways of busting? It looks like this list was generated not manually.

I wrote a program for that. And because I'm Evil™, I used PHP. Highly un-commented code is here.
“Man Babes” #AxelFabulous
  • Jump to: