Error Messages/41089

Error message examples

 In the call to YearFrac, a bad value was passed to the parameter «basis».
 It must be between 0 and 4 inclusive.

Cause

YearFrac(startDate, endDate, basis) calculates the fractional duration in years between the «startDate» and «endDate». The «basis» parameter, which can take values from 0 to 4, specifies the method used to calculate the fractional duration. You seemed to have passed an invalid value to the «basis» parameter.

The valid values for the «basis» parameter and the method used are as follows:

0 (or omitted) = US (NASD) 30/360

1 = actual/actual

2 = Actual/360

3 = Actual/365

4 = European 30/360

Remedies

Correct the «basis» parameter passed to the YearFrac function to be between 0 and 4 inclusive.

See Also

• Function calls and parameters
• Objects and values
• YearFrac
• Financial functions: YearFrac