Robert's Online QuoteSheet!

Cell syntax

• Numbers must begin with a digit.
• Text cells begin with anything except "=".
• Function cells begin with "=".
• Cell names begin with a lowercase letter, a1 etc.
• Function and ticker names begin with a capital letter, Abs etc.

Stock functions

• Quote(x) returns the latest closing quote of x.

Mathematical functions

• Abs(x) returns the absolute value of x.
• Acos(x) returns the arccosine of x.
• Asin(x) returns the arcsine of x.
• Atan(x) returns the arctangent of x.
• Ceil(x) returns the smallest integer greater than or equal to x.
• Cos(x) returns the cosine of x.
• Exp(x) returns the exponential of x.
• Floor(x) returns the largest integer less than of equal to x.
• Log(x) returns the natural logarithm of x.
• Max(x, y) returns the larger of x or y.
• Min(x, y) returns the smaller or x or y.
• Pow(x, y) returns x raised to the power y.
• Random() returns a random number.
• Round(x) rounds x to the nearest integer.
• Sin(x) returns the sine of x.
• Sqrt(x) returns the square root of x.
• Tan(x) returns the tangent of x.

Comparision functions

• Lt(x, y) returns 1 if x < y, else 0.
• Le(x, y) returns 1 if x <= y, else 0.
• Gt(x, y) returns 1 if x > y, else 0.
• Ge(x, y) returns 1 if x >= y, else 0.
• Eq(x, y) returns 1 if x = y, else 0.
• Ne(x, y) returns 1 if x != y, else 0.

Boolean functions

• And(x, y) returns 1 if x and y are nonzero, else 0.
• Or(x, y) returns 1 if x or y is nonzero, else 0.
• Not(x) returns 1 if x is zero, else 0.

Conditional functions

• If(x, y) returns y if x is non zero, else 0.
• If(x, y, z) returns y if x is non zero, else z.