BreakThrough In Coin Toss System

[scalpmaster]

Hi all,

appreciate if anyone can create this excel spreadsheet simulation:

User input:

T= Total number of tosses, e.g. T=1000

W=Winning probability% of each toss e.g. 0.5 (= fair)

N = number of latest tosses without the occurrence of 2 consecutive Heads or Tails e.g, N=7

e.g, For bets on Heads (vice-versa for Tails),

If there is No occurrence of 2 Consecutive Heads within the last N=7 tosses, then on the next appearance of a Head (could be one or more tosses after N),
place first bet 1 on the next toss on Heads.

If Heads appears on next toss, +1 is added to Balance Total(cycle ends), otherwise, 1 is subtracted.
If Tails subsequently continues to appear, do not place next bet until the next Head appears.

When that Heads appears, place bet 2 on the next toss on Heads.
If Heads appears on next toss, +2 is added to Balance Total(cycle ends), otherwise, 2 is subtracted.
If Tails subsequently continues to appear, do not place next bet until the next Head appears.

When that Heads appears, place bet 4 on the next toss on Heads.
If Heads appears on next toss, +4 is added to Balance Total, otherwise, 4 is subtracted.
CYCLE ENDs here regardless it is a win or loss.

Wait for the next No occurrence of 2 Consecutive Heads or Tails within the latest N=7draws to start the new cycle.

Plot Balance Total chart over T number of tosses.

Thanks,
Scalpmaster

[MarvinP]

Hi Scalpmaster and welcome to the forum,

I'm sure many of our members could write the above code. But instead have you read?
http://en.wikipedia.org/wiki/Feller%...sing_constants
or
http://en.wikipedia.org/wiki/Coin_flipping
or
http://en.wikipedia.org/wiki/Gambler%27s_fallacy
If you really want us to work on the code, let us know you have done your homework before we do ours.

[scalpmaster]

If you really want us to work on the code, let us know you have done your homework before we do ours.

Thanks for the theoretical references but only an excel simulation can reveal much more...

[MarvinP]

And what more would it reveal?

[scalpmaster]

whether it is a spiral down or up type system, and observe conditions/signs when it breaks down...so that limitation can be impose on the parameters...

[romperstomper]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

[scalpmaster]

No one helped.

[romperstomper]

No-one helped yet. Doesn't mean you can ignore the rules, so I suggest you add a link to your other post(s).

[scalpmaster]

http://www.ozgrid.com/forum/showthre...401#post527401

Considering the skill and level of expertise of Excel experts, this should be relatively easy...some probably already have similar spreadsheets that just need some modification...

[romperstomper]

And the MrExcel link?

[scalpmaster]

Please close this thread here I have received reponses elsewhere.

[romperstomper]

Please read and follow the rules before posting again. All forums I know of have much the same rules as regards cross posting.

[Paul]

The U.S. Treasury Department has literally spent hours and tax dollars on calculating the best odds for coin flips. Their report states that after 13,241 consecutive coin flips landing on tails, the next 437 flips are guaranteed to be heads due to the amount of metal that rubbed/chipped off of the tails side. The 438th flip could go either way.

They also concluded that 32.7% of statistics are made up, and that artichokes taste more purple than yellow. (Although they have referred that last fact to the Food and Drug Administration for follow-up.)

Have a wonderful day!