undefined | Better HN

0 pointsgiaour2y ago0 comments

> Javascript in Excel would be nice.

JS has been one of the supported add-in languages for a while[0], but that's not quite the same thing as the new python offering (which sounds more like jupyter within excel).

Since excel is often (mostly?) used for working with financial calculations, I for one am glad they went with python for this feature instead of a language that insists that an IEEE 754 double is the only kind of number anybody actually needs

0 comments

extraduder_ire2y ago

JS has BigInt now, and it almost works like you'd expect. Need to put 'n' after all of your numbers though.

giaourOP2y ago

True, but financial calculations tend to involve non-integral numbers. Python has arbitrary-precision decimals via: https://docs.python.org/3.11/library/decimal.html

WorldMaker2y ago

Financial calculations are also sometimes already used to doing math in integral pennies (or eighths of a penny) for performance/storage reasons. That works just fine with one BigInt. Or you can build arbitrary-precision rationals from just two BigInts. (There are some JS libraries out there already for that.)

1 more reply

j / k navigate · click thread line to collapse