Compare ODDFPRICE and ODDLPRICE functions in Excel

In the process of securities investment, no one can ignore the value of bonds of securities. The following article guides 2 ways of calculating bond values ​​by comparing ODD ODDFPRICE and ODDLPRICE functions in Excel.

1. Comparison of meanings

- Same:

+ Both functions are functions in the statistical function group.

+ They return the price per 100USD face value of the stock.

- Different:

+ ODDFPRICE function : Returns the price per $ 100 face value of a stock with an odd first cycle.

+ ODDLPRICE function : Different from ODDFPRICE, returned at the odd end of the cycle. ODDLPRICE returns the price per $ 100 face value of a stock with an odd last period.

2. Comparison of syntax

- ODDFPRICE (settlement, maturity, issue, first_coupon ,, rate, yld, redemption, frequency, basis) .

- ODDLPRICE (settlement, maturity, last_interest, rate, yld, redemption, frequency, basis) .

Through the syntax above 2 functions found:

- Same:

+ The number of parameters and the same parameters: settlement, maturity, rate, yld, redemption, frequency, basis.

+ The same parameters have the same value or meaning.

- Difference : Two different functions in the third argument:

+ Ham ODDFPRICE the third parameter is first_coupon - is the first coupon date of the stock.

+ ODDLPRICE function the third parameter is last_interest- is the last coupon date of the stock.

So the syntax for both functions is only different in the third parameter, one function is to calculate the first coupon date and the other to calculate the last coupon date of the stock.

Note: Calculation formula of ODDFPRICE function.

Compare ODDFPRICE and ODDLPRICE functions in Excel Picture 1

3. Compare function values ​​through specific examples

For example: Calculate the value of a bond with a redemption value (based on $ 100) and calculate the first interest period as odd.

With the following data table:

Because the bond has the first interest period is odd, the last period is also odd.

Thus, the value of bonds is determined at two different times. The first time is the first odd coupon period, the second time is the last coupon period.

- Calculate the value of bonds in the first interest period .

Because the value is calculated in the first coupon period, the ODDFPRICE function should be used . In the cell to calculate, enter the formula: = ODDFPRICE (B $ 7, C $ 7, D $ 7, E $ 7, F $ 7, G $ 7, H $ 7, I $ 7, J $ 7) press Enter to get the result:

Compare ODDFPRICE and ODDLPRICE functions in Excel Picture 2

- Calculate the value of bonds in the last interest period .

Because of the final period value, use the ODDLPRICE function . In the cell to calculate enter the formula: = ODDLPRICE (B11, C11, D11, E11, F11, G11, H11, I11) .

Compare ODDFPRICE and ODDLPRICE functions in Excel Picture 3

Above are the similarities and differences between ODDFPRICE and ODDLPRICE functions .

Good luck!

4 ★ | 1 Vote

May be interested

  • How to compare 2 Excel files to see if there is any differenceHow to compare 2 Excel files to see if there is any difference
    if you work with excel spreadsheets regularly, we can easily find out the differences on excel files. but if you are new to excel and you have to compare 2 excel files to see what is different but do not know how? please follow the article below to answer that question!
  • Date time functions in ExcelDate time functions in Excel
    excel supports you to process and calculate quickly with the functions that excel provides such as calculation functions, date functions ... one of them is the function of time to help you handle the prices. time value: hour, minute, second conveniently
  • 10 EXCEL functions that ACCOUNTERS often use10 EXCEL functions that ACCOUNTERS often use
    in excel, there are many functions that can help accounting in daily data entry, but here are some common functions used by accounting.
  • How to Compare Data in ExcelHow to Compare Data in Excel
    this tipsmake article will show you how to compare two different data sets in excel, from two columns in the same spreadsheet to two independent excel files.
  • The 10 most useful but often forgotten functions in excelThe 10 most useful but often forgotten functions in excel
    microsoft excel is an extremely effective and effective calculation tool not only for accounting and office but also for many other industries.
  • Logical functions (logical) in ExcelLogical functions (logical) in Excel
    logical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
  • How to Compare Two Excel FilesHow to Compare Two Excel Files
    this article will show you how to directly compare data between two excel files. after manipulating and comparing information, you might consider using look up, index, and match to aid in analysis.
  • How to use Excel's VALUE functionHow to use Excel's VALUE function
    excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
  • Instructions for using Index function in ExcelInstructions for using Index function in Excel
    index is a function that returns an array in excel. when using the index function, you get the values ​​in a cell between the column and the row.
  • Tips for working with functions in ExcelTips for working with functions in Excel
    functions that work with excel functions functions are predefined formulas for performing specific calculations, or for manipulating spreadsheets.