Financial Dates(金融日期)

函数列表

1. 实际间隔天数(Actual number of days between dates)

daysact(start_date <,end_date>);

2. 间隔天数,30E/360(Days between dates based on 360-day year (European))

days360e(start_date,end_date);

3. 间隔天数,30/360(ISDA)(Days between dates based on 360-day year (International Swap Dealer Association (ISDA) compliant))

days360isda(start_date,end_date);

4. 间隔天数,30/360(PSA)(Days between dates based on 360-day year (Public Securities Association (PSA) compliant))

days360psa(start_date,end_date);

5. 间隔天数,30/360(SIA)(Days between dates based on 360-day year)

days360(start_date,end_date);

6. 间隔天数,一年365天(Days between dates based on 365-day year)

days365(start_date,end_date);

7. 间隔天数(Days between dates for any day-count basis)

daysdif(start_date,end_date <,basis>);

8. 多少天以后/以前的日期(Date away from starting date for any day-count basis)

daysadd(start_date,num_days <,basis>)

9. 将来或过去月数的日期(Date of day in future or past month)

datemnth(start_date,num_months <,day_flag,basis,end_month_rule>)

混沌 <youliang@chaoskey.com>

http://blog.chaoskey.com