AccrualFactor
Mon 01 January 2018Syntax
AccrualFactor(StartDate, EndDate, Accrual_Conv)
Description
Use the AccrualFactor function to compute a factor that's equal to the number of years of interest accrued during a date range, according to Accrual_Conv parameter.
Parameters
|
Field or Control |
Definition |
|---|---|
| StartDate |
The beginning of the time period for determining the accrual. This parameter takes a date value. |
| EndDate |
The end of the time period for determining the accrual. This parameter takes a date value. |
| Accrual_Conv |
The accrual convention. This parameter takes either a number or constant value. Values for this parameter are: |
|
Numeric Value |
Constant Value |
Description |
|---|---|---|
|
0 |
%Accrual_30DPM |
30/360: all months 30 days long according to NASD rules for date truncation |
|
1 |
%Accrual_30DPME |
30E/360: all months 30 days long according to European rules for date truncation |
|
2 |
N/A |
30N/360: all months but February are 30 days long according to SIA rules |
|
3 |
%Accrual_Fixed360 |
Act/360: months have variable number of days, but years have fixed 360 days |
|
4 |
%Accrual_Fixed365 |
Act/365: months have variable number of days, buy years have fixed 365 days |
|
5 |
%Accrual_ActualDPY |
Act/Act: months and years have a variable number of days |
Returns
A floating point number representing a number of years.