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