Results 1 to 2 of 2
 0 Attachment(s)    

Thread: Excel worksheet needed for coin toss simulation

  1. #1

    Default Excel worksheet needed for coin toss simulation

    I was wondering if a simple excel worksheet can be created to project the effects of applying different types of betting progressions to a user defined number of coin flip simulations.

    The user input a certain amount of capital and he begins with a bet of x% of this capital with a user defined progression set in the simulator, for example
    bet ratio 1-2-2-4-2-1 restarting at 1 at any stage if it is a win, and also switching the bet to the opposite side (H or T) at the next throw whenever it is a win but following the progression set on the same side (H or T) if it is a loss.

    I am interested to find out what are the maximum number of bets various progressions can enable the betting to go on before implosion, and create some statistics for different sample sizes of each type of progression(user defined).

    I would appreciate if anyone can help to create and post this excel worksheet. Thanks.
    Last edited by scalpmaster; 05-18-2009 at 22:18.

  2. #2

    Default

    Quote Originally Posted by scalpmaster View Post
    I was wondering if a simple excel worksheet can be created to project the effects of applying different types of betting progressions to a user defined number of coin flip simulations.

    The user input a certain amount of capital and he begins with a bet of x% of this capital with a user defined progression set in the simulator, for example
    bet ratio 1-2-2-4-2-1 restarting at 1 at any stage if it is a win, and also switching the bet to the opposite side (H or T) at the next throw whenever it is a win but following the progression set on the same side (H or T) if it is a loss.

    I am interested to find out what are the maximum number of bets various progressions can enable the betting to go on before implosion, and create some statistics for different sample sizes of each type of progression(user defined).

    I would appreciate if anyone can help to create and post this excel worksheet. Thanks.
    Excel for Dummies, here you go
    Excel Project

Similar Threads

  1. Get the value of the end of month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 15:18
  2. Max if month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 02:41
  3. How to do a proper simulation with renko chart
    By fxtester in forum MQL programming
    Replies: 0
    Last Post: 09-06-2014, 10:34
  4. EXCEL INDICATOR
    By ptcbuxz in forum Indicators
    Replies: 2
    Last Post: 02-09-2014, 13:50
  5. Worksheet Expert Advisors
    By Schuarzfx in forum Ideas for expert advisors
    Replies: 1
    Last Post: 08-03-2010, 21:46

Tags for this Thread

index, sample, simple

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •