YIELDMAT

YIELDMAT is a DAX function that returns the annual yield of a security that pays interest at maturity. Syntax Argument Properties Description Settlement The security’s settlement … Read More

PRICEDISC

PRICEDISC is a DAX function that returns the price per $100 face value of a discounted security. Syntax Argument Properties Description Settlement The security’s settlement date. … Read More

PRICEMAT

PRICEMAT is a DAX function that returns the price per $100 face value of a security that pays interest at maturity. Syntax Argument Properties Description Settlement … Read More

ODDLPRICE

ODDLPRICE is a DAX function that returns the price per $100 face value of a security with an odd last period. Syntax Argument Properties Description Settlement … Read More

ODDLYIELD

ODDLYIELD is a DAX function that returns the yield of a security with an odd last period. Syntax Argument Properties Description Settlement The security’s settlement date. … Read More

ODDFYIELD

ODDFYIELD is a DAX function that returns the yield of a security with an odd first period. Syntax Argument Properties Description Settlement The security’s settlement date. … Read More

ODDFPRICE

ODDFPRICE is a DAX function that returns the price per $100 face value of a security with an odd first period. Syntax Argument Properties Description Settlement … Read More

COUPPCD

COUPPCD is a DAX function that returns the previous coupon date before the settlement date. Syntax Argument Properties Description Settlement The security’s settlement date. The … Read More

COUPNUM

COUPNUM is a DAX function that returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole … Read More

COUPNCD

COUPNCD is a DAX function that returns the next coupon date after the settlement date. Syntax Argument Properties Description Settlement The security’s settlement date. The … Read More