Is Excel the most dangerous piece of software in the world?

Microsoft's calculator is partially to blame for JPMorgan losing $9bn, and a lot more besides.

Is Excel the most dangerous piece of software in the world? Baseline Scenario's James Kwak reports on a little-mentioned aspect of the notorious "London Whale" debacle at JPMorgan, where Bruno Iksil headed a proprietary trading team which made losses of up to $9bn.

It turns out, Kwak writes, that Excel was partly to blame:

To summarize: JPMorgan’s Chief Investment Office needed a new value-at-risk (VaR) model for the synthetic credit portfolio (the one that blew up)… The new model “operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another”… After the London Whale trade blew up, the Model Review Group discovered that the model had not been automated and found several other errors. Most spectacularly,

“After subtracting the old rate from the new rate, the spreadsheet divided by their sum instead of their average, as the modeler had intended. This error likely had the effect of muting volatility by a factor of two and of lowering the VaR…”

Kwak wonders if the very ease of use that Excel offers — allowing people with no programming experience to knock together what are, in effect, relatively advanced applets — also makes it dangerous to use in most sensitive situations. There's no debug, no audit trail, and no way to test why a spreadsheet returns the value it does. Similarly, training for Excel, where it exists, tends to ignore the importance of elegant and well-designed code, leading to legacy spreadsheets being used with internal workings which are opaque to all but their original creator, who may have left the company 20 years earlier.

The problem is, though, that Excel is the worst way to run a company's software other than all the other ways. The fact that it's capable of being programmed by the people who will end up using it means that it might enable hacked-together code, but it also prevents exactly the sort of corporate bloat which leads to people circumventing their company's software in the first place.

Bill Gates threatens the world with Microsoft Office in 2003. Photograph: Getty Images

Alex Hern is a technology reporter for the Guardian. He was formerly staff writer at the New Statesman. You should follow Alex on Twitter.

Show Hide image

Would you jump off a cliff if someone told you to? One time, I did

I was walking across the bridge in Matlock park, which is about 12 feet high, with a large group of other kids from my year, in the pouring rain.

Ever heard the phrase, “Would you jump off a cliff if they told you to?” It was the perpetual motif of my young teenage years: my daily escapades, all of which sprang from a need to impress a peer, were distressing and disgusting my parents.

At 13, this tomboyish streak developed further. I wrote urgent, angry poems containing lines like: “Who has desire for something higher than jumping for joy and smashing a light?” I wanted to push everything to its limits, to burst up through the ceiling of the small town I lived in and land in America, or London, or at least Derby. This was coupled with a potent and thumping appetite for attention.

At the height of these feelings, I was walking across the bridge in Matlock park, which is about 12 feet high, with a large group of other kids from my year, in the pouring rain. One of the cool girls started saying that her cousin had jumped off the bridge into the river and had just swum away – and that one of us should do it.

Then someone said that I should do it, because I always did that stuff. More people started saying I should. The group drew to a halt. Someone offered me a pound, which was the clincher. “I’m going to jump!” I yelled, and clambered on to the railing.

There wasn’t a complete hush, which annoyed me. I looked down. It was raining very hard and I couldn’t see the bottom of the riverbed. “It looks really deep because of the rain,” someone said. I told myself it would just be like jumping into a swimming pool. It would be over in a few minutes, and then everyone would know I’d done it. No one could ever take it away from me. Also, somebody would probably buy me some Embassy Filter, and maybe a Chomp.

So, surprising even myself, I jumped.

I was about three seconds in the air. I kept my eyes wide open, and saw the blur of trees, the white sky and my dyed red hair. I landed with my left foot at a 90-degree angle to my left ankle, and all I could see was red. “I’ve gone blind!” I thought, then realised it was my hair, which was plastered on to my eyes with rain.

When I pushed it out of the way and looked around, there was no one to be seen. They must have started running as I jumped. Then I heard a voice from the riverbank – a girl called Erin Condron, who I didn’t know very well. She pushed me home on someone’s skateboard, because my ankle was broken.

When we got to my house, I waited for Mum to say, “Would you jump off another cliff if they told you to?” but she was ashen. I had to lie that Dave McDonald’s brother had pushed me in the duck pond. And that’s when my ankle started to throb. I never got the pound, but I will always be grateful to Erin Condron. 

This article first appeared in the 25 August 2016 issue of the New Statesman, Cameron: the legacy of a loser