YIELDMAT DAX Function (Financial)
Returns the annual yield of a security that pays interest at maturity.
Syntax
YIELDMAT ( <Settlement>, <Maturity>, <Issue>, <Rate>, <Pr> [, <Basis>] )
| Parameter | Attributes | Description |
|---|---|---|
| Settlement |
The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. |
|
| Maturity |
The security’s maturity date. The maturity date is the date when the security expires. |
|
| Issue |
The security’s issue date. |
|
| Rate |
The security’s interest rate at date of issue. |
|
| Pr |
The security’s price per $100 face value. |
|
| Basis | Optional |
The type of day count basis to use. |
Return values
Scalar A single decimal value.
Last update: Mar 1, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://support.microsoft.com/en-us/office/yieldmat-function-ba7d1809-0d33-4bcb-96c7-6c56ec62ef6f
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies