The Excel ODDLPRICE function returns the price per $100 face value of a security with an odd (irregular) last period.Read more
The term "eta lambda" is short for "eta reduced lambda". Although the name sounds complicated, the intent is actually the reverse. Eta lambda refers to a simpler syntax for passing in custom calculations to newer functions like BYROW, BYCOL, SCAN, REDUCE, etc. that are designed to take advantage...Read more
The Excel DURATION function returns the annual duration of a security with periodic interest payments, calculated with the Macauley duration formula.Read more
The Excel DISC function returns the discount rate for a security.Read more
The Excel COUPNUM function returns the number of coupons, or interest payments, payable between the settlement date and maturity date.Read more
The replace function lets you replace text based on its location and length. In this case, we want to strip off the drive and path and leave only the document name. The length of this part of the string (text) is 24 and the starting position is 1, and the pattern never changes.
The...Read more
The Excel ODDLYIELD function returns the yield of a security with an odd (irregular) last period.Read more
The Excel ODDFYIELD function returns the yield of a security with an odd (irregular) first period.Read more