I recently started porting my spreadsheets over to Google Spreadsheets. I’d long resisted Google Docs, but I got to say that it’s been pretty painless. The imports have seemed to work, although it’s had limited success on fancier formatting and on charts and I’ve run into some annoyances (it’d be really nice if there was a “view source” mode where you could just edit formulas, or a mass replace to change a specific column in the formula, and a paste w/o formatting option). There are good things that have made it worthwhile, like easy collaboration/sharing and painless publishing.

Among those spreadsheets I’ve been importing are some of my financial docs. One nice function is GoogleFinance() which not only lets you get current, but also historical stock data. Random tidbit: when returning historical quotes, the GoogleFinance() function wants to dump an array into multiple cells. Here for example is how you’d return just to the price of VTSMX from January 1st:

=INDEX(GoogleFinance("VTSMX", "close", "1/1/2008"), 2, 2)

A couple years ago, it occurred to me that learning some basic finance/investing (which sadly, isn’t really taught at all anywhere in the school system) might not be a bad idea. Except for the odd post or two, I haven’t published too much about it, even though my interest has taken me far into “financial geek” territory (like reading the Journal of Indexes for fun). My original plan was to kick off a financial section for my blog, but since that’s going to have to wait at least for a few months, I though I’d at least get the ball rolling by publishing the target asset allocation that I ended up with (and presumably, will be sticking to for a long while):

Most of it’s pretty standard, with a few exceptions.

• I’ve sliced and diced because a decade plus after Fama and French published on the Three Factor Model, it still seems to hold up (suggesting that it’s not just a matter of market inefficiency).
• I’ve added REITs and CCFs as major asset classes for diversification purposes. The larger than average numbers and addition of CCFs are influenced by a lot of reading. Two of the strongest articles on that are: The Benefits of Low Correlation and The Rewards of Multiple-Asset-Class Investing. This year has been a good illustration of how adding some CCFs can decrease volatility. I’ve added some “standard” plans at the bottom of the spreadsheet so you can see how the performance compares.
• Lastly, I’m over-weighted on international, at least by conventional wisdom (although, if you wanted a true index, you’d actually not be far off if you invested by market cap). Financial advisors usually recommend something like a 70/30 or 80/20 split of domestic investment because historically the US market has been safer, more efficient, and better performing, but I don’t really think that’s as true moving forward. Also, since it’s as likely that I’ll be living/traveling internationally, the relative buying power argument for overweighting your local market doesn’t make as much sense for me either.
• There aren’t really many (any?) good general purpose tools for keeping track of your investments long term (that generate personal rate of return factoring taxes, dividends, etc). That might be a neat little tool to design. I started writing a scraper for my Vanguard account, so I might have something useful sooner rather than later there.

And yes, ultimately, the exact percentages of your asset allocation aren’t as important as picking something reasonable, sticking with it, and rebalancing regularly. That pretty much sums up what I’ve learned and the extent of my future maintenance. Although in case I don’t get around to elaborating for a while, here are the main takeaways:

• Get familiar with Modern Portfolio Theory, particularly the Random Walk – Very few of the most dedicated, privileged, and informed investors consistently beat the market. You are unlikely to do much better.
• Costs – One of the few things that you can control (besides Asset Allocation) is costs (expense ratios, to some degree taxes). John Bogle is of course the most famous champion of this. Here’s a more recent article of his talking about AA and costs (along w/ the standard charts showing aggregate differences)
• Losses are worse than gains – this is a simple bit of mathematics, but it’s worth elaborating on as it’s at the center of MPT and diversification. Basically, if you lose 50% you need to gain 100% just to get back to where you started. Cumulative losses are even worse, as compounding (Einstein’s quoted “most powerful force in the universe”) cuts both ways. A tool like FIRECalc will generate very pretty graphs the range of badness depending on when you start withdrawing money.
• Rebalance – Basically it’s a rule that forces you to buy low and sell high. An annual or semi-annual rebalance is really the only time you really need to look at how your investments are doing. The rest is really just watching grass grow (or giving yourself ulcers) unless you’re doing some crazy tactical asset allocation scheme. There are lots of different articles discussing when/how often to do this, but not much conclusive that isn’t dependent on backtesting. It seems like picking one year is a good compromise between increased risk (as your AA skews) and minimizing transaction costs.

These, along w/ the notes I mentioned above, I think really cover most of the basics. The only other really big thing is to learn about the tax implications (CGT, tax efficiency, and tax loss harvesting) and why tax-deferred investing is your friend. If there’s interest, I can post a spreadsheet that illustrates some of the latter.

Oh, also, listen to Warren Buffett.

Philip Greenspun (yeah, that one) recently wrote a post on the cost of converting the entire U.S. to electric cars that has kicked off a pretty interesting discussion. I ended up doing my own back-of-the-napkin calculations which pleasantly appear to corroborate with what Brad Templeton (yeah, that one) posted at the same time.

In chasing down the numbers (lots and lots of searching), and reading the comments (and looking at some other recent discussions, like the recent O’Reilly search/platform posts) I was reminded how lame the technology currently is in terms of online deliberation tools. Even simple things like representing citations, agreement, rebuttals, etc. aren’t supported at all. It’d be interesting to try to bring some of the research and projects being done on deliberative software to the web at large. (What’s interesting is that 5+ years since I was last really into this space, nothing usable has really come out/caught on… that in itself is worth further exploration.)

This conversation also got me to finally watch Who Killed The Electric Car? and really dig in to the history and the latest stuff going on with EVs and PHEVs. There’s a lot there, which I’ll eventually be posting (again, pointing to complete dearth of good knowledge collection/research tools). Wherefore art thou Gobbler? (That’s a rhetorical question. teachers.yahoo.com got shit-canned and nothing ever came out of the gobbler despite it’s obvious usefulness just about everywhere.)

What was sad about the documentary was that it highlighted a true failure of collective action. The “climax” of the doc films a scene that takes place in February/March 2005 (modern times! with Internet!) when GM sends the last of the EV1s sitting in a lot to destruction while protesters try to stop them. Despite having collected $1.9M to try to buy back the cars, keeping vigil for almost a month, and getting arrested for civil disobedience, GM “prevails” (apparently, even now there continues to be bizarre controversy over the few remaining EV1s). In the larger scheme of things, that particular battle was lost years ago, when the CARB regulations were overturned (this actually appears to be continuing battle), and GM’s “victory” was phyrric, at best (the ironies are many-fold, like GM selling their Ovonics battery stake to Chevron, which are now being used in Toyota Prius’ or that once again, oil prices are killing Detroit).

Well, it’s easy to get distracted by schadenfreude, but here we are, 30 years later, with no progress made, and the evidence now abundantly clear (and getting consistently worse) that our energy consumption habits are unsustainable and likely to bite us in the ass sooner, rather than later. From this perspective, GM and the whole auto industry were just a bunch of marks, no less bamboozled or inveigled than anyone else. After all, they’re simply working within their short-term economic self-interest. The ten-year outlook doesn’t even register in the 10Q, much less the “fate of the world” or the “consequences for your grand-children.” In economic terms, those would be externalities – not their problem, and not a cost they they would have to bear. This, I believe applies doubly so for the Oil Industry, which I’ve concluded are the true mustache twirling villians (well, probably the most apt comparison would be to the tobacco companies, although the Oil Industry dwarfs them, hence the caps). Quoting myself:

It seems to me, and I’m sort of surprised that others haven’t mentioned it, is that the real reason this is a thought experiment is because the the government and the drivers aren’t the sole (or even the primary) actors, but rather the oil and related industries. The combined market cap of the oil & gas industry is just shy of $1.9 Trillion – it’s larger than #2 (drug manufacturers) and #3 (central banking) combined. Exxon Mobile (XOM) alone, is $480B – larger than the combined market cap of all auto manufacturers ($381B). XOM currently has an EBITDA of $76.5B. It continues to post record profits as oil prices have gone up (currently 35.4% quarterly revenue and 17.3% quarterly profit growth). The profits they stand to reap over the next several decades (which is the timeframe – remember XOM started as Standard Oil back in 1870) is in the trillions.

Now what might be a most interesting continuation of this thought experiment is that, in light of this sort of economic landscape and these economic motivations, what would a transition plan to a saner automotive and energy system look like? How would you make the dominoes fall and what would be involved? Hmm…

I’ve been giving it some thought, and it’s a tough problem. It seems that there’s a number of strings that could/should be tugged to sort of unravel things. What worries me is that while reasonably, it would seem that we should all be taking this quite seriously (after all, no matter how rich you are, global environmental problems would end up affecting you and your progeny), it’s quite plausible that as individuals, a society, a species, we just don’t have the mental faculties or social organization to rationally/cohesively react to global/species-affecting crises.

That’s one way of saying that the technology of social augmentation and collective action may have a key role to play in trying to catch us up so that we can be smart enough fixing our problems as we have been dumb in causing them.

(For those looking for Don Quixote references, sorry, I was just using the phrase as a way to sum up the gist of the second part of this post. I’ll change the title if I can think of something more apt or descriptive.)

In between the projects and mini-projects, I’ve also begun to do some catching up on reading. Carrying around a book everywhere and taking lots of public transportation has helped tremendously in that regard. I started with Shirky’s Here Comes Everybody a few weeks ago, just finished Weinberger’s Everything Is Miscellaneous (that’s been sitting around since his original book tour when he came to Yahoo!) and polished off Cory’s new YA novel Little Brother in a single sitting (what’s so compelling and chilling is the realization that we’re about half-a-step away from a sort of grim-meathookiness. It gave me more of an appreciation of the fiction coming out of the 80s). And I’m now starting Glut.

One thing that’s interesting is that all these books have related/complementary media (podcasts, talks, etc.) attached to them (and all worth the time spent, I’d say, particularly Alex Wright’s Web That Wasn’t presentation). Now, obviously anyone who’s done much spelunking on Wikipedia (lately, I’ve begun doing a bit of random clicking around on Slideshare as well), or you know, random Internet browsing can tell you there’s a lot of “stuff” out there. However, I thought I’d share a list of some of the more useful/structured resources I’ve found (online video, lectures, etc):

• Google Tech Talks
• TED Talks
• Long Now Seminars
• Edge
• Open CourseWare
• MIT OCW
• Stanford OCW
• Dr. Dobb’s TechNetCast
• IT Conversations
• YDN Theater
• iTunesU

This post sort of got kicked off while I was watching this very engaging recent talk (via) that I can’t favorite because YouTube still has a 500-favorite limit (now below 0.6 favs/day):

Recently, in my quest to minimize distractions, I’ve been going through and …fixing things. First was updating my procmail and my spam filtering so that the only mail that ends up in my Inbox is real mail. (Inbox Zero for the past month!) And here’s what I did for Adium so I could leave IM on while I was working:

Turning off dock animations (no more bounces) and hiding Adium while in the background (no more window popping) were really huge. I also have my dock hidden, which helps as well. (The menu bar gives me enough cues so that I can see what’s going on, but that isn’t too bothersome while I’m trying to work.)

And of course, I have my work.py script, which lays out my Terminals appropriately. At some point I might start scripting Space switching for that, but at least right now, this seems to be working out OK.