[R] R equivalent functions of some EXCEL functions

Greg Snow 538280 at gmail.com
Wed May 14 21:16:26 CEST 2014


You could search all of CRAN using the RSiteSearch function for terms
like bond or coupon.  There are also Task Views for Finance and
Econometrics that may point you towards useful packages.

On Wed, May 14, 2014 at 3:07 AM, Katherine Gobin
<katherine_gobin at yahoo.com> wrote:
> Dear R forum,
>
>
> EXCEL has some standard functions e.g.
>
>
> (1) PRICE function : Returns the price per $100 face value of a security that pays periodic interest.
>
>
> (2) COUPDAYBS : Returns the number of days from the beginning of the coupon period to the settlement date.
>
>
> (3) COUPDAYS : Returns the number of days in the coupon period that contains settlement date.
>
>
> 4) COUPDAYSNC : Returns the number of days from the settlement date to the next coupon date.
>
>
> Kindly guide if R has some inbuilt functions giving the results same as obtained from Excel functions mentioned above.
>
>
> With regards
>
> Katherine
>         [[alternative HTML version deleted]]
>
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Gregory (Greg) L. Snow Ph.D.
538280 at gmail.com



More information about the R-help mailing list