Re:Fintech engineering mistakes
by karmakurtisaani on Wednesday June 28, 2023 @10:48AM
(#36507260)
If Excel uses doubles for money, it should be a warning sign. It uses simple numeric data type (I guess just ints) for freaking dates.. I can trace at least a couple of bugs in my career to just that fact.
[ Parent
| on HN ]
Apart from its quirks Excel is fine, if you know its limitations. I think the real warning sign would be an analyst/programmer working with Excel and expecting high precision results.
Re:Fintech engineering mistakes
by Mordisquitos on Wednesday June 28, 2023 @11:24AM
(#36507848)
Everything is fine apart from its quirks, if you know its limitations. The problem is when a tool's quirks and limitations are neither exhaustively documented nor can they be inferred from having reasonable knowledge about the base principles of the tool, but are rather learnt by experience (to be read as "through bad experiences").