← Prev in month ← Prev in thread

Date resources (YEARFRAC)

From
David A. Wheeler <>
Date
2008-04-14T22:47:10+00:00
ID
Thread
Date resources (YEARFRAC)
Just to be clear: There _ARE_ some resources that attempt to describe date calculations.
One of the best is "EMU AND MARKET CONVENTIONS: RECENT DEVELOPMENTS":
  http://www.isda.org/c_and_a/pdf/mktc1198.pdf 
I'm not certain that code can be unambiguously written from it (it's all prose and
no equations), but it's clearer than most.  For example, it shows multiple Actual/Actual
conventions. But (1) with only prose it's hard to be sure, and (2) there's no mapping
of these conventions to spreadsheet "Basis" values.  It's not even sure they map at all.
I'm trying to convert the text into code, but because it's prose that is NOT intended to
implemented by computer, it's hard to do easily.

Other sources are, of course, open source implementations' code.  Here is KOffice's:
http://api.kde.org/koffice-api/koffice-apidocs/kspread/html/helper_8cpp-source.html#l00194

I'm sure our friends from OpenOffice.org and others can point to similar files for their code,
in those cases where it's publicly accessible.

--- David A. Wheeler
← Prev in month ← Prev in thread