How can we help?
Name of Formula:
Definition/Description of Formula:
This function returns the price per $100 face value of a discounted security.
PRICEDISC(settlement, maturity,discount, redemption, basis)
settlement- Enter the date after issuance when the security is delivered to the buyer.
maturity- The end date of the security, when it could be redeemed.
redemption- The redemption value of the security.
0by default ] - An indicator of what day count method to use.
0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.
Step 1. To begin to use PRICEDISC formula, start with the Excellentable you would like to edit..
Step 2. Then type the PRICEDISC formula into the cell you have chosen to display the outcome:
Step 3. Enter in the values needed to achieve your final outcome
Step 4. Once saved, your completed formula will display in a confluence page like this.