X

Thank you for sharing!

Your article was successfully shared with the contacts you provided.
JPMorgan Chase suffered a mammoth trading loss last year as a result of a huge position in credit derivatives that was put on by a trader in its chief investment office. But the bank’s report on the $6 billion loss last month laid a portion of the blame on a very common problem: an error in a spreadsheet.

A spreadsheet that calculated the Value at Risk of the chief investment office’s portfolio contained an error in a formula that had the effect of lowering the Value at Risk, according to the report.

The risks involved in employing Excel spreadsheets are well-known. Users can make mistakes as they key in data, enter formulas or combine multiple spreadsheets. As spreadsheets circulate through the company, other users can add errors as they make changes. There’s also the possibility a user could deliberately introduce inaccuracies.

Complete your profile to continue reading and get FREE access to Treasury & Risk, part of your ALM digital membership.

Your access to unlimited Treasury & Risk content isn’t changing.
Once you are an ALM digital member, you’ll receive:

  • Critical Treasury & Risk information including in-depth analysis of treasury and finance best practices, case studies with corporate innovators, informative newsletters, educational webcasts and videos, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM websites including PropertyCasualty360.com and Law.com.

Already have an account?

Treasury & Risk

Join Treasury & Risk

Don’t miss crucial treasury and finance news along with in-depth analysis and insights you need to make informed treasury decisions. Join Treasury & Risk now!

  • Free unlimited access to Treasury & Risk including case studies with corporate innovators, informative newsletters, educational webcasts, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM publications including PropertyCasualty360.com and Law.com.

Already have an account? Sign In Now
Join Treasury & Risk

Copyright © 2021 ALM Media Properties, LLC. All Rights Reserved.