When you invest, your capital is at risk.



More lies have been told on Excel than in Word. That’s the joke told to highlight the power of data and numbers to manipulation. On a serious note, is Microsoft Excel the most powerful software made available to the everyday person?

Sure, knowing how to code is pretty powerful but nothing is as accessible as Excel. Small-business owners can balance books in seconds with guaranteed accuracy. Stock price models can be built on a single page. Now 36 years old, excel still runs the world as it passes 750million users.

A Microsoft commissioned study found their suite of Office 365 offerings saved workers an average of 90 minutes a week. But this isn’t an ad for Microsoft. Aggregated small gains can quickly be wiped out with big losses.

In 2010, a paper called Growth in a Time of Debt  was published by two Harvard Professors. It concluded that economic growth stagnated once debt reached 90% of GDP. A finding supporting austerity (cuts in government spending and increase in taxes). The paper was heavily referenced and influenced government policy decisions. Except all the modelling was wrong. Local student Thomas Arnherst tried for a whole semester to replicate the results and couldn’t. Until he found, the Harvard professors had failed to include 5 data points in a mean calculation. A simple Excel click and drag error. Read the full story and its implications here.

In 2012, JP Morgan infamously booked a US$6.2b loss. After building US$157b in Credit Default Swap positions, a market turn caused significant losses for the bank. It turns out, one of the contributing factors was a misconfigured Value-at-risk model. VaR tests how much a trade is positioned to lose based on moves in the market. This model depended on copying and pasting data across spreadsheets. You can guess what happens next. The model underreported risk which contributed to the loss. This is known as the London Whale affair.

Again in 2010, British spy agency MI5 accidentally tapped the wrong phones due to a formatting error. The expected conversations about crime probably revolved around football results instead. The spreadsheet included ‘000’ as the final digits of all number. All collected material was promptly destroyed.

Sign up to Stake

Don’t have Stake?

Start ahead of the game. Get a free stock in one of Nike, Dropbox, GoPro or a mystery stock when you sign up and fund your account within 24 hours.

When you invest, your capital is at risk.

Stake logo
App Store logoGoogle Play logo

Subscribe to our free newsletters

Stake is the trading name of Hellostake Limited, a company registered in England and Wales (Company no. 11676409). Hellostake Limited is authorised and regulated by the UK Financial Conduct Authority under the Firm Reference Number 830771. Registered address: 85 Great Portland Street, London, W1W 7LT, United Kingdom.

When you invest, your capital is at risk.

The value of your investments can go down as well as up and you may receive back less than your original investment. Any advice is of a general nature only. As investments carry risk, before making any investment decision, please consider if it’s right for you and seek appropriate independent taxation and legal advice. The information on our website or our mobile application is not intended to be an inducement, offer or solicitation to anyone in any jurisdiction in which Stake is not regulated or able to market its services.

At Stake, we’re focused on giving you a better investing experience but we don’t take into account your personal objectives, circumstances or financial needs. Please view ourTerms & Conditions,Privacy PolicyandDisclaimers before deciding to use or invest on Stake. By using the Stake website or service in any way, you agree to our Privacy Policy and Terms & Conditions. All financial products involve risk and you should ensure you understand the risks involved as certain financial products may not be suitable to everyone. Past performance of any product described on this website is not a reliable indication of future performance

Copyright © 2023 Stake. All rights reserved.