PRICEMAT(settlement,maturity,issue,rate,yield[,basis])
PRICEMAT calculates and returns the price per $100 face value of a security. The security pays interest at maturity.
settlement is the settlement date of the security. maturity is the maturity date of the security. issue is the issue date of the security. rate is the discount rate of the security. yield is the annual yield of the security. 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