Here's an overlay of the two.

Awesome stuff RM but are you going to feel responsible for the sudden drop in CP membership activity after the depression sets in?

This just proves that this place is a living proof that misery loves company.

I am compelled to emerge from my hiding place to commend you, Rainman, on this fine piece of work. A stunning visual depiction of our collective ennui.
:clap: :clap: :clap:





now, back behind the drapes, no one look at my shoes.

You're clearly insane. Loved the algorithm.

Yes. And even though the current status of the team is nearly as low as it got in the late 80's, the fact that we haven't already been < -10.0 for the better part of 12 years this time makes it easier to bear assuming we pull out of it within the next few years, IMO.

Great work, Rain Man.

Can you do all 32 franchises now so we have something to compare to? :p

Ouch. It looks like the Chiefs are the Raiders without their glory years. I didn't need to see that.

As an update, our stock index now stands at -21.43, which is the second-lowest season-ending stock index in Chiefs history. (The low season-ending point was -23.35 as we ended the 1988 season.) Interestingly, if we had lost the final game against the Broncos, our index would have been -23.43.

As noted before, the low point of all time was Week 4 of 1989 when our index dropped to -24.41 following a 1-3 start. If we lose our first four games next year we'll drop below this mark.


I looked at another variable that I'll call hope. That variable is the change registered over the course of one season. Whereas the index captures total happiness, the Hope variable covers the change in happiness over the course of a year.

Not surprisingly, the best years are the championship years. The Hope variable was a +13.99 in 1969, indicating a very bullish outlook. The next two hope jumps were in 1962 (+11.66) and 1993 (+9.84). On the contrary, the years when hope dropped most dramatically were 2008 (-11.39), 1977 (-10.87), and 2007 (-9.30). This year was a -4.83, which is bad but not as bad as other years.

I think based on this we should call the Herm era the Era of Lost Hope.

This chart made me orgasm like Peter North after a week long hiatus from porn. Its a buttfucking work of art and you should be praised endlessly.

So you're saying we should have sold out stock high in 1971?

Missed this thread the first time Kevin, very nicely done. Well that is an understatement, my vocabulary will not do it justice.

It has been a long road.

Amazing work... would be cool to see the Broncos and Chargers... even the Seahawks for old time sake as an overall comparison. I'm not sure if you used the data from profootballreference.com or not, but if I could get you the data... just tell me how you did it.

That's why you don't buy stock in the Chiefs... or bet on them.



Sell MORTIMER!!! SEEEEEEEeeeeeeeeeLLLLLLLLLLLLLL

I think I'll keep throwing good money after bad until the day I die.

*Sigh*......I'll never be able to retire at this rate.

I'd really like to do it for all the teams, and actually have it set up pretty good now. It'd be great if you or others could help. Anyone who wants to do this, here's the system. (The Broncos' index is going to be depressing to us Chiefs fans, though.)

Just take the enclosed spreadsheet and do the following:

Go into pro-football-reference, and year by year grab the schedule/record. It's the page that looks like this: http://www.pro-football-reference.co...s/crd/2009.htm

You can select the whole thing with a careful click and drag, and then copy the whole thing into cells G through AA. This is the only time consuming part because you have to copy and paste each year individually. However, there's a linky thing at the top that will let you go directly to the next year's table.



It's very important to start with the first year of the franchise at the top of the spreadsheet and work your way down, with the most recent year last. For AFL legacy teams, that means you start with 1960. For other teams, you might be starting in 1920 or 1950 or 1976 or whenever the team was founded.

You then have to do the following:

1. Delete the bye weeks.

2. Cell F is nothing but a count, so it means nothing.

3. In Cell E, insert a 0 (zero) for non-playoff games, and a 3 for any playoff games.

4. Cell D is the number of years since a playoff appearance, but I ended up never using that, so you can ignore it.

5. Cell C is the main formula, so leave it alone.

6. Cell B is the Year. Just a bookkeeping thing.

7. Cell A is some random calculations. The ones at the end of each year are the Hope Calculations, which merely compare the stock index at the end of one year to the next year. There are some other random calculations in there that you can ignore. All of this is optional.

8. You'll need to define the data set to update the graph, or otherwise it might not include the whole time period. That function depends on the version of Excel you have. If you don't know how to do that, just upload the file to me and I'll update the graph.

If your team had more or fewer playoff appearances, you may need more or fewer rows. You can just copy the formula into any new rows you need.

If you have an old version of Excel the file may not open. Let me know.