[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
    - ACCRINT
    - ACCRINTM
    - AMORDEGRC
    - AMORLINC
    - COUPDAYBS
    - COUPDAYS
    - COUPDAYSNC
    - COUPNCD
    - COUPNUM
    - COUPPCD
    - CUMIPMT
    - CUMPRINC
    - DB
    - DDB
    - DISC
    - DOLLARDE
    - DOLLARFR
    - DURATION
    - EFFECT
    - FV
    - FVSCHEDULE
    - INTRATE
    - IPMT
    - IRR
    - ISPMT
    - MDURATION
    - MIRR
    - NOMINAL
    - NPER
    - NPV
    - ODDFPRICE
    - ODDFYIELD
    - ODDLPRICE
    - ODDLYIELD
    - PDURATION
    - PMT
    - PPMT
    - PRICE
    - PRICEDISC
    - PRICEMAT
    - PV
    - RATE
    - RECEIVED
    - RRI
    - SLN
    - SYD
    - TBILLEQ
    - TBILLPRICE
    - TBILLYIELD
    - VDB
    - XIRR
    - XNPV
    - YIELD
    - YIELDDISC
    - YIELDMAT
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

YIELDDISC

This function calculates the annual yield for a discounted security.

Syntax

YIELDDISC(settle, maturity, price, redeem, basis)

Arguments

This function has these arguments:

Argument	Description
settle	Settlement date for the security
maturity	Maturity date for the security
price	Price per $100 face value for the security
redeem	Redemption value per $100 face value
basis	[Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

Remarks

This function returns a #VALUE! error when settle or maturity is invalid.

If price or redeem is less than or equal to 0, a #NUM! error is returned.
If basis is less than 0 or greater than 4, a #NUM! error is returned.
If settle is greater than or equal to maturity, a #NUM! error is returned.

Settle, maturity, and basis are truncated to integers.

Data Types

Accepts numeric data and dates. Returns numeric data.

Examples

YIEDDISC(B1,B2,B3,B4,B5)