Request for Blackjack card counting Trainer

[dareeldill]

My apologies if this is posted in the wrong category. I'm looking to build a card counting trainer for blackjack. I am posting here as I think it will definitely require a decent VBA code.

Ideally, for my purposes, I think building it inside of a User Form would be ideal. It will be pretty basic. Choose how many decks, which will determine how many cards in play (i.e. 1 deck = 52 cards, double deck = 104 cards, 8 decks = 416 cards, etc.). Press one button to draw a random card. As the cards are drawn, the user will keep track of the count of the hand. The user can press a button to revel the current count to determine if they are correct.

First of all, before I build the code, has anybody seen any existing spreadsheets, user forms, VBA codes, etc. for this purpose? No point in building it if there is a free version out there somewhere that I can access.

I know there are phone apps and programs out there, but for my purposes, I need to do a version through excel.

[6StringJazzer]

Have you done a web search? When I search for "VBA Blackjack" I get a half a million hits.

You said "before you build the code". What do plan to do yourself, and what do you need our help with? Or at this point are you just asking us if we know of an existing program?

[dareeldill]

I have done searches very similar. I find a lot of blackjack simulators that calculate edge or test basic strategy but not many that test exclusively for high low card counting, at least in the way I want to do it.

My plan if I can’t find anything existing, is to build my own simulator so a person can test their ability to keep the count of cards at a faster and faster pace.

I’ve done similar programs years ago for Baccarat and remember having issues with the randomization of the cards. Eventually I know that may be a struggle. But I’m not quite there yet. So at this point I’m asking if anyone has seen anything specifically related to card counting.

[6StringJazzer]

As a Moderator I am just going to preempt any objections to the question by saying that card counting is not illegal, it's just a technique that casinos don't like because it takes away the house advantage. So this is a legitimate question.