A Study for Griffin

Okay, I'm wasting my time today since I'm away from home. I just ran the test for 1024 little monkeys (32 monkeys at a time - I don't want them crowding my room). They were able to trade every day from June 2, 2003 to December 1, 2006. First here are the returns of the respective funds for that time period:

G Fund 16.70%
F Fund 12.64%
C Fund 53.84%
S Fund 86.07%
I Fund 111.80% (Nice!)
20% Each 56.21%

Now, here are the results for the monkeys:

Mean 28.86%
Median 28.69%
Minimum 7.10% (poor little monkey)
Maximum 48.93%
Standard Deviation 6.55%
 
OK, I hit F9... Nothing happens. What am I missing?
AH... The Tool Pack.
Which one... the one with, or without VBA?
I just made a Monkey spreadsheet. To use it, you'll need to make sure you have installed the Excel Add-in "Analysis ToolPak." I'm using Excel 2003. I'm not sure if you need that version or not. To install the toolpak, just click the Tools menu and the Add-ins submenu. It will bring up a window showing you which add-ins you have available. Click next to Analysis Toolpak, then hit OK.

I used the RANDBETWEEN function for the monkeys to pick their allocations. I combined the TSP Tracker with my records of share prices from June 2, 2003. Every time you load the sheet, the monkeys will pick new allocations every day. On the top of the sheet, you'll see the returns of each fund from June 2, 2003 to December 1, 2006. It'll show you the returns of a 20% allocation and show you the returns of the monkeys. To reload the sheet, just hit F9 and the monkeys will throw darts again.

Every time you hit F9, you'll mimick another monkey throwing darts for 3 and 1/2 years. I uploaded it to my website, so here's the link for some monkey fun:

http://www.mircats.com/fabio/Monkey.xls
 
Okay, I'm wasting my time today since I'm away from home. I just ran the test for 1024 little monkeys (32 monkeys at a time - I don't want them crowding my room). They were able to trade every day from June 2, 2003 to December 1, 2006. First here are the returns of the respective funds for that time period:

G Fund 16.70%
F Fund 12.64%
C Fund 53.84%
S Fund 86.07%
I Fund 111.80% (Nice!)
20% Each 56.21%

Now, here are the results for the monkeys:



Mean 28.86%
Median 28.69%
Minimum 7.10% (poor little monkey)
Maximum 48.93%
Standard Deviation 6.55%


Great Job! But what if we, monkeys, know that the S & I funds are better performers or more returns of bananas?:nuts: Wouldn't we being aiming our darts at S & I more? If so, then you should add to the monkeys, a higher probability of hitting the S and I.:D:nuts:
 
OK, I hit F9... Nothing happens. What am I missing?
AH... The Tool Pack.
Which one... the one with, or without VBA?

You don't need the VBA one. That's in case you want to also use the toolpak for programming with the Visual Basic for Applications (VBA).
 
First, Fabijo – your Monkey experiment is fantastic. This thread has dipped deeply into the heart of what we are doing here. I want to wrap it up – kind of a Jerry Springer – final thought :D . It is not my intention to end this thread if anyone cares to respond. Some of what has come out of this discussion with Desperado, suggest a discussion of long term trends is probably warranted. The key to understanding long term trends requires an understanding of logarithmic scales versus linear scales.

The charts show the S&P500 from 1950 to the present. The top chart is a logarithmic scale, the bottom chart is a linear scale. They show the exact same data and the red trend lines are the same line. The key difference is the y-axis (price data). Spacing on a logarithmic scale (the straight trend line) is not coincidental, it’s purpose is to present the data in a format that eliminates the effects of inflation. The effects of inflation are not readily apparent when you view a two or three year chart. However, it is extremely significant when you begin to view the market from a historical perspective. The linear axis chart (the one with the curved trend line) does not reveal any of the great market growth periods of the 50’s and 80’s or the declines of the 70’s. However, the logarithmic chart does reveal those changes and allows for comparison. For example, the growth from 1953 to 1956 rivaled the great growth boom of the late 90’s. What is very significant, is that the growth of the 50’s was sustainable, compared to the speculative mass hysteria of the late 90’s (In terms of the S&P500, it turns out the collapse of the Soviet Union and the proliferation of the Internet were not big deals).

View attachment 1217

Why is this important to what we are doing today? Because it allows for a simple “is it reasonable” test? What does it take for the market to diverge from the trend? If you go through the chart and consider the major economic and geopolitical events that were occurring each year, you quickly realize that market trends for years until some significant events occur – the reconstruction of Europe (US oil and equipment mass exports to Europe), the Korean and Vietnam wars, the Carter energy crisis, the Reagan economic boom, the proliferation of the microcomputer (the age of Bill Gates), the collapse of the Soviet Union (opening communist countries to the global economy) and the internet bubble. The thing that all of these events have in common is that they effect the global standing of the United States as the dominant economic superpower which is reflected in the S&P500. Is the world changing today and is US economic standing in the world shifting? If so, what direction and why?

The interesting trend of the last four years, is the incredibly low amount of volatility. Is this just a reaction to the recent big bull/bear cycle, or is it reasonable that global access to information via the internet has become so prolific that the majority of the world’s investors are now looking at the same data, thinking the same way and spotting the same trends? Wouldn’t that effectively kill any trend before it ever evolved to extremes? The trend of the past 4 years gives a fairly reliable set of ranges to work with and is absolutely in line with the growth of the last half century. Is there any reason to expect a change?

Before I started tracking this year, I debated what time frame I should try to time the market around (daily, weekly, monthly). I choose to try the short term to start, since theoretically it has the highest possible returns. I am going to try a new longer term approach next year (probably a 50S/50I split) buy and hold the channels/sell the breakdowns system.

I believe that in developing any strategy, you have to look at the action of the last four years, and expect that to continue until there is some significant changes in global economics.
 
Griffin, thanks for sharing this info. I'm taking seriously what you are saying about logarithmic movement. That is a real weakness my TSP Trading spreadsheet lacks (different than the dart throwing monkeys).

I think I'll be taking a statistical mathematics class some time next spring. I'm sure that will shed some light on market movements for me.
 
Back
Top