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

Will Euroscepticism prove an unbeatable advantage in the Conservative leadership race?

Conservative members who are eager for Brexit are still searching for a heavyweight champion - and they could yet inherit the earth.

Put your money on Liam Fox? The former Defence Secretary has been given a boost by the news that ConservativeHome’s rolling survey of party members preferences for the next Conservative leader. Jeremy Wilson at BusinessInsider and James Millar at the Sunday Post have both tipped Fox for the top job.

Are they right? The expectation among Conservative MPs is that there will be several candidates from the Tory right: Dominic Raab, Priti Patel and potentially Owen Paterson could all be candidates, while Boris Johnson, in the words of one: “rides both horses – is he the candidate of the left, of the right, or both?”

MPs will whittle down the field of candidates to a top two, who will then be voted on by the membership.  (As Graham Brady, chair of the 1922 Committee, notes in his interview with my colleague George Eaton, Conservative MPs could choose to offer a wider field if they so desired, but would be unlikely to surrender more power to party activists.)

The extreme likelihood is that that contest will be between two candidates: George Osborne and not-George Osborne.  “We know that the Chancellor has a bye to the final,” one minister observes, “But once you’re in the final – well, then it’s anyone’s game.”

Could “not-George Osborne” be Liam Fox? Well, the difficulty, as one MP observes, is we don’t really know what the Conservative leadership election is about:

“We don’t even know what the questions are to which the candidates will attempt to present themselves as the answer. Usually, that question would be: who can win us the election? But now that Labour have Corbyn, that question is taken care of.”

So what’s the question that MPs will be asking? We simply don’t know – and it may be that they come to a very different conclusion to their members, just as in 2001, when Ken Clarke won among MPs – before being defeated in a landslide by Conservative activists.

Much depends not only on the outcome of the European referendum, but also on its conduct. If the contest is particularly bruising, it may be that MPs are looking for a candidate who will “heal and settle”, in the words of one. That would disadvantage Fox, who will likely be a combative presence in the European referendum, and could benefit Boris Johnson, who, as one MP put it, “rides both horses” and will be less intimately linked with the referendum and its outcome than Osborne.

But equally, it could be that Euroscepticism proves to be a less powerful card than we currently expect. Ignoring the not inconsiderable organisational hurdles that have to be cleared to beat Theresa May, Boris Johnson, and potentially any or all of the “next generation” of Sajid Javid, Nicky Morgan or Stephen Crabb, we simply don’t know what the reaction of Conservative members to the In-Out referendum will be.

Firstly, there’s a non-trivial possibility that Leave could still win, despite its difficulties at centre-forward. The incentive to “reward” an Outer will be smaller. But if Britain votes to Remain – and if that vote is seen by Conservative members as the result of “dirty tricks” by the Conservative leadership – it could be that many members, far from sticking around for another three to four years to vote in the election, simply decide to leave. The last time that Cameron went against the dearest instincts of many of his party grassroots, the result was victory for the Prime Minister – and an activist base that, as the result of defections to Ukip and cancelled membership fees, is more socially liberal and more sympathetic to Cameron than it was before. Don’t forget that, for all the worry about “entryism” in the Labour leadership, it was “exitism” – of Labour members who supported David Miliband and liked the New Labour years  - that shifted that party towards Jeremy Corbyn.

It could be that if – as Brady predicts in this week’s New Statesman – the final two is an Inner and an Outer, the Eurosceptic candidate finds that the members who might have backed them are simply no longer around.

It comes back to the biggest known unknown in the race to succeed Cameron: Conservative members. For the first time in British political history, a Prime Minister will be chosen, not by MPs with an electoral mandate of their own or by voters at a general election but by an entirelyself-selecting group: party members. And we simply don't know enough about what they feel - yet. 

Stephen Bush is editor of the Staggers, the New Statesman’s political blog. He usually writes about politics.