#CAPX | Actual Item (actual_item) | Capital Expenditure | |
#EBIT | Actual Item (actual_item) | EBIT | |
#EBITDA | Actual Item (actual_item) | EBITDA | |
#EPS | Actual Item (actual_item) | Earnings Per Share | |
#EPS_GAAP | Actual Item (actual_item) | Reported Earnings Per Share | |
#FCF | Actual Item (actual_item) | Free Cash Flow | |
#FFO | Actual Item (actual_item) | Funds From Operations | |
#NET | Actual Item (actual_item) | Net Profit | |
#PTI | Actual Item (actual_item) | Pre-Tax Profit | |
#SALES | Actual Item (actual_item) | Sales | |
#SHS_REPURCH | Actual Item (actual_item) | Share Repurchase | |
#SOE | Actual Item (actual_item) | Stock Option Expense | |
#Avg | Aggregate Method Parameter | Average the values (default, recommended) | |
#CapAvg | Aggregate Method Parameter | Cap weighted average the values | |
#Exclude | Aggregate Outlier Handler Parameter | Excludes outliers from the aggregation (default) | |
#Winsor | Aggregate Outlier Handler Parameter | The outliers are set to the highest/lowest value that are not outliers | |
#CAPXNTM | Consensus Estimate (cons_item) | CapEx Next Twelve Months | |
#CAPXQ | Consensus Estimate (cons_item) | CapEx Quarter | |
#CAPXY | Consensus Estimate (cons_item) | CapEx Annual | |
#EBITDANTM | Consensus Estimate (cons_item) | EBITDA Next Twelve Months | |
#EBITDAQ | Consensus Estimate (cons_item) | EBITDA Quarter | |
#EBITDAY | Consensus Estimate (cons_item) | EBITDA Annual | |
#EPSNTM | Consensus Estimate (cons_item) | EPS Next Twelve Months | |
#EPSQ | Consensus Estimate (cons_item) | EPS Quarter | |
#EPSY | Consensus Estimate (cons_item) | EPS Annual | |
#FCFNTM | Consensus Estimate (cons_item) | FCF Next Twelve Months | |
#FCFQ | Consensus Estimate (cons_item) | FCF Quarter | |
#FCFY | Consensus Estimate (cons_item) | FCF Annual | |
#LTG | Consensus Estimate (cons_item) | Long Term Growth | |
#PT | Consensus Estimate (cons_item) | Price Target | |
#SALENTM | Consensus Estimate (cons_item) | Sales Next Twelve Months | |
#SALEQ | Consensus Estimate (cons_item) | Sales Quarter | |
#SALEY | Consensus Estimate (cons_item) | Sales Annual | |
#AvgRec | Consensus Recommendation (rec_stat) | Average of all Recommendation | |
#BuyCnt | Consensus Recommendation (rec_stat) | Number of Buy Recommendations | |
#HoldCnt | Consensus Recommendation (rec_stat) | Number of Hold Recommendations | |
#OverCnt | Consensus Recommendation (rec_stat) | Number of Overweight Recommendations | |
#RecCnt | Consensus Recommendation (rec_stat) | Number of Recommendations | |
#SellCnt | Consensus Recommendation (rec_stat) | Number of Sell Recommendations | |
#UnderCnt | Consensus Recommendation (rec_stat) | Number of Underweight Recommendations | |
#ACTIONCNT | Corporate Actions (ca_retvalue) | Number of actions that matched or 0 | |
#ACTIONTYPE | Corporate Actions (ca_retvalue) | The corporate action type | |
#ANNCEDAYS | Corporate Actions (ca_retvalue) | Number of days since the announce date or NA | |
#CLOSEDAYS | Corporate Actions (ca_retvalue) | Number of days since the close/expiry date or NA | |
#TRUEFALSE | Corporate Actions (ca_retvalue) | TRUE if a match is found, FALSE otherwise | |
#APPROVAL | Corporate Actions (ca_status) | Approval | |
#COMPLETION | Corporate Actions (ca_status) | Completion | |
#MEETING | Corporate Actions (ca_status) | Meeting | |
#OTHER | Corporate Actions (ca_status) | Other ICE Data status | |
#REJECTION | Corporate Actions (ca_status) | Rejection | |
#STATUSANY | Corporate Actions (ca_status) | Any status | |
#STATUSFAIL | Corporate Actions (ca_status) | Either #TERMINATION or #REJECTION | |
#STATUSNA | Corporate Actions (ca_status) | Status not specified | |
#STATUSOK | Corporate Actions (ca_status) | Either #COMPLETION or #APPROVAL | |
#TERMINATION | Corporate Actions (ca_status) | Termination | |
#BUYOFF | Corporate Actions (ca_type) | Buy Offer | |
#LIQUIDATION | Corporate Actions (ca_type) | Liquidation | |
#MANDA | Corporate Actions (ca_type) | Any of the individual actions except #SPLIT | |
#MANDAEXSPIN | Corporate Actions (ca_type) | Any of the individual actions except #SPLIT & #SPINOFF | |
#MERGER | Corporate Actions (ca_type) | Merger | |
#MERGEREL | Corporate Actions (ca_type) | Merger Elect | |
#NEWOFFER | Corporate Actions (ca_type) | New Offer | |
#SPINOFF | Corporate Actions (ca_type) | Spinoff | |
#SPLIT | Corporate Actions (ca_type) | Split | |
#AnnDate | Dividend Date | Announce date | |
#ExDate | Dividend Date | Ex date | |
#PayDate | Dividend Date | Pay date | |
#AllDiv | Dividend Type | Any kind of dividend | |
#Regular | Dividend Type | Regular dividend (used to calculate Yield) | |
#Special | Dividend Type | Special dividend (not used to calculate Yield) | |
#ExclNA | Formula Functions Include NA Parameter | Exclude NA values | |
#InclNA | Formula Functions Include NA Parameter | Include NA values | |
#NANeutral | Formula Functions Include NA Parameter | NA Neutral | |
#All | Formula Functions Scope Parameter | Operate within selected universe | |
#Industry | Formula Functions Scope Parameter | Operate within Industries in selected universe | |
#Sector | Formula Functions Scope Parameter | Operate within Sectors in selected universe | |
#SubIndustry | Formula Functions Scope Parameter | Operate within Sub-Industries in selected universe | |
#SubSector | Formula Functions Scope Parameter | Operate within Sub-Sectors in selected universe | |
#SP500 | Formula Functions Scope Parameter | Operate within the SP500 stocks | |
#Previous | Formula Functions Scope Parameter | Operate on the results from previous rule | |
#GroupVar | Formula Functions Scope Parameter | Operates on groups based on value of variable @Group | |
#Family | Formula Functions Scope Parameter | Operate within each ETF Family | |
#AssetClass | Formula Functions Scope Parameter | Operate within each ETF Class | |
#Region | Formula Functions Scope Parameter | Operate within each ETF Region | |
#Country | Formula Functions Scope Parameter | Operate within each ETF Country | |
#Method | Formula Functions Scope Parameter | Operate within each ETF Method | |
#Style | Formula Functions Scope Parameter | Operate within each ETF Style | |
#Size | Formula Functions Scope Parameter | Operate within each ETF Size | |
#ETFSector | Formula Functions Scope Parameter | Operate within each ETF Sector | |
#ASC | Formula Functions Sort Parameter | Sort ascending | |
#DESC | Formula Functions Sort Parameter | Sort descending | |
#Neutral | Formula Functions Sort Style Parameter | Neutral | |
#Top | Formula Functions Sort Style Parameter | Top (Positive Bias) | |
#Bench | Misc IDs | Current benchmark closing prices (daily) | |
#Equity | Misc IDs | The Portfolio/Sim total value (daily) | |
#TNX | Misc IDs | 10Y Treasury Note coupon payment on $1000 bond (updated daily). To get the yield divide by 10. Ex. $25 payment on a $1000 bond represents 2.5% yield. | |
#Month3 | Numerical Constants | Returns 62, the approximate number of bars in 3 months | |
#Month6 | Numerical Constants | Returns 125, the approximate number of bars in 6 months | |
#Year | Numerical Constants | Returns 251, the approximate number of bars in a year | |
#Year2 | Numerical Constants | Returns 501, the approximate number of bars in two years | |
#Month | Numerical Constants | Returns 21, the approximate number of bars in a month | |
#Week | Numerical Constants | Returns 5, the approximate number of bars in a week | |
#Close | Price IDs | Stock closing prices (daily) | |
#High | Price IDs | Stock high prices (daily) | |
#Low | Price IDs | Stock low prices (daily) | |
#Open | Price IDs | Stock opening prices (daily) | |
#SPRPBlend | S&P 500 IDs | SP500 Risk Premium (weekly) | |
#SPYieldBlend | S&P 500 IDs | SP500 Yield (weekly) based on the time weighted analysts estimates of CurrY and NextY | |
#SPEPSCNY | S&P 500 IDs | SP500 EPS Blend Y (weekly) based on the time weighted analysts estimates of CurrY and NextY | |
#SPEPSQ | S&P 500 IDs | SP500 EPS Blend Q (weekly) | |
#SPEPSTTM | S&P 500 IDs | SP500 EPS Trailing 12 months (weekly) | |
#Increasing | Streak | Increasing values streak | |
#NotIncreasing | Streak | Decreasing or equal values streak | |
#NotPositive | Streak | Negative or zero values streak | |
#Positive | Streak | Positive values streak | |