When you are executing financial modeling on specific legacy debt instruments (like certain U.g. Treasury bonds), the market price is often quoted in a mathematically complex fractional format rather than a standard decimal format. For example, a price might be quoted as “102 and 1/8”. If you attempt to use this raw fractional string in standard Excel yield calculations, the engine will instantly throw a catastrophic error. To force the Microsoft Excel engine to algorithmically translate this fractional notation into a pure, calculable decimal integer, you must deploy the DOLLARDE function.
Understanding the DOLLARDE Architecture
The DOLLARDE (Dollar Decimal) function is a highly specific parsing engine. It ingests a fractional price quoted as a pseudo-decimal (where the integer part is the whole dollar and the decimal part represents the numerator of the fraction) and the absolute denominator of that fraction. It executes a mathematical translation and outputs a pure decimal value.
The syntax requires exactly two mandatory arguments: =DOLLARDE(fractional_dollar, fraction)
- fractional_dollar: The quoted price expressed as a pseudo-decimal (e.g., 102.125 for 102 and 1/8).
- fraction: The mathematical denominator of the fraction (e.g., 8, 16, 32).
Executing the Fractional Translation
Imagine your firm receives a bond quote of 102 and 3/32. In Excel, this is often represented as 102.03 (Cell A1). The denominator for this specific market is 32 (Cell A2).
To execute the precise extraction of the pure decimal value, click an empty cell and type:
=DOLLARDE(A1, A2)The exact millisecond you press Enter, the Excel engine intercepts the data array. It parses the 102 as the whole integer. It takes the .03 (representing the numerator 3), divides it by the denominator 32, and mathematically fuses the result back to the integer. It outputs the highly precise absolute decimal integer: 102.09375.
This provides absolute mathematical proof of the true decimal price. You can now safely inject this pure integer (102.09375) into complex financial functions like YIELD or PRICE without triggering a calculation failure.