Re:Sorry, Geeks, Microsoft Excel is Everywhere
by jessaustin on Thursday February 14, 2013 @10:17PM
(#5224226)
The whole concept of VaR is an industry-wide consensus hallucination. Even if you do it right you're doing it wrong.
But to your point, if this formula had been in a single library procedure in version control rather than pasted and repasted into various dingy corners of various spreadsheets, this sort of error would have been less likely. Manual handling of formulas is at least as dangerous as manual handling of data.
The real reason came down to a flaw in the formula they were using. From the JP Morgan report:
Source: http://www.zerohedge.com/news/2013-02-12/how-rookie-excel-er...