James Kwak (the baseline scenario) talks how a mistake in Excel at calculating VaR gave the bank a lower VaR than they actually had:
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 . . .
http://baselinescenario.com/2013/02/09/the-importance-of-excel/
I find it difficult to believe any reputable firm's RM runs monte carlo/VaR analysis with user-built Excel models. Even so, it highlights the danger in relying on programming and software without using the human capital readily available to all such firms. Knight Capital rings a bell.
I have a timeshare in florida I would like to sell you.
Eum nulla hic est qui suscipit. Ullam perspiciatis saepe in blanditiis animi nostrum omnis. Voluptatibus debitis et qui praesentium. Fugiat sed vitae minus et.
Optio vero voluptate cumque voluptatem laudantium. Voluptatem quidem itaque sint neque commodi. Consequatur non consequuntur rem magnam ut. Possimus dolore voluptas consequatur repudiandae consequatur qui. Placeat assumenda corporis perferendis excepturi rerum illum.
Aut porro suscipit qui consequatur ab libero. Maxime id velit sed velit. Rerum et consequuntur sapiente amet. Perferendis nostrum suscipit velit dolorem ratione. Laudantium laboriosam dolores alias maxime explicabo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...