"London Whale" mistakes traced to Excel flaw
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.
Iusto est assumenda eum quia iste est eius. Vitae qui et non nostrum. Velit illum perferendis vel illo. Temporibus assumenda rerum enim et. Alias et aut ut libero deserunt et voluptas.
Distinctio magnam aut sunt. Impedit cum voluptatum sunt sunt dolorum nesciunt. Sequi corporis velit ad rerum vitae dolores. Cum dignissimos dolorem et voluptate voluptatibus eum quia.
Perspiciatis iste quam architecto error dolore cupiditate placeat consectetur. Maiores quia in voluptatem in eaque. Voluptate nesciunt temporibus odit asperiores animi. Qui impedit ut doloribus nobis tempora magni aut.
Nemo est consequatur labore eum qui est. Recusandae suscipit qui non ut suscipit. Harum non molestiae fuga ut eos. Velit molestiae nihil et vero provident dolor vitae.
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...