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

Donald Trump vs Barack Obama: How the inauguration speeches compared

We compared the two presidents on trade, foreign affairs and climate change – so you (really, really) don't have to.

After watching Donald Trump's inaugural address, what better way to get rid of the last few dregs of hope than by comparing what he said with Barack Obama's address from 2009? 

Both thanked the previous President, with Trump calling the Obamas "magnificent", and pledged to reform Washington, but the comparison ended there. 

Here is what each of them said: 

On American jobs

Obama:

The state of our economy calls for action, bold and swift.  And we will act, not only to create new jobs, but to lay a new foundation for growth.  We will build the roads and bridges, the electric grids and digital lines that feed our commerce and bind us together.  We'll restore science to its rightful place, and wield technology's wonders to raise health care's quality and lower its cost.  We will harness the sun and the winds and the soil to fuel our cars and run our factories.  And we will transform our schools and colleges and universities to meet the demands of a new age.

Trump:

For many decades we've enriched foreign industry at the expense of American industry, subsidized the armies of other countries while allowing for the very sad depletion of our military.

One by one, the factories shuttered and left our shores with not even a thought about the millions and millions of American workers that were left behind.

Obama had a plan for growth. Trump just blames the rest of the world...

On global warming

Obama:

With old friends and former foes, we'll work tirelessly to lessen the nuclear threat, and roll back the specter of a warming planet.

Trump:

On the Middle East:

Obama:

To the Muslim world, we seek a new way forward, based on mutual interest and mutual respect. To those leaders around the globe who seek to sow conflict, or blame their society's ills on the West, know that your people will judge you on what you can build, not what you destroy. 

Trump:

We will re-enforce old alliances and form new ones and unite the civilized world against radical Islamic terrorism, which we will eradicate completely from the face of the earth.

On “greatness”

Obama:

In reaffirming the greatness of our nation we understand that greatness is never a given. It must be earned.

Trump:

America will start winning again, winning like never before.

 

On trade

Obama:

This is the journey we continue today.  We remain the most prosperous, powerful nation on Earth.  Our workers are no less productive than when this crisis began.  Our minds are no less inventive, our goods and services no less needed than they were last week, or last month, or last year.  Our capacity remains undiminished.  

Trump:

We must protect our borders from the ravages of other countries making our product, stealing our companies and destroying our jobs.

Protection will lead to great prosperity and strength. I will fight for you with every breath in my body, and I will never ever let you down.

Stephanie Boland is digital assistant at the New Statesman. She tweets at @stephanieboland