3 ms·
one of the big problems with excel as a tool in these sorts of situations is that it is almost impossible to audit. yes, a non-programmer can hack something up
by jgamman 15y ago
one of the big problems with excel as a tool in these sorts of situations is that it is almost impossible to audit. yes, a non-programmer can hack something up that kinda does what they want but have they stress tested it? there's some statistical evidence (don't have time to google) evidence that virtually all spreadsheets contain errors, add in that these spreadsheets are running large $$ decisions and you have a recipe for... well, pretty much what you see all the time lately ;-)
- paperwork 15y agoI completely agree. A few years ago a large bank banned spread sheet based quant models from their desk. There are certainly draw-backs, I wouldn't want to give my programming languages for spread-sheets, as they exist now. However, I think programmers often forget that there are lots of good ideas in Excel as well.