Avoiding float and double in monetary calculation

[wane]

Hello,
I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.
What is a good alternative?

Thanks

[Mike Wahler]

wane <no****@intechs .net> wrote in message
news:bi******** ****@ID-18576.news.uni-berlin.de...

Hello,
I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.
What is a good alternative?

Use an integer type, e.g. 'long'. E.g. if representing
U.S. currency, store pennies, not dollars, and do decimal point
detection and placement during i/o.

-Mike

[Gordon Burditt]

>calculation because of the lack of preciseness.

This depends, of course, on how much precision you need. If you're
estimating the cost of 1500 government toilet seats, "about 5 billion
dollars" might be good enough. If you're auditing the cost of 1500
toilet seats, you may need to worry about hundredths of cents.

What is a good alternative?

Integer quantities of the smallest monetary unit you need to deal
with (e.g. cents). If you've got an integer type bigger than 32
bits, try to use it. C89 doesn't guarantee that there is such a
type.

Gordon L. Burditt

[osmium]

wane writes:

I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.
What is a good alternative?

Some compilers offer a BCD (binary coded decimal) data type via an included
library.

[Rouben Rostamian]

In article <bi************ @ID-18576.news.uni-berlin.de>,
wane <no****@intechs .net> wrote:

I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.
Bill Gates has 100,000,000,000 in his savings account. His bank's
statement is printed using:

#include <stdio.h>
int main(void)
{
float y = 1e11F;

printf("Your balance is %.2f\n", y);
return 0;
}

The bank's computer prints the result as:

Your balance is 99999997952.00

Then Bill buys the bank...
What is a good alternative?

When dealing with Bill Gates' bank account, use an arbitrary precision
arithmetic library. Search the web for GNU MP library, but don't
tell Bill it's GNU.

--
Rouben Rostamian <ro*******@umbc .edu>

[E. Robert Tisdale]

wane wrote:

I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.

That's *not* true.
Double precision floating-point numbers are very precise.
Monetary calculations aren't very precise.
It's just that special rules for rounding are used
in calculations involving money.

If, for example, you divide $1.00 among three people,
there will be an extra penny left over.
Banks always keep this extra penny ;-)

[Morris Dovey]

wane wrote:

I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.
It depends on the range of values possible and the ability of the
programmers. The oldest stock exchange in the USA (PHLX) performs
monetary calculations using doubles for equity, option, and
currency trading - without precision problems.
What is a good alternative?

Again, it depends on the range of values. For a program on my
machine to keep track of my checking account, a char should be
sufficient to handle the full range in pennies ($1.27 through
-$1.28).

Your checking account may need to use long int; and your central
bank would probably need long long int values.

Question for you: What is the 1/100 part of a Euro called?
--
Morris Dovey
West Des Moines, Iowa USA
C links at http://www.iedu.com/c

[Randy Howard]

In article <ne************ ********@tomato .pcug.org.au>, kevin@-nospam-
pcug.org.au says...

Gordon Burditt <go***********@ sneaky.lerctr.o rg> wrote:

calculation because of the lack of preciseness.

This depends, of course, on how much precision you need. If you're
estimating the cost of 1500 government toilet seats, "about 5 billion
dollars" might be good enough. If you're auditing the cost of 1500
toilet seats, you may need to worry about hundredths of cents.

At a bit over 3 million dollars a pop, those had better be solid gold
toilet seats.

They're $3 toilet seats. Come on, how do you think the NSA funds all
their super secret underground computers? $3million buck toilet seats.

[Phil Tregoning]

"E. Robert Tisdale" <E.************ **@jpl.nasa.gov > wrote in
news:3F******** ******@jpl.nasa .gov:

wane wrote:

I have heard that one should avoid using float and double in monetary
calculation because of the lack of preciseness.

That's *not* true.
Double precision floating-point numbers are very precise.
Monetary calculations aren't very precise.
It's just that special rules for rounding are used
in calculations involving money.

If, for example, you divide $1.00 among three people,
there will be an extra penny left over.
Banks always keep this extra penny ;-)

I thought it was redirected to the bank account of the
programmer that wrote the code. That's how it used to
work in the good old days (*).

Phil T

(*) This is an urban legend.

[Keith Thompson]

Morris Dovey <mr*****@iedu.c om> writes:
[...]

Again, it depends on the range of values. For a program on my machine
to keep track of my checking account, a char should be sufficient to
handle the full range in pennies ($1.27 through -$1.28).

You should either explicitly use signed char, or be more careful about
bouncing checks.

--
Keith Thompson (The_Other_Keit h) ks*@cts.com <http://www.ghoti.net/~kst>
San Diego Supercomputer Center <*> <http://www.sdsc.edu/~kst>
Schroedinger does Shakespeare: "To be *and* not to be"