Coin Flip Portfolio
motivated by a comment from my wife

I was explaining the dozens of different Buy & Sell schemes over our morning coffee and my wife grunted: "Why not just flip a coin."
It was a rhetorical question, but it sounded like an interesting idea, so I ...

>Aw, c'mon You're not going to flip a coin.
That's exactly what I'm going to do.
I'll download ten years worth of monthly stock prices and see what happens if I start with, say $100K in Cash and flip a coin each month to decide whether I BUY or SELL.
If I SELL, I'm 100% Cash. When my coin says "BUY", I buy ... provided I have Cash on hand. If ...

>So you're either 100% in the stock or 100% Cash, right?
Exactly ... except you can stick your Cash into Money Market and give yourself some small interest rate.
The spreadsheet looks like this:

>Huh? Coin-Flip wins 76% of the time? You kidding?
Okay, this is what happens:
Each time you press F9 you get another bunch of 120 coin flips. ... because there are 120 months in 10 years.
BUT, if you click the Who Wins? button you'll get 100 sets of 120 coin flips and the number of times (out of 100 trials) that the Coin-Flip Portfolio wins.
That's where I get: Coin-Flip wins 76% of the time. See?

>Do you expect anybuddy to actually use that system?
It's cheaper than paying a manager, right?
Actually, I think that's really funny ... and my wife is still laughing!

>But what about during a bull market?
Speak up! I can't hear you!

>And what about transaction fees?
Huh? What's that?


d'Alembert's Scheme
motivated by e-mail from Clive

Here's an interesting modification of the coin-toss-all-Cash-all-Stock ritual ... it's a betting scheme attributed to d'Alembert
>d'Alem-who?
A French mathematician, physicist and philosopher. His betting scheme goes like this:
  • You bet $B.
  • If you win you decrease your bet by $1.
  • If you lose, you increase your bet by $1.
>That's a winning scheme?
It says you should increase your bet when you lose, hoping to win the next time to cover your loss      
... then decrease your bet when you win so you get to keep some of your winnings.

d'Alembert Betting (starting at $20): Lose, Win, Lose, Lose, Win ... etc.
>Example?
Okay, here are some examples where X = +1 means a Win and X = -1 means a Loss.
The POT is what you end up with after each bet, starting with a $20 bet and playing 8 times:
See how it goes?
To identify a win or a loss at the kth bet, we assume that X(k) = +1 if we Win and X(k) = -1 if we Lose.
Then, starting with a first bet of B(1), our Bet#2 would be B(2) = B(1) - X(1)
... so we're decreasing (or increasing) our bet by X(1) when we Win (or Lose).
Then Bet#3 would be: B(3) = B(2) - X(2) = B(1) - X(1) - X(2).
After 2 Wins, we'd be betting B(1) - 2. After a Win and a Loss we'd be betting B(1) again. After 2 Losses we'd be betting B(1) + 2.

Our winnings after 3Bets is:
W(3) = X(1) B(1) + X(2) B(2) + X(3) B(3) = X(1) B(1) + X(2) [ B(1) - X(1) ] + X(3) [ B(1) - X(1) - X(2) ].
That is: W(3) = B(1) [ X(1)+X(2)+X(3) ] - [ X(1) X(2) + X(1) X(3) + X(2) X(3) ].

For 4Bets. We have:
W(4) = B(1) [ X(1)+X(2)+X(3)+X(4)] - [ X(1) X(2)+X(1) X(3)+X(1) X(4)+X(2) X(3) +X(2) X(4)+X(3) X(4)]

XBetWin
Lose
POT
1202020
-119-191
1202021
1191940
-118-1822
1191941
1181859
1171776
XBetWin
Lose
POT
1202020
-119-191
-120-20-19
-121-21-40
12222-18
-121-21-39
-122-22-61
-123-23-84
XBetWin
Lose
POT
-120-20-20
-121-21-41
12222-19
-121-21-40
12222-18
-121-21-39
-122-22-61
12323-38


Observations:
  1. The final value of our winnings does NOT depend of the order in which the wins and losses occur.
    That is, Win, Win, Lose gives the same final POT as Win, Lose, Win  or  Lose, Win, Win.
  2. For the 3Bets example, there are 4 possibilities: 3 Wins, 2 Wins, 1 Win and 0 Wins.
  3. The values of X(1), X(2) and X(3) which give these 4 possibilities are 1,1,1 and 1,1, -1 and 1, -1, -1 and -1, -1, -1:
  4. 3 Wins gives   POT3 = 3 B(1) -3
    2 Wins gives   POT2 = B(1) + 1
    1 Wins gives   POT1 = -B(1) + 1
    0 Wins gives   POT0 = -3 B(1) - 3
    The possibilities are illustrated below:
    XBetWin
    Lose
    POT
    1202020
    1191939
    1181857
    XBetWin
    Lose
    POT
    1202020
    1191939
    -118-1821
    XBetWin
    Lose
    POT
    1202020
    -119-191
    -120-20-19
    XBetWin
    Lose
    POT
    -120-20-20
    -121-21-41
    -122-22-63
    Note: By "POT" we're referring to our winnings after umpteen bets. If POT>0 we've made money.
  5. Note, however, the possibe POTs are not equally likely.
    In a jillion games (each with 3 bets), 2 Wins and 1 Win will each occur 3/8 of the time whereas 3 Wins or 0 Wins will each occur 1/8 of the time.
  6. In general, the frequency with which each Win/Loss sequence occurs is given by the Binomial Coefficients.
    For 3Bets, they're: 1, 3, 3, 1  and  4Bets they're 1, 4, 6, 4, 1  and  5Bets they're 1, 5, 10, 10, 5, 1
  7. The "Expected" value of W(3) (in the 3Bet game) is then weighted by the frequency of occurrence and is proportional to:
    3C3 POT3 + 3C2 POT2 + 3C1 POT1 + 3C0 POT0   where mCn are the Binomial Coefficients: mCn = m! / n! (m-n)!
  8. Now look again at 4Bets. We have:
    W(4) = B(1) [ X(1)+X(2)+X(3)+X(4)] - [ X(1) X(2) + X(1) X(3) + X(1) X(4) + X(2) X(3) + X(2) X(4) + X(3) X(4)]
  9. 4 Wins gives   POT4 = 4 B(1) - 6
    3 Wins gives   POT3 = 2B(1)
    2 Wins gives   POT2 = 2
    1 Wins gives   POT1 = -2B(1)
    0 Wins gives   POT0 = -4 B(1) - 6
    The possibilities are illustrated below:
    XBetWin
    Lose
    POT
    1202020
    1191939
    1181857
    1171774
    XBetWin
    Lose
    POT
    1202020
    1191939
    1181857
    -117-1740
    XBetWin
    Lose
    POT
    1202020
    1191939
    -118-1821
    -119-192
    XBetWin
    Lose
    POT
    1202020
    -119-191
    -120-20-19
    -121-21-40
    XBetWin
    Lose
    POT
    -120-20-20
    -121-21-41
    -122-22-63
    -123-23-86
  10. Note that, although the Binomial Coefficients are symmetrical, the final POTs are NOT!!
  11. In the 3Bets example, out of a jillion trials, we'd expect to get POT3, POT2, POT1 and POT0 with a relative frequency of 1, 3, 3, 1.
    That'd give an "Expected" POT of (1/8) [3 B(1) -3] + (3/8) [B(1) + 1] + (3/8) [-B(1) + 1] + (1/8) [-3 B(1) - 3] = 0.
  12. In the 4Bets example, we'd expect to get POT4, POT3, POT2, POT1 and POT0 with a relative frequency of 1, 4, 6, 4, 1.
    That'd give an "Expected" POT of (1/16) [4 B(1) - 6] + (4/16) [2B(1)] + (6/16) [2] + (4/16) [-2B(1)] + (1/16) [-4 B(1) - 6] = 0.
>zzzZZZ
Don't you see? In d'Alembert, you're expected to break even.

>Huh? Then why would anybuddy use that scheme?
To enjoy the game without losing a fortune, eh? And who knows? For short periods you could win.

You can try the spreadsheet:


I might mention the following:

d'Alembert was a great mathematician who turned his back on Theology.
He is also known for incorrectly arguing that the probability of a coin landing heads increased every time that it came up tails.
I imagine the following discussion:
gummy, taking a coin from his pocket: "If I toss this coin, what's the probability that it'll come up heads?"
d'Alembert, with a grunt: "It's 50%, of course!"
gummy, grinning: "Oh ... I forgot to mention that, last week, I tossed this very same coin a hundred times and it came up tails, every time."
d'Alembert, with a grunt: "In that case the probability of coming up heads is much greater."
gummy, expressing surprise: "Are you saying that the coin remembers what happened last week?"
d'Alembert, with a grunt: "No ... but God does!"