There’s a clear best option out of the three you suggested (plus one from the comments). BIGINT — uses just 8 bytes, but the largest BIGINT only has 19 decimal digits; if you divide by 1018, the largest value you can represent is 9.22, which isn’t enough range. DOUBLE — only has 15–17 decimal digits … Read more
The specific instructions for what you are looking for are in here: https://support.google.com/docs/answer/3093281 Remember your Google Spreadsheets Formulas might use semicolon (;) instead of comma (,) depending on Regional Settings. Once made the replacement on some examples would look like this: =GoogleFinance(“CURRENCY:USDEUR”) =INDEX(GoogleFinance(“USDEUR”,”price”,today()-30,TODAY()),2,2) =SPARKLINE(GoogleFinance(“USDEUR”,”price”,today()-30,today())) Those 3 cells would result in something like this (the second … Read more
I’d say a way to go is to store amounts of money using properly sized integer type, normalized to the lowest possible amount. Say, if you need to store amounts in US dollars down to one cent, multiply your values by 100 and hence store them in full cents. Another way is to implement a … Read more
Decimal and money ought to be pretty reliable. What i can assure you (from painful personal experience from inherited applications) is DO NOT use float!
It requires a little tweaking of the DecimalFormat returned by NumberFormat.getCurrencyInstance() to do it in a locale-independent manner. Here’s what I did (tested on Android): DecimalFormat formatter = (DecimalFormat)NumberFormat.getCurrencyInstance(); String symbol = formatter.getCurrency().getSymbol(); formatter.setNegativePrefix(symbol+”-“); // or “-“+symbol if that’s what you need formatter.setNegativeSuffix(“”); IIRC, Currency.getSymbol() may not return a value for all locales for all … Read more
You don’t have to hack the currency filter! AngularJS has a great support for i18n/l10n. The currency filter uses the default currency symbol from the locale service and positions it based on the locale settings. So it’s all about supporting and setting the right locale. <script src=”https://stackoverflow.com/questions/27547680/i18n/angular-locale_de-de.js”></script> If you are using npm or bower all … Read more
If you don’t mind rounding… price.ToString(“c0”)