Another day, another trip through the grist-mill of seemingly random (and certainly erratic) price action. In some ways, it doesn't seem to matter if you are bullish or bearish; if you're trading tactically, it's very, very easy to get caught out by the seeming randomness of it all.

So easy, in fact, that Macro Man wonders if it is even possible to tell the difference between current price action and a random number generator. So he's determined to find out.

There are six charts below. Three are actual financial market prices, and three are the product of the random number generator function in excel. Your mission, should you choose to accept it, is to determine which three are real....and which three are the figments of Bill Gates' imagination.

Good luck.

So easy, in fact, that Macro Man wonders if it is even possible to tell the difference between current price action and a random number generator. So he's determined to find out.

There are six charts below. Three are actual financial market prices, and three are the product of the random number generator function in excel. Your mission, should you choose to accept it, is to determine which three are real....and which three are the figments of Bill Gates' imagination.

Good luck.

## 33 comments

Click here for commentsF, E, B

ReplyIsn't A USDJPY?

ReplyI suppose I should be able to guess some of the others from your favourite assets from previous posts, but haven't quite got round to looking yet...

Chris

A, C , F its excel

Replyi think A is USD/JPY, B = EUR/USD and C = Stock of some description.

ReplyF E B

Replyc, d and f

ReplyB, C, F

Replymaybe they are all random and MM is conducting a social experiment?

ReplyA,D,F are markets.

ReplyMmmm, tough one.

ReplyHowever, chart A is definately Yen pr dollar, and chart E looks like CAN$ pr Swiss Franc to me.

For the rest, I don't know, excpet that B is NOT €/$.

I'm baffled. But wouldn't it be challenging (maybe not impossible, but at least challenging) to tell the difference in more "normal" times?

ReplyIt was in the mid 1960's when mathematical economists began studying this phenomenon. Paul Samuelson wrote a paper that attracted wide attention - "Proof that Properly Anticipated Prices Fluctuate Randomly". Thought you'd be interested. Here's a copy on the web:

Replyhttp://stevereads.com/papers_to_read/proof_that_properly_anticipated_prices_fluctuate_randomly.pdf

cheers,

tas

B, D & E are is excell

ReplyF looks like a buy here

ReplyA,B & F are market prices. Fred.

ReplyIsn't there an online test that does this? I'd search, but I have to run to a meeting.

ReplyAlso: do not use Excel's generators for anything important, especially if you care about the tails. They are still, last I heard, broken.

Real men use R.

The deteriorating quality of your posts can only be explained by the losses you are taking in your trades as well as investment views.

ReplyWhat kind of nonsense is this? I tried to put up with your stuff on renaming assets (breaks anchoring, so a good approach). But this is just plain stupid!

Take a break. You blog well.

Grrr, it's not the usd/jpy. It could be an obscure currency couple or MM rolled the voodoo bones and plotted the numbers.

ReplyI have no time today and this puzzle will bother me considerably.

Is it the number of portfolio managers leaving London to prevent the seizure of their wealth?

Anon @ 5.26, the point is that if you can't tell the difference between what you're trying to trade and the output of a random number generator, perhaps you need to take a step back...as indeed I have done.

ReplyGiven that no one has gotten the right answer, perhaps it's not as stupid a lesson as you might think.

no one has gotten the right answer?? Damn. Well at least there is a chance I was right then. B, C, and D look random. But I'm not at all sure of that, unlike the last time I saw this kind of comparison.

ReplyWell, what you are implying is that the current price action is somehow very random and somehow that is not the case in 'normal' markets.

ReplyGive me example of one time series for any asset such that you can pick it out of a list of random excel charts as being the price action of a real asset.

Ofcourse they all look random. And the purist in me is kinda glad because of that.

To trade is to stop whining and fighting the tape.

A) Much of the price action of the past two years has been more clearly non-random than the past two months. That change in market tone is worth pointing out.

ReplyB) If what you read on a free website written in his spare time by a guy forced to work from home for most of the last three months doesn't meet your lofty standards, consider your objections noted and feel free to spend your time in more high-quality, non-whiny locales.

I believe that Anon 5.26 meant to say "the Macro Man blog has a certain je ne sais quoi and gives me big morning wood."

ReplyAs for the puzzle, look at the clues. Price on the left and date at the bottom. The charts have different prices but the dates are the same. The patterns could be anything.

Are you sure that this can be solved with that information?

B C and F are real as they are going up.

Reply:)

i've been playing with this approach recently (using R that wcw suggests -- free ware -- fits my price range, but, I think, very good, used in stats grad programs at many places)

Replyi've been literally creating random walks (adding normal -- mean zero, and some standard deviation to starting price).

it's not hard to get things that look a lot like a general financial time series -- even things that look a specific time series

its likely that any statistician worth his or her salt can choose functional forms that come very close to anything you want (with the caveat being that you can do a great job of modeling what happened IN THE PAST -- and if you believe in your model too much when the regime changes -- as MM suggests may be happening -- you find all your fancy stats falls apart -- e.g. Renaissance Technologies not quite the superstar today that it was in the past -- fell off Barron's list of top hedges funds based on last 3 years)

just for fun i will take a stab at it (I mean, jeez, there are only 20 possible answers – 6 choose 3)

ReplyA looks like usd/jpy (re: 10:37)

B looks like eur/usd (re: 10:50, disagreeing with 1:51)

since I think A and B are right and MM ruled out ABC and ABF (since they were proposed before MM said all were wrong at 5:52) then I'm going to choose between ABD and ABE, going with the idea that C and F are examples of excel's random number generator.

To my eyes C and F have odd “curved” segments to them that A and B do not have, so looking at D and E it seems to me that D has one of those odd curves in it, so I’m going with E – and anyway, I like ABE, one of my favorite presidents.

Of course, I have no clue what E is

I'm going with a,d,f

Replyworking on the theory that positive serial correlation is more likely in a real market than a random number generator

Ok, cool.

ReplyNow, can we have a second chart, charting the choice distribution by the people commenting?

I think that might tell us something interesting....

ACF are the real markets. Nothing is random.

ReplyEd

B C and D are random. No science, just hunches on the basis of looking at one or two charts in the past.

ReplyGet well Macro, you will need all your strength to battle the PPP without the SEC. You can always fall back on reworking Houseman if the Tiny Tim ends up owning every share on every exchange. Funny, saw it on my dad's shelf last I saw him. Never knew that was his style.

A USDJPY

ReplyB EURUSD

F mkt

If B is not euro, then MM's excel is very fishy.

So cute! Thank you!

ReplyGreat template! Thanx for sharing it with us..... more templates http://www.itemplatez.com

I must admit that B looks a lot like dollars pr euro until the 7th of May. After the 7th, the graphs do indeed look different, which is why I stated so clearly that it could not be euro pr dollars (or the inverse, of course, which it looks like).

ReplyThe third one I still don't know, and my suggestion for the E chart doesn't seem to fit considering the entire period.

Further, given the hints, perhaps the point is that the current market IS random, so it doesn't matter if it's generated from excel or the some kind of market.