When you are parsing legacy financial data or executing specific types of Treasury bond calculus in Microsoft Excel, security prices are often quoted using an archaic fractional notation (e.g., $1.02 represents one dollar and 2/32nds of a dollar, not one dollar and two cents). If you attempt to inject these raw fractional strings into standard financial equations, the Excel engine will fail catastrophically. To force the engine to algorithmically convert these fractional prices into standard, mathematically usable decimal prices, you must deploy the DOLLARDE function.
Understanding the DOLLARDE Architecture
The DOLLARDE (Dollar Decimal) function is a highly specialized string translation engine. It ingests a fractional dollar value (where the decimal point is being incorrectly used as a separator for the fraction) and the absolute integer representing the fraction’s denominator. It then mathematically recalculates the payload and outputs a true, base-10 decimal integer.
The syntax requires exactly two mandatory arguments: =DOLLARDE(fractional_dollar, fraction)
- fractional_dollar: The absolute number quoted in fractional notation (e.g., 1.02).
- fraction: The absolute integer to be used as the denominator of the fraction (e.g., 32).
Executing the Decimal Conversion
Imagine you have a Treasury bond priced at 101 and 3/32 (written in standard legacy notation as 101.03) located in cell A1. The denominator is 32 (A2).
To execute the extraction, click an empty cell and type:
=DOLLARDE(A1, A2)The exact millisecond you press Enter, the Excel engine executes the conversion algorithm. It mathematically isolates the .03, calculates 3 divided by 32 (which equals 0.09375), and adds it back to the integer 101. It outputs a pristine, mathematically usable base-10 decimal: 101.09375. This output vector can now be safely injected into standard yield or duration formulas without corrupting your financial model.