Difference between revisions of "Manuals/calci/ODDFYIELD"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">ODDFYIELD(settle, M, I, FC, R, P, redem, F, basi...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)'''</div><br/> |
| + | *<math> s </math> is the settlement. | ||
| + | *<math> m </math> is the maturity. | ||
| + | *<math> iss </math> is the issue date. | ||
| + | *<math> fc </math> is the first coupon date. | ||
| + | *<math> r </math> is the rate of interest. | ||
| + | *<math> pr </math> is the security's price. | ||
| + | *<math> rdm </math> is the security's redemption. | ||
| + | *<math> f </math> is the frequency. | ||
| + | *<math> b </math> is the basis. | ||
| − | + | ==Description== | |
| − | + | *This function gives the yield of a security that pays interest periodically but has an odd first period. | |
| − | </ | + | *<math> ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)</math>,<math> s </math> is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased. |
| − | + | *<math> m </math> is the security's maturity date. This date is after the settlement date specifying when the security matures. | |
| − | < | + | *<math> iss </math> is the date which is specifying when the security was issued. |
| − | --- | + | *<math> fc </math> is the date which is specifying when the security has its first interest payment. This date must be after the settlement date but before the maturity date. |
| − | + | *<math> r </math> is a non-negative number specifying the interest rate for the coupons that the security pays. | |
| − | + | *<math> pr </math> is a non-negative number or currency specifying the security’s purchase price per $100 of face value. | |
| − | * < | + | *<math> rdm </math> is a number or currency specifying the security’s value at redemption per $100 of face value. |
| − | * | + | *<math> f </math> is is a number specifying the number of coupons per year. |
| − | + | *The supported values are | |
| − | + | 1 -annual payments | |
| + | 2 -semiannual payments | ||
| + | 4 -quarterly. | ||
| + | *<math> b </math> is an optional number specifying the day basis system to use. | ||
| + | *The following types are supported | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Basis | ||
| + | ! Day count basis | ||
| + | |- | ||
| + | | 0 or omitted || American 30/360 (default) | ||
| + | |- | ||
| + | | 1 || actual/actual | ||
| + | |- | ||
| + | | 2 || actual/360 | ||
| + | |- | ||
| + | | 3 || actual/365 | ||
| + | |- | ||
| + | | 4 || European 30/360 | ||
| + | |} | ||
| − | < | + | *To find the value of a <math> ODDFYIELD</math> we are using the iterative technique. |
| + | *The value is changed through 100 iterations until the estimated price with the given value is near to the price. | ||
| + | *The date arguments must satisfy the following conditions: | ||
| + | iss(issue)<s(settlement) <fc(first coupon) < m(maturity). | ||
| + | *Also <math> s </math>, <math> m </math>,<math> iss </math>,<math> fc </math> and <math> b </math> are truncated in to integers. | ||
| + | *This function gives the result as error when | ||
| + | 1.The date arguments s,m and fc are not a valid date. | ||
| + | 2.r<0 or pr<=0 | ||
| + | 3.b<0 or b>4 | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| − | + | ==References== | |
Revision as of 23:38, 2 March 2014
ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s } is the settlement.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m } is the maturity.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle iss } is the issue date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle fc } is the first coupon date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r } is the rate of interest.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr } is the security's price.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle rdm } is the security's redemption.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle f } is the frequency.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b } is the basis.
Description
- This function gives the yield of a security that pays interest periodically but has an odd first period.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s } is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m } is the security's maturity date. This date is after the settlement date specifying when the security matures.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle iss } is the date which is specifying when the security was issued.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle fc } is the date which is specifying when the security has its first interest payment. This date must be after the settlement date but before the maturity date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle r } is a non-negative number specifying the interest rate for the coupons that the security pays.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr } is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle rdm } is a number or currency specifying the security’s value at redemption per $100 of face value.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle f } is is a number specifying the number of coupons per year.
- The supported values are
1 -annual payments 2 -semiannual payments 4 -quarterly.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b } is an optional number specifying the day basis system to use.
- The following types are supported
| Basis | Day count basis |
|---|---|
| 0 or omitted | American 30/360 (default) |
| 1 | actual/actual |
| 2 | actual/360 |
| 3 | actual/365 |
| 4 | European 30/360 |
- To find the value of a Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ODDFYIELD} we are using the iterative technique.
- The value is changed through 100 iterations until the estimated price with the given value is near to the price.
- The date arguments must satisfy the following conditions:
iss(issue)<s(settlement) <fc(first coupon) < m(maturity).
- Also Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s } , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m } ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle iss } ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle fc } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b } are truncated in to integers.
- This function gives the result as error when
1.The date arguments s,m and fc are not a valid date. 2.r<0 or pr<=0 3.b<0 or b>4