Sambian,
You were kind enough to share some of your ideas, so I'll let you know some observations on your simulation that I believe are flawed.
First off, I'm no expert on Forex, but it appears your conversion ratios are backwards. For instance, you have 1/2 the dollar amount on Fcell
multiplied by usd/eur ratio (cell c(n)) to get euros (cell e(n))? It should be multiplied by eur/usd (b(n)) to convert to euros. Unless I'm very wrong, this is a major error. And there are similar other conversion errors as well.
Secondly, I'm starting to understand some of the other arguments regarding paths made thus far. You simply assume one binary uniform random variable which is eur/usd and invert to get usd/eur. That is not a good way to model the real behavior, for one it misses the intermediate paths to get to double or half. For two, it ignores the dependency on the underlying instruments. The better method would be two generate two independent random walks for eur and dol, then ratio the resulting indexes relative to those results. If you make the random walks gbm/gaussian, you'll find that the net re-balancing scheme is no better than a random walk itself (i.e. not riskless at all).
You started out with some very good seeds, but unless I'm missing something, I don't think the end result was anything spectacular.
If you get a chance, try the above and see if you agree or disagree.
I appreciate your sharing your ideas though, you are on to some good ones.
You were kind enough to share some of your ideas, so I'll let you know some observations on your simulation that I believe are flawed.
First off, I'm no expert on Forex, but it appears your conversion ratios are backwards. For instance, you have 1/2 the dollar amount on Fcell
multiplied by usd/eur ratio (cell c(n)) to get euros (cell e(n))? It should be multiplied by eur/usd (b(n)) to convert to euros. Unless I'm very wrong, this is a major error. And there are similar other conversion errors as well.
Secondly, I'm starting to understand some of the other arguments regarding paths made thus far. You simply assume one binary uniform random variable which is eur/usd and invert to get usd/eur. That is not a good way to model the real behavior, for one it misses the intermediate paths to get to double or half. For two, it ignores the dependency on the underlying instruments. The better method would be two generate two independent random walks for eur and dol, then ratio the resulting indexes relative to those results. If you make the random walks gbm/gaussian, you'll find that the net re-balancing scheme is no better than a random walk itself (i.e. not riskless at all).
You started out with some very good seeds, but unless I'm missing something, I don't think the end result was anything spectacular.
If you get a chance, try the above and see if you agree or disagree.
I appreciate your sharing your ideas though, you are on to some good ones.
