DOLLARDE
A price written as a whole part and a fraction of a denominator (1.02 for 1 2/16), as a decimal number.
Group: Financial. Compatible with DAX.
Syntax
DOLLARDE ( <fractional_dollar>, <fraction> )| Parameter | Type | Description |
|---|---|---|
fractional_dollar | Number | A price written as a whole part and a numerator after the point: 1.02 for 1 and 2/16 when fraction is 16. |
fraction | Whole number | The denominator of the fraction: 16 for sixteenths, 32 for thirty-seconds. |
Returns
Number. The same price as an ordinary decimal number.
Remarks
- The digits after the point are read as a numerator padded to as many digits as the denominator has: with 16, .02 is 2/16 and .1 is 10/16; with 32, .1 is 10/32.
- The fraction is rounded to a whole number and must then be at least 1. A negative price keeps its sign.
- Bond prices were long quoted this way in the United States;
DOLLARFRwrites a decimal price back.
Examples
Prices in sixteenths and thirty-seconds
EVALUATE
ROW (
"1.02 in 16ths", DOLLARDE ( 1.02, 16 ),
"1.1 in 32nds", DOLLARDE ( 1.1, 32 )
)| 1.02 in 16ths | 1.1 in 32nds |
|---|---|
| 1.125 | 1.3125 |