recovery
Derek Atkins
warlord at MIT.EDU
Wed Oct 31 16:35:44 EDT 2007
Quoting Mike or Penny Novack <stepbystepfarm at mtdata.com>:
>
>> Long ago, gnucash stored its data in binary, with its amounts of money
>> recorded in binary floating-point. I pointed out that this was not
>> adequate for financial data, wiere pennies matter on amounts line a
>> billion dollars, and the roundoff errors involved in binary/decimal
>> conversion are ultimately unacceptable.
>>
>> This started a revolution in which money would be represented in exact
>> form; as it happens they chose character strings that represented
>> amounts as an intergal number of tiny units of currency. For my
>> accounts, this unit turned out to be a penny. I gather it's different
>> for stock-trading accounts.
>>
>>
>>
> Suggestion (from somebody who used to do "financial" software for a living)
>
> That solution would be unnecessarily slow (repeated data conversion back
> and forth). The database and all calculations can be integer and only
> when the figures are to be displayed are they edited (decimal point
> inserted at the appropriate place). AKA "scaled decimal" representation.
> Fairly easy to write "edit mask" functions if not directly supported by
> language/hardware (precisely because of this usage COBOL and the IBM
> mainframes used in "financial" work provide for "edit mask" as a
> primitive ---- in other words, you can define a "mask" specifying fairly
> complex number editing and that determines how that number DISPLAYS)
Historically this doesn't work. How do you represent 1/3 in decimal?
> Michael
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list