PRICEMAT(settlement,maturity,issue,discount,yield,basis)
settlement: settlement date
maturity: maturity date
issue: date of issue
discount: annual rate at which to discount
yield: annual yield of security
basis: calendar basis
PRICEMAT calculates the price per $100 face value of a bond that pays interest at maturity.
If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.