← Prev in month ← Prev in thread

ODFF: DISC function

From
David King <>
Date
2008-08-16T17:03:47+00:00
ID
48A71687.8243.156B96D@localhost
Thread
ODFF: DISC function
DISC
* noting again that the formula given needs to divide by YEARFRAC 
not multiply
* I've verified that Excel and Calc both seem to use YEARFRAC 
internally to calculate DISC, therefore where there are problems 
in Excel/Calc with YEARFRAC (already noted by David Wheeler), 
they transfer to DISC. In addition of course, when Calc returns a 
value of YEARFRAC different to Excel, DISC will also be different 
(example 1Jan08 to 2Jan08, basis 1).


David
← Prev in month ← Prev in thread