currency

How to use GOOGLEFINANCE((“CURRENCY:EURAUD”)) function

by

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

How to represent currency in Go?

by

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

Format negative amount of USD with a minus sign, not brackets (Java)

by

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

Angular Js currency, symbol euro after

by

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