本文介绍 Microsoft Excel 中YIELD函数的公式语法和用法。 说明 返回定期支付利息的债券的收益。 函数 YIELD 用于计算债券收益率。 语法 YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) 重要:应使用 DATE 函数输入日期,或者将日期作为其他公式或函数的结果输入。 例如,使用函数 DATE(2008,5...
This article describes the formula syntax and usage of the YIELD function in Microsoft Excel. Description Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. Syntax YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) Important: Dates ...
This article describes the formula syntax and usage of the TBILLYIELD function in Microsoft Excel.. Description. Returns the yield for a Treasury bill. Syntax. TBILLYIELD(settlement, maturity, pr) 适用于:Microsoft 365 专属 Excel, Microsoft 365 Mac 版专属 Excel, Excel 网页版, Excel 2024, Exce...
YIELD Function The YIELD function in Excel is primarily used to calculate the yield to maturity (YTM) of a bond, issuing a periodic coupon. The function takes into account the bond's price, periodic coupon payments, face value, and the date of maturity. By using an iterative process, the...
To calculate the YTM of a bond in Excel, you need the following information: Settlement Date: The date when you purchased the security. All dates should be entered using the DATE function in Excel rather than as text. Maturity Date: This is the date when the security will expire. ...
Excel 程序集: Microsoft.Office.Interop.Excel.dll 返回末期付息日不固定(长期或短期)的债券的收益率。 C# 复制 public double OddLYield (object Arg1, object Arg2, object Arg3, object Arg4, object Arg5, object Arg6, object Arg7, object Arg8); 参数 Arg1 Object Settlement - 债券的结算日...
中,yield 是一种语法糖,用于生成器函数 (Generator Function)。生成器函数一种特殊的函数,它会在执行 过程中记录上一次返回的位置,并在下一次调用时返回之前的位置。 这使得生成函数可以模拟迭代器 (Iterator) 的行为,同时也支持 生成式表达式 (Generator Expression)。 当函数中 yield 关键字时,该函数即被视...
Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. The following table describes the values that can be used forArg8. ...
Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. 展開表格 0 or omitted US (NASD) 30/360 1 Actual/actual ...
Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. 展開表格 0 or omitted US (NASD) 30/360 1 Actual/actual ...