Usage Examples

Following examples show how to use the built-in calculator:

1. Type in the expression you want to evaluate in the editor. The whole expression should be written in one line.

2. Press Ctrl+Enter to calculate the expression when the caret is in the line of expression.

= 10.487600 < you will get the answer immediately

There are two special variables in the ditor calculator:

$ans .If you want to use the value that was evaluated in the earler step, use a special variable named $ans.

$pi .The value of the variable $pi is 3.1415926535.

$ans / $pi = 3.338307

The editor supports basic mathematics functions which are very similar to those used in C math library.

sin(1.2) + atan2(3.2, 4.3) = 1.571809

today, yeardays, monthdays, date2days, days2date, eomday, eomdate, weekday, isbizdate, nbizdate, pbizdate, adddays, addmonths, addterms, days360, days365, daysact, daysbet, monthsbet, termsbet, termfrac, yearfrac

mod, fmod fmod(x, y) - remainder functions returns the remainder f of the division of x by y, where f has the same sign as x, such that x=iy+f for some integer i, and |f| returns the remainder f of the division of x by y, where f has the same sign as x, such that x=iy+f for some integer i, and |f| < |y|.

ceil ceil(x) - ceiling function returns the smallest integer not less than x.

floor floor(x) - floor function returns the largest integer not greater than x.

round round(x) - round function rounds its argument to the nearest integral value.

min min(x, y) - minimum returns the minimum of a pair of values

max max(x, y) - maximum returns the maximum of a pair of values

acos acos(x) - arccosine function returns the arccosine of x in the range 0 to pi.

asin asin(x) - arcsine function returns the arcsine of x in the range -pi/2 to pi/2.

atan atan(x) - arctangent function returns the arctangent of x in the range -pi/2 to pi/2.

atan2 atan2(y, x) - arctangent-and-quadrant function returns the arctangent of y/x, in the range -pi to pi, using the signs of both arguments to determine the quadrant of the return value.

cos cos(x) - cosine function returns the cosine of x (x specified in radians).

sin sin(x) - sine function returns the sine of x (x specified in radians).

tan tan(x) - tangent function returns the tangent of x (x specified in radians).

cosh cosh(x) - hyperbolic cosine function returns the hyperbolic cosine of its argument.

sinh sinh(x) - hyperbolic sine function returns the hyperbolic sine of its argument.

tanh tanh(x) - hyperbolic tangent function returns the hyperbolic tangent of its argument.

exp exp(x) - exponential function returns e^x.

log log(x) - natural logarithm function returns the natural logarithm of x. The value of x must be greater than zero.

log10 log10(x) - common logarithm function returns the logarithm base ten of x. The value of x must be greater than zero.

pow pow(x, y) - power function returns x^y. If x is negative, y must be an integer value.

sqr sqr(x) - square function returns x*x.

sqrt sqrt(x) - square root function returns the non-negative square root of x. The value of x must not be less than zero.

Date Functions

today today() - current date returns the current date as a number. i.g. 20180807 (Aug. 07, 2018)

yeardays yeardays(year) - number of days in a year returns the actual number of days in the given year.

monthdays monthdays(year, month) - number of days in a month returns the actual number of days in the given month.

date2days date2days(date) - date to serial date number conversioN returns the number of days to the given date since the Epoch.

days2date days2date(date) - serial date number to date conversion date2days(date) returns the date calculated from the given number of days since the Epoch.

eomday eomday(year, month) - last day of month returns the last day of the month for the given year and month.

eomdate eomdate(year, month) - last date of month returns the last date of the month for the given year and month.

weekday weekday(date) - day of the week returns the day of the week in numeric form:

- 0 = Sun
- 1 = Mon
- 2 = Tue
- 3 = Wed
- 4 = Thu
- 5 = Fri
- 6 = Sat

isbizdate isbizday(date) - true for date that is business day returns 1 if date is a business day and 0 otherwise.

nbizdate nbizdate(date) - next business day returns the date of the next business day from the reference date.

pbizdate pbizdate(date) - previous business day returns the date of the previous business day from the reference date.

adddays adddays(date, days) - date added by given days returns the reference date added by given days.

addmonths addmonths(date, months, end_month) - date added by given months returns the reference date added by given months end_month:

- 0 = actual
- 1 = end month

addterms addterms(date, terms, frequency, end_month) - date added by given terms returns the reference date added by given terms frequency:

- 1 = annual
- 2 = semiannual
- 4 = quarterly
- 6 = bimonthly
- 12 = monthly

end_month:

- 0 = actual
- 1 = end month

days360 days360(start_date, end_date, european) - days between dates based on 360-day year returns the number of days between start_date and end_date based on a 360-day year:

- 0 = american
- 1 = european

days365 days365(start_date, end_date) - days between dates based on 365-day year returns the number of days between start_date and end_date based on a 365-day year.

daysact daysact(start_date, end_date) - actual number of days between dates returns the actual number of days between two dates.

daysbet daysbet(start_date, end_date, basis) - days between dates for any day-count basis returns the number of days between start_date and end_date using the given day-count basis basis:

- 0 = actual/actual
- 1 = actual/360
- 2 = actual/365
- 3 = 30/360
- 4 = 30E/360
- 5 = NL/365

monthsbet monthsbet(start_date, end_date) - months between dates returns the number of months between start_date and end_date.

termsbet termsbet(start_date, end_date, frequency) - terms between dates returns the number of terms between start_date and end_date frequency:

- 1 = annual
- 2 = semiannual
- 4 = quarterly
- 6 = bimonthly
- 12 = monthly

termfrac termfrac(start_date, end_date, frequency, basis, end_month)- fraction of term between dates returns a fraction based on the number of days between start_date and end_date using the given day-count basis frequency:

- 1 = annual
- 2 = semiannual
- 4 = quarterly
- 6 = bimonthly
- 12 = monthly

basis:

- 0 = actual/actual
- 1 = actual/360
- 2 = actual/365
- 3 = 30/360
- 4 = 30E/360
- 5 = NL/365

end_month:

- 0 = actual
- 1 = end month

yearfrac yearfrac(start_date, end_date, basis, end_month) - fraction of year between dates returns a fraction based on the number of days between start_date and end_date using the given day-count basis. basis:

- 0 = actual/actual
- 1 = actual/360
- 2 = actual/365
- 3 = 30/360
- 4 = 30E/360
- 5 = NL/365

end_month:

- 0 = actual
- 1 = end month