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

FUTURE_VALUE_SCHEDULE

INVESTMENT_DURATION

Last updated 8 months ago

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`

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.