Документ взят из кэша поисковой машины. Адрес оригинального документа : http://uneex.mithril.cs.msu.su/static/GnumericDoc_ru/r6902.html
Дата изменения: Mon Sep 26 12:35:55 2011
Дата индексирования: Mon Oct 1 22:51:50 2012
Кодировка: UTF-8
ODDLYIELD

ODDLYIELD

Name

ODDLYIELD -- 

Synopsis

ODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency[,basis])

Description

ODDLYIELD calculates the yield of a security having an odd last period. @settlement is the settlement date of the security. @maturity is the maturity date of the security. @frequency is the number of coupon payments per year. Allowed frequencies are: 1 = annual, 2 = semi, 4 = quarterly. @basis is the type of day counting system you want to use:

0 US 30/360

1 actual days/actual days

2 actual days/360

3 actual days/365

4 European 30/360

If @frequency is other than 1, 2, or 4, ODDLYIELD returns #NUM! error. If @basis is omitted, US 30/360 is applied. If @basis is not in between 0 and 4, #NUM! error is returned.

Examples

See also