R help - May 2014 - R equivalent functions of some EXCEL functions

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]]

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