Spreadsheets - Seriously Risky!
You've all heard of The London Whale , right? The dude(s) at J.P. Morgan's Chief Investment Office in London who managed to lose $6 Billion on botched investments ? The gory details on what happened are out, and they are dry - seriously dry - reading. But there is one part that stands out - the role of spreadsheets in all this. From FT Alphaville - [...] the 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[...] Yeah, you got that right. Our Financial Overlords use Excel and copy/paste in their overlord-ian activites. (We are so doomed) You pretty much know where this is leading, right? an operational error in the calculation of the relative changes ... [s]pecifically, after subtracting the old rate from the new rate, the spreadsheet divided by their sum instead of their average, as the modeler had intended. Brilliant. Turns out that th...