| function name |
function description |
grammatical form |
| ACCRINT |
portfolio to return to regular payment of accrued interest. |
ACCRINT (issue, first_interest, settlement, rate , par, frequency, basis) |
| ACCRINTM |
due to return to a one-time payment of accrued interest securities. |
ACCRINTM (issue, maturity, rate, par, basis) |
| AMORDEGRC |
return for each accounting period the value of depreciation. This function is provided by the French accounting system. |
AMORDEGRC (cost, date_purchased, first_period, salvage, period, rate, basis) |
| AMORLINC |
return to the depreciation for each accounting period the value of the function provided by the French accounting system. |
AMORLINC (cost, date_purchased, first_period, salvage, period, rate, basis) |
| COUPDAYBS |
back to the end of the current interest period on the number of days traded. |
COUPDAYBS (settlement, maturity, frequency, basis) |
| COUPDAYS |
turnover on the return of the payment period where the number of days. |
COUPDAYS (settlement, maturity, frequency, basis) |
| COUPDAYSNC |
return from the transaction to the next coupon payment date on the number of days between. |
COUPDAYSNC (settlement, maturity, frequency, basis) |
| COUPNCD |
return after closing on the date of the next coupon payment date. |
COUPNCD (settlement, maturity, frequency, basis) |
| COUPNUM |
transaction and due to return to Japan to cope with the number of interest, rounded upward to the nearest whole number. |
COUPNUM (settlement, maturity, frequency, basis) |
| COUPPCD |
return to the last transaction before the date of a coupon payment date. |
COUPPCD (settlement, maturity, frequency, basis) |
| CUMIPMT |
return a loan in a given start-period to the end-period interest during the repayment of the amount accumulated. |
CUMIPMT (rate, nper, pv, start_period, end_period, type) |
| CUMPRINC |
return to a loan given to the start-period during the end-period total of the principal amount repaid. |
CUMPRINC (rate, nper, pv, start_period, end_period, type) |
| DB |
fixed declining balance method to calculate an asset in a given period of depreciation value. |
DB (cost, salvage, life, period, month) |
| DDB |
using double declining balance method or other specified method in calculating an asset in a given period of depreciation value. |
DDB (cost, salvage, life, period, factor) |
| DISC |
return to the discount rate securities. |
DISC (settlement, maturity, pr, redemption, basis) |
| DOLLARDE |
Score said the price will be converted to that price by a small number, such as securities prices, that is converted to decimal numbers. |
DOLLARDE (fractional_dollar, fraction) |
| DOLLARFR |
that the price of a small number will be converted to by the scores of that price. Such as securities prices, converted into digital scores. |
DOLLARFR (decimal_dollar, fraction) |
| DURATION |
face value of $ 100 to return to the assumption that the regular payment period portfolio amendments. Period cash flow is defined as a series of present value of the weighted average price used to measure the bond yield changes for the degree of sensitivity. |
DURATION (settlement, maturity, coupon yld, frequency, basis) |
| EFFECT |
use the name of a given interest rate and one-year period of time of compound interest to calculate the actual annual interest rate. |
EFFECT (nominal_rate, npery) |
| FV |
matching based on a fixed rate of interest and installments, the return value of an investment in the future. |
FV (rate, nper, pmt, pv, type) |
| FVSCHEDULE |
compound return of principal based on a series of future value. FVSCHDULE function used to calculate the investment in an adjustable interest rate changes or the future value. |
FVSCHEDULE (principal, schedule) |
| INTRATE |
return to a one-time interest rate securities. |
INTRATE (settlement, maturity, investment, redemption, basis) |
| IPMT |
matching based on a fixed rate of interest and installments, the return of the investment or loan at a given time within the regular repayment of the amount of interest. |
IPMT (rate, per, nper, pv, fv, type) |
| IRR |
return by the value representative of a group of cash flow internal rate of return. |
IRR (values, guess) |
| ISPMT |
particular investment during the calculation of the interest to be paid. |
ISPMT (rate, per, nper, pv) |
| MDURATION |
return to the assumption that the portfolio with a face value of $ 100 to amend the Macauley duration. |
MDURATION (settlement, maturity, coupon, yld, frequency, basis) |
| MIRR |
a continuous period of return to cash flow internal rate of return of the amendment. |
MIRR (values, finance_rate, reinvest_rate) |
| NOMINAL |
given based on the actual interest rates and several years of compound interest, nominal interest rate return. |
NOMINAL (effect_rate, npery) |
| NPER |
matching based on a fixed rate of interest and installments, the return of an investment (or loan) the total number of installments. |
NPER (rate, pmt, pv, fv, type) |
| NPV |
through the use of the discount rate and a series of future expenditures (negative) and income (positive), the net present value of an investment return. |
NPV (rate, value1, value2, ...) |
| ODDFPRICE |
return to the first coupon payment date is not a face value of $ 100 fixed price of the portfolio |
ODDFPRICE (settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, basis) |
| ODDFYIELD |
return to the first coupon payment date is not fixed portfolio (long-term or short-term) rate of return. |
ODDFYIELD (settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, basis) |
| ODDLPRICE |
back to the late payment is not fixed on a face value of $ 100 of securities (long-term or short-term) price. |
ODDLPRICE (settlement, maturity, last_interest, rate, yld, redemption, frequency, basis) |
| ODDLYIELD |
back to the late payment of interest on the securities is not fixed (long-term or short-term) rate of return. |
ODDLYIELD (settlement, maturity, last_interest, rate, pr, redemption, frequency, basis) |
| PMT |
matching based on a fixed rate of interest and installments, each payment to return the loan. |
PMT (rate, nper, pv, fv, type) |
| PPMT |
matching based on a fixed rate of interest and installments, to return to invest in a given period of time to repay the principal amount. |
PPMT (rate, per, nper, pv, fv, type) |
| PRICE |
return to regular payment of the face value of $ 100 the price of securities. |
PRICE (settlement, maturity, rate, yld, redemption, frequency, basis) |
| PRICEDISC |
return to discount the face value of $ 100 Issuance of securities prices. |
PRICEDISC (settlement, maturity, discount, redemption, basis) |
| PRICEMAT |
interest due to return to the face value of $ 100 the price of securities. |
PRICEMAT (settlement, maturity, issue, rate, yld, basis) |
| PV |
the present value of the return of investment. The present value of future payments for a range of current values of accumulation and. For example, the borrowing side is the lending side借入款the present value of the loan. |
PV (rate, nper, pmt, fv, type) |
| RATE |
return periods of interest rate annuities. RATE function calculated through the iterative method, and may be no solution or multiple solutions. |
RATE (nper, pmt, pv, fv, type, guess) |
| RECEIVED |
portfolio return of one-time payment to recover the amount due. |
RECEIVED (settlement, maturity, investment, discount, basis) |
| SLN |
The return of an asset in a depreciation period of the linear value. |
SLN (cost, salvage, life) |
| SYD |
return of an asset by the number of years of depreciation method to calculate the sum of the depreciation value of the specified period. |
SYD (cost, salvage, life, per) |
| TBILLEQ |
return the equivalent Treasury yield. |
TBILLEQ (settlement, maturity, discount) |
| TBILLPRICE |
return to a face value of $ 100 the price of the Treasury. |
TBILLPRICE (settlement, maturity, discount) |
| TBILLYIELD |
Treasuries yield return. |
TBILLYIELD (settlement, maturity, pr) |
| VDB |
the use of double declining balance method or other methods specified, the return of any period specified (including part of the period) depreciation of assets. VDB function on behalf of variable declining balance method. |
VDB (cost, salvage, life, start_period, end_period, factor, no_switch) |
| XIRR |
cash flow to return to a group of the internal rate of return, the cash flow does not must occur regularly. To calculate a set of regular cash flow internal rate of return, use the function of IRR. |
XIRR (values, dates, guess) |
| XNPV |
return a net present value cash flow, the cash flow does not necessarily occur regularly. To calculate a set of regular cash flow net present value, use the function NPV. |
XNPV (rate, values, dates) |
| YIELD |
portfolio return of regular interest rate of return, YIELD function used to calculate the bond yields. |
YIELD (settlement, maturity, rate, pr, redemption, frequency, basis) |
| YIELDDISC |
return discount securities issued by the annual rate of return. |
YIELDDISC (settlement, maturity, pr, redemption, basis) |
| YIELDMAT |
due to return to the portfolio's annual interest rate of return. |
YIELDMAT (settlement, maturity, issue, rate, pr, basis) |
