INTRATE

Effective interest rate

Description

Calculates the effective interest rate when an investment is bought for one value and sold for another where no interest or dividends were generated by the investment.

Function signature

INTRATE(buydate: String, selldate: String, buyprice: Number, sellprice: Number, basis: String = us_nasd) => Number

Parameter

Description

Buy date

The date of purchase of the investment.

Sell date

The date of sale of the investment.

Buy price

The price at which the investment was purchased.

Sell price

The price at which the investment was sold.

Basis

Method to use for counting days per month/year:

  • `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).

  • `actual`: Actual number of days per month/year.

  • `actual_360`: 360 day year, actual number of days per month.

  • `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.

  • `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.

Examples

date1 = "2010-01-02T13:06:15+03:00"
date2 = "2019-12-31T13:06:15+03:00"
date3 = "2009-01-31T13:06:15+03:00"
date4 = "2023-10-31T13:06:15+03:00"
date5 = "2009-01-30T13:06:15+03:00"
date6 = "2023-10-30T13:06:15+03:00"
date7 = "2009-01-31T13:06:15+03:00"
date8 = "2023-10-30T13:06:15+03:00"

Formula

Return value

INTRATE(date1, date2, 90, 140, "us_nasd")

0.05557099

INTRATE(date1, date2, 90, 140)

0.05557099

INTRATE(date1, date2, 90, 140, "actual")

0.055586

INTRATE(date3, date4, 290, 300, "us_nasd")

0.00233781

INTRATE(date5, date6, 290, 300, "actual_360")

0.00230483

INTRATE(date7, date8, 290, 300, "actual")

0.00233855