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.

Getty
Show Hide image

Lord Sainsbury pulls funding from Progress and other political causes

The longstanding Labour donor will no longer fund party political causes. 

Centrist Labour MPs face a funding gap for their ideas after the longstanding Labour donor Lord Sainsbury announced he will stop financing party political causes.

Sainsbury, who served as a New Labour minister and also donated to the Liberal Democrats, is instead concentrating on charitable causes. 

Lord Sainsbury funded the centrist organisation Progress, dubbed the “original Blairite pressure group”, which was founded in mid Nineties and provided the intellectual underpinnings of New Labour.

The former supermarket boss is understood to still fund Policy Network, an international thinktank headed by New Labour veteran Peter Mandelson.

He has also funded the Remain campaign group Britain Stronger in Europe. The latter reinvented itself as Open Britain after the Leave vote, and has campaigned for a softer Brexit. Its supporters include former Lib Dem leader Nick Clegg and Labour's Chuka Umunna, and it now relies on grassroots funding.

Sainsbury said he wished to “hand the baton on to a new generation of donors” who supported progressive politics. 

Progress director Richard Angell said: “Progress is extremely grateful to Lord Sainsbury for the funding he has provided for over two decades. We always knew it would not last forever.”

The organisation has raised a third of its funding target from other donors, but is now appealing for financial support from Labour supporters. Its aims include “stopping a hard-left take over” of the Labour party and “renewing the ideas of the centre-left”. 

Julia Rampen is the digital news editor of the New Statesman (previously editor of The Staggers, The New Statesman's online rolling politics blog). She has also been deputy editor at Mirror Money Online and has worked as a financial journalist for several trade magazines. 

0800 7318496