|
The DOLLARFR Function
The DOLLARFR function converts a dollar price expressed
as a decimal number into a dollar price expressed as a fraction
(displaying only the numerator). This function is particularly
useful for displaying treasury data. When retrieved into Excel,
treasury data displays as an actual decimal value rather than
a fraction. For example, the last price for US Treasury Notes
futures, TUH5, displays as a 32nd in the Reuter Terminal (10*17
with the asterisk signifying 32nds), but it displays as a decimal
number when it's retrieved into Excel (100.53125). To convert
this number to 32nds, you should use the following formula:
| =DOLLARFR(decimal_number,
denominator) |
where decimal_number refers to the cell with the reference
to TUH5 and denominator is 32. Your Excel spreadsheet
should look like this:
Although
this value now displays 32nds exactly as many users might prefer,
be careful when using this data in calculations. Excel treats
this converted number as a real decimal, not a fraction, and all
formulas that use this number in calculations will assume the
value is 10.17, not 10.53125.
|
