The multiply operator enables you multiply any number of values.
Net Income 1Q * 4

returns a number
The power operator allows you to take x to the power of y. For example 2 ** 3 equals 8.
returns a number
The Plus operator adds together multiple properties or terms together.
Net_Inc_1Q + Net_Inc_2Q > 0.0
returns a number
The Subtract operator subtracts a term or field from another.
Close - (Close as of 3.0 days ago) > 0.0
returns a number
The divide operator enables you to divide one term by another.
Net Income 1Y / Total Employee Number> 1.02

returns a number
The less than operator allows you to test whether one term is less than another term.
Close < (Close as of 3.0 days ago)

returns a true/false
The less than or equal to operator allows you to test whether one term is less than or equal to another term.
Close <= (Close as of 3.0 days ago)

returns a true/false
The greater than operator allows you to test whether one term is greater than another term.
Close > (Close as of 3.0 days ago)

returns a true/false
The greater than or equal to operator allows you to test whether one term is greater than or equal to another term.
Close >= (Close as of 3.0 days ago)

returns a true/false
The absolute value operator returns the absolute value of its argument.
abs (change of Open over 1.0 days)

returns a number
The Absolute Ratio Operator returns the absolute ratio of the term you enter into it. Since it is giving a ratio the value will always be over 1. For instance, if a stock lost 5% in a day than the Absolute Ratio of the Close/(Close as of 1 day ago) would be 1.05.
abs ratio (Close / Open) > 1.02

returns a number
The always since operator tests if a condition is always true since a date in the past. For instance one could check if a company's sales growth was always positive since 2004.
always (EPS_1Q > 0.0) since Thu Jan 01 2004

returns a true/false
The always within operator tests if a condition is always true within X trading days. For instance, one could check if a company's sales growth was always positive within 251 trading days.
always (Close > Open) within 3.0 days

returns a true/false
The and operator requires all conditions to be true. You can also click the green + symbol to add another clause.
Market Cap > 10,000 and P/E > 10

returns a true/false
The as of operator allows you retrieve a value as of X trading days ago. So Net Income as of 251 trading days ago(1 year) would give you the previous year's net income.
Close as of 8.0 days ago < Close
The at Operator returns the term's value on a desired date in the past.
Close > (Close at Jan 01 2011)
The average operator returns the average of its arguments.
To add another value simply press Control + Shift + A.
average of Sales_Gwth_5Q_to_1Q, Sales_Gwth_6Q_to_2Q, Sales_Gwth_7Q_to_3Q, Sales_Gwth_8Q_to_4Q

returns a number
The average across operator returns the average of a value across any set of stocks such as industry, sector, or the entire market.
After across specify which set of stocks to have the average calculated on.
After where define constraints that a stock must pass in order to be included in the average.
(average of Market Cap across Industry where (Market_Cap > 10b))

returns a number
The average since operator takes the average of a value pertaining to a stock since a date in the past such as yield. (Average yield since 01/01/2010)
Close > (average Close since Tue Jan 01 2008)

returns a number
The average within operator returns the average of a value within X number of trading days such as the average closing price within 10 trading days.
average Close within 4.0 days > (average Close within 9.0 days)

returns a number
The average yearly operator takes the average of a given property over the past X number of years. For instance, average-yearly of market cap over 2 years will net the average value for market cap over the past 2 years.
returns a number
The Backtest Operator will return a multiple that represents the backtest return since 2003 of whatever term you put in the operator. So Backtest of (Market Cap > 100,000) = 2 means that since 2003, the starting backtest value had doubled which represents a 100% back test return.
backtest of classify as Technology > (backtest of classify as Technology as of 5.0 days ago)
returns a number
The change over operator returns the % change of a value within X trading days
change of Close over 10.0 days > (change of SPY:Close over 10.0 days)

returns a number
The classify as operator allows you to indicate the industry, sector, exchange, etc. of the stock.
To add another field within the operator press control + Shift + A. Multiple fields act as or terms. In the example below classify as would return true if the stock was either classified as Technology or Airlines.
classify as Technology, Airlines

returns a true/false
The correlation-since operator gives the correlation of two properties since a given date.
Correlation ranges between -1 and 1, which indicates how closely a change of one property is related to a change in another.
1 is the strongest possible positive correlation.
-1 is the strongest possible negative correlation.
0 implies no relationship at all.
correlation of Market Cap with P/E since Jan 1, 2018 > .8

So stocks that match the example above all have strongly correlated Market Cap and PE since 2018. In other words, when their Market Cap went up or down, so did their PE.
returns a number
The correlation-within operator gives the correlation of two properties within X trading days.
Correlation ranges between -1 and 1, which indicates how closely a change of one property is related to a change in another.
1 is the strongest possible positive correlation
-1 is the strongest possible negative correlation.
0 implies no relationship at all.

correlation of Market Cap with P/E within 5 days

So stocks that match the example above all have strongly correlated Market Cap and PE within the last 5 trading days. In other words, when their Market Cap went up or down, so did their PE.
returns a number
The count operator counts the number of conditions that are true.

count of ( Net Income T12M > 0), ( Piotroski F Score T12M > 5), ( P/E 10)

For example:
If only Net Income T12M > 0 is true, count returns 1.
If only ( Piotroski F Score T12M > 5) and ( P/E < 10) are true, then count returns 2
If all 3 conditions are true, count returns 3.

returns a number
The count across operator returns the number of times the condition was true across any set of stocks, such as industry, sector, or the entire market.
After across, you will specify the set you are counting across. Typically Sector, Industry, or true.
After where, you will define constraints that a stock must pass in order to be included. Typically true.
For example, you could return the number of stocks that went up over one day in each industry
count of (Close > (Close as of 1 day ago)) across Industry where true)

returns a number
The count since operator returns the number of times the condition has been true since a date in the past.
For instance, the operator could tell you how many times a stock has increased over 4% in a day since the start of 2018.
count (Raw Close > ((Raw Close as of 1 day ago) × 1.04)) since Jan 1, 2018

returns a number
The Count Within operator returns the number of days that pass the conditions you entered within the specified number of days.
For instance, the operator could tell you how many times a stock's Close was higher than its Open within the last 100 trading days.
count ( Close > Open) within 100 days

returns a number
The covariance since operator takes the covariance of two properties since a given date. Covariance of x and y is a value with units of x*y, which measures the degree to which y changes when x changes.
A positive covariance indicates positive change of x with a positive change of y, and a negative covariance indicates a negative change of x with a positive change of y.
Unlike correlation, one covariance value cannot be compared to another due to the different units of each covariance value. As a result, covariance values cannot be used to show relative strength of covariance.

returns a number
The covariance-within operator takes the covariance of 2 variables within X number of days.
Covariance of x and y is a value with units of x*y, which measures the degree to which y changes when x changes. A positive covariance indicates positive change of x with a positive change of y, and a negative covariance indicates a negative change of x with a positive change of y.
Unlike correlation, one covariance value cannot be compared to another due to the different units of each covariance value. As a result, covariance values cannot be used to show relative strength of covariance.
covariance of Market Cap with P/E within 5 days

returns a number
The decreasing over operator looks for companies where the given term is decreasing over the specified time period.
So, for example, you can use it to find companies that have decreased in the last year.
decreasing Market Cap over 252 days

returns a true/false
The else if operator represents a series of if/then statements. Each is evaluated in order. If none match, then it returns undefined.
You could, for instance, use it to create your own car ranking based on outside data on car companies.
If none match then undefined
else if ticker GM then 1
else if ticker FORD then 2
else if ticker TSLA then 3
The Exponential Moving Averages operator reduces the lag of a simple Moving Average by applying more weight to recent values.
For example, below, the ema of Close will be higher than the average of Close when the recent Closing prices were higher.
ema of Close over 12 days > average Close within 12 days

returns a number
The equals operator determines whether two conditions are equal to one another.
PE = (PE as of 5.0 days ago)

returns a true/false
The ever since operator tests if the condition you enter has ever been true since a date in the past.
For instance, has a stock ever had a day where it doubled since 2018
ever Close / (Close as of 2 days ago) > 2 since Jan 1, 2008

returns a true/false
The Ever Within operator tests if your condition has ever been true within a given number of trading days. For instance, has a stock ever gone doubled from Open to Clo se within the last trading year?
ever ((Close / Open> 1.5) within 1y

returns a true/false
The future operator allows you retrieve a value that is X trading days in the future. THIS ONLY WORKS IN THE PAST! Equities Lab CANNOT predict the future! Net Income future 251 trading days(1 year) would give you the next year's net income. If this were asked in 2010, it would give you 2011's income. Asked 6 months ago, it gives you Undefined.
The growth-yearly operator measures how much a property has increased from one year to the next, over X number of years.
For example, you can use it to test if a stock's Market Cap has grown over 2 years.
growth of Market Cap over 2 years > 0

returns a number
The has-value operator returns true if and only if the stock has a defined value for all of its terms.
For example, you might use it to include stocks that have an Amortization and Capital Lease Obligations.
has Amortization 1Q, Capital Lease Obligations 1Q

returns a true/false
The if operator checks whether its condition is met, returns the first value if True and the else value if false.
The example below will evaluate to Close on Thursday, Friday, and Saturday. Otherwise, it would evaluate to Open.
if (DayOfWeek>3) then Close else Open

Note, if only takes in and returns numbers. Use else-if if you want to return true/false values as well.
The increasing over operator when applied to a property returns those companies where that property has been increasing over so many days.
increasing Market Cap over 1y

returns a true/false
The logarithm operator takes the natural logarithm of a number. Like all logarithms, it will return an undefined value if the input is less than or equal to zero.
logarithm Market Cap > 25

returns a number
The market rank operator ranks stocks according to the percentile value of the given property. For instance, the example below shows all stocks in the 99th percentile of market cap.
market rank of Market Cap > 99
returns a number
The max operator returns the maximum of a set of terms you enter into it. To add another box you simply press control + Shift + A, or input a comma into the previous box.
returns a number
The max across Operator returns the maximum of X across a set of stocks such as the entire market or an industry.
max of Rel_Strength_MR_T1M across Industry where (Market_Cap > 1000.0)

returns a number
The max since operator takes the maximum of the value since a date in the past, such as the maximum closing price since 01/01/2014
Close / (max Close since Tue Jan 01 EST 2008)

returns a number
The max within operator takes the maximum of the value within X trading days such as the maximum closing price within 180 trading days.
max Close within 180.0 days

returns a number
The median across operator returns the median value across a range of stocks.
median of Market Cap across Industry where (Market Cap > 1m)

returns a number
The min operator returns the minimum of a set of terms you enter into it.
To add another box you simply press control + Shift + A, or input a comma into the previous box.

returns a number
The min across operator takes the minimum value across any set of stocks including industry or sector.
min of Market Cap across Industry where (Market Cap > 1m)

returns a number
The min since operator takes the minimum of value since a date in the past such as the minimum closing price since 01/01/2014
min Close since Tue Jan 01 EST 2014

returns a number
The min within operator takes the minimum of the value within X trading days. For example, the minimum closing price within 30 days.
min Close within 30 days

returns a number

The Monte Carlo Range operator enables you enter a range of inputs for a Monte Carlo Simulation.

For Stock Screeners, a random Monte Carlo run will be returned.

For Backtests:

monte_carlo_runs=number of run to override the default.

monte_carlo_percentiles = x + y + z overrides the default.

example: monte_carlo_percentiles = 30 + 40 + 70 return the 30th,40th, and 70th percentile returns.


returns a number
The Monte Carlo Range operator enables you enter a range of inputs for a Monte Carlo Simulation. For Stock Screeners, a random Monte Carlo run will be returned. For Backtests: monte_carlo_runs=number of run to override the default. monte_carlo_percentiles = x + y + z overrides the default.
example: monte_carlo_percentiles = 30 + 40 + 70 return the 30th,40th, and 70th percentile returns.
The not operator enables you to require that a condition is not true.
not classify Transportation

returns a true/false
The not equals operator is used to determine whether two conditions equal or not equal each other.
PE != PE as of 5.0 days ago

returns a true/false
The odds operator returns the percentage odds between 0% and 100% to which the values that you enter into the operator are true. If 2 out of the 5 values are true then the odds operator would return 40%.
odds of (Piotroski F Score T12M > 6) ((change of Net Income 1Q over 1y days) > 20) ((change of EPS 1Q over 1y days) > 0) (Dividend Yield > 0.05)

returns a number
The odds across operator returns the percentage odds that a stock passes a condition that you enter into the operator. For example, odds that a stock in the technology sector has greater sales than it did 1Q ago.
odds of ((average Close within 10.0 days) > (average Close within 21.0 days)) across ((Market_Cap > 1000.0) where ((Market_Cap > 1000.0)

returns a number
The odds since operator returns the odds (from 0 to 100) that the stock passes the condition that you enter into the operator since a date in the past.
odds (Open > Close) since Fri Jan 01 2010

returns a number
The odds within operator returns the odds (from 0 to 100) that the stock passes the condition that you enter into the operator within X days.
odds (Close > (Close as of 4.0 days ago)) within 28.0 days

returns a number
The or operator enables you to require that a stock passes at least one of X conditions you specify.

Close > Open or P/E < 10

returns a true/false
The percentile across operator gives the value at the Nth percentile across any set of stocks including industry or the entire market.
Net Income at 50.0 percentile across Industry where ((Market_Cap > 10b)

returns a number
The percentile since operator gives you the median of the percentile values of a property since a date in the past.
If you put 0, it would give you the minimum, and it would give you the maximum if you put 100. It is useful to measure how values are changing over time or to measure where a property value stands in comparison to other property values in the past.

Trading Model Example

Close at the 90 percentile since 01/01/2010 < Close

Stock Screener Example

Close at the 50 percentile Since 01/01/2010 > Close at the 50 Percentile Since 01/01/2008
returns a number
The percentile within operator gives the value of Xth percentile of whichever property you desire within X number of trading days.

Example

High at the 50 percentile within 100 days

returns a number
The position across operator returns an integer from 1 to infinity that represents what position the stock is in based on your value across a set of stocks such as industry or sector or mid caps.
For instance, If you want the top 10 market cap companies in each Industry:
position of Market_Cap across Industry where ((Close > 0.0) and (Market_Cap > 0.0)) < 10

returns a number
The predict operator predicts the field named goal_something using the attributes specified. It filters the input set based on the galaxy_something variable, and uses the variable train_something to determine the training set.
returns a number
The rank operator returns the rank (0-100) of the property or term pertaining to a stock compared to other property or term pertaining to a stock. For instance, you could find stocks whose current closing price ranks the highest out of its 12, 24, and 50 day moving average.
rank of Close in (average Close within 5.0 days) (average Close within 12.0 days) =100.0

returns a number
The rank across operator returns the rank (0-100%) of the property or term across any set of stocks such as its industry or sector or mid caps. Take the following example:
rank of PE across Industry where ((MarketCap > 500m))
This will give you the stock's rank within its own industry, including only stocks with a Market Cap greater than 500m. So if a stock has a P/E in the 33rd percentile it would have a rank of 33.
Try modifying this Stock Screener to give you the top 25% rather than the bottom 25%

returns a number
Is the rank of a term in the bottom n%?
For example, the following example would be false for a stock with a P/E of 100 and true for stock with P/E of 1.
 rank P/E is in bottom 1% 
Keywords: rank-bottom quartile

returns a true/false
The rank since operator sorts out all values since XX/YY/ZZZZ from least to greatest and puts them in a ranking from 0 to 100. It then allows you to specify where the current value ranks in that order. For instance, you could specify that the stock's closing price currently ranks in the highest decile since 01/01/2014.
rank Close since Fri Jan 01 2010 > 85.0

returns a number
Ranks stocks from least to greatest according to a given property, then returns all stocks that score in the top X% of that property.
returns a true/false
The Rank Within operator sorts out all values within N days from least to greatest and puts them in a ranking from 0 to 100. It then allows you to specify where the current value ranks in that order. For instance, you could specify that the stock's closing price currently ranks in the highest decile compared to its closing prices within 251 trading days.

returns a number
The round operator enables you to round terms.
(Market_Cap round to nearest multiple of 100000.0)

returns a number
The round power operator will round any property or term you desire to the nearest power of X. So if you say round Market Cap to the nearest power of 5 it will round the market cap to the value nearest a power of five, such as 5, 25, 125, 625, 3125, 15,625, 78,125, Etc..
(Market_Cap round to nearest power of 2.0)

returns a number
The skewness across operator returns the skewness of a value across any set of stocks such as industry, sector, or the entire market.
Skewness can be defined as a measure of how positively or negatively-biased a given dataset is from a normal distribution.
skewness of Relative Strength across Industry where ( Market Cap > 100m) > 0.5
  1. After across you will specify which set of stocks to have the skewness calculated on.
  2. After where you will define constraints that a stock must pass in order to be included in the skewness.

returns a number
The standard deviation operator returns the standard deviation its terms.
Press Control + Shift + A to add another box to add another property or value.
standard deviation of Close, Open, High, & Low > 0.1

returns a number
The standard deviation across operator returns the standard deviation of a value across any set of stocks such as industry, sector, or the entire market.
  1. After across in the operator you will specify which set of stocks to have the standard deviation calculated on
  2. After where in the operator you will define constraints that a stock must pass in order to be included in the standard deviation.

returns a number
The standard deviation since operator takes the standard deviation of a value pertaining to a stock since a date in the past, such as yield.
stddev Relative Strength since Jan 1, 2018

returns a number
The standard deviation within operator takes the standard deviation of a value pertaining to a stock within a certain number of trading days, such as yield.
stddev Relative Strength within 30 days

returns a number
The sum since operator takes the sum of its term since a specified date, meaning it adds the property for each day from the specified date up until the current date.
sum of Net Income since Sun Jan 01 2012

returns a number
The sum within operator takes the sum of a property or term pertaining to a stock within X trading days, meaning it adds its term for each day within X trading days up until today. If the stock's closing price the past 3 days were 5, 6, and 7 then the sum of the closing price within 3 days = 18.
sum of (Close - Open) within 5.0 days > 0.0

returns a number
The Then Since operator enables you to test whether a condition was true after another condition was true until another condition is true since a date in the past.
Close > (Close as of 2.0 days ago) then (Close > (Close as of 2.0 days ago)) until (Close < (Close as of 2.0 days ago)) since Jan 01 2008
returns a true/false
The Then Within operator enables you to test whether a condition was true after another condition was true until another condition is true within X Trading Days.
Close / (Close as of 3.0 days ago) 0.99 then ((Close / (Close as of 3.0 days ago)) > 1.02) until ((Close / (Close as of 3.0 days ago)) < 1.0) within 10.0 days
returns a true/false
The ticker is operator allows you to specify a ticker for use in a stock screener or trading model. For instance, in a stock screener you could create a condition that says " Ticker Is AAPL"
ticker GE

returns a true/false
The total across operator calculates and returns the sum a property or term across an entire set of stocks such as industry or market or etc.
total of ( change of Close over 1.0 days ) across Sector where (Market_Cap > 1m)
  1. After across in the operator you will specify which set of stocks are include.
  2. After where in the operator you will define constraints that a stock must pass in order to be included.

returns a number
The value-else operator returns the first non-null value in the given list.
value Net Tangible Assets 1Q, Net Tangible Assets 1Y > 0
  1. So if the security has a value for Net Tangible Assets 1Q, that value is returned
  2. Otherwise, the value for Net Tangible Assets 1Y is returned

This operator is particularly useful for properties, such as Net Tangibl Assets, where some companies report values each quarter, but others only report annually. Take a look at the stocks returned to see how it works in practice.

returns a number

returns a number
The variance operator returns the population variance values you enter into it. Variance measures the spread of values in the dataset; a high variance indicates a great distance between values.
Press Control + Shift + A to add an additional term, or input a comma into the entry box.

returns a number
The variance across operator returns the variance of a value across any set of stocks such as industry, sector, or the entire market. Variance measures the spread of values in the dataset; a high variance indicates a great distance between values.
  1. After across you will specify which set of stocks to have the variance calculated on
  2. After where in the operator you will define constraints that a stock must pass in order to be included in the variance.

returns a number
Returns the population variance for a given property since a given date. Variance measures the spread of values in the dataset; a high variance indicates a great distance between values.

returns a number
Returns the population variance of the given property within n trading days. Variance measures the spread of values in the dataset; a high variance indicates a great distance between values.
returns a number
Missing Example of weighted-average
The weighted average across operator returns an average of a specified value across any set of stocks stock as industry, large-caps, etc. weighted by a specified value.
weighted average of Relative Strength across Industry weighted by Market Cap where ( P/E > 5)

returns a number
Missing Example of weighted-count
Missing Example of weighted-sum
The When Since Operator returns the value of a property or formula while another condition is true, since a certain date.
change of Close over 10.0 days when (Net_Income_1Q > 0.0) since Tue Jan 01 2013

returns a number
The When Within Operator returns the value of a property or formula while another condition is true, within X number of days.

returns a number
zscore across returns the zscore of a value across any set of stocks such as industry, sector, or the entire market. The z-score is the number of standard deviations above or below the mean the given value is. After across in the operator you will specify which set of stocks to have the zscore calculated on, and after where in the operator you will define constraints that a stock must pass in order to be included in the zscore.
returns a number
zscore since returns the zscore of a value since a specific date. The z-score is the number of standard deviations above or below the mean the given value is. After since in the operator you will specify the date.
returns a number
The zscore within the last n days. The zscore is the number of standard deviations above or below the mean the given value is, using the values within the given span.
returns a number