| WORD | NAME | DESCRIPTION | |
| #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 | |
| And | Boolean operators | Expr1 And Expr2: Evaluates to 1 when both Expr1 and Expr2 are non zero. | |
| Or | Boolean operators | Expr1 Or Expr2: Evaluates to 1 when one, or both Expressions is non zero. | |
| BIZSVCE | Business Services | 10 - Business Services | Full Description |
| BIZSVCESS | Business Services | 1010 - Business Services | Full Description |
| MKTINGPRINTING | Business Services | 101010 - Marketing and Printing Services | Full Description |
| ADVERTISING | Business Services | 10101010 - Marketing and Advertising Services | Full Description |
| PRINTING | Business Services | 10101015 - Printing Services | Full Description |
| PROSVCE | Business Services | 101015 - Other Professional Services | Full Description |
| ADMINSVCE | Business Services | 10101510 - Administrative Services | Full Description |
| CONSULTING | Business Services | 10101515 - Consulting/Business Process Outsourcing Services | Full Description |
| PROSVCEOTHER | Business Services | 10101520 - Other Professional Services | Full Description |
| BIZSUPPORT | Business Services | 101020 - Business Support Services | Full Description |
| FACILSVCE | Business Services | 10102010 - Facilities and Other Support Services | Full Description |
| SECURITYSVCE | Business Services | 10102015 - Security Services | Full Description |
| WASTEMGMT | Business Services | 101025 - Waste Management Services | Full Description |
| WASTECOLLECTION | Business Services | 10102510 - General Waste Collection | Full Description |
| HAZMAT | Business Services | 10102515 - Hazardous Materials Disposal | Full Description |
| WASTESVCE | Business Services | 10102520 - Other Waste Services | Full Description |
| WASTEWATER | Business Services | 10102525 - Wastewater Treatment Services | Full Description |
| ENVISVCE | Business Services | 10102530 - Environmental Services Since 2021-08-21, previously part of WASTESVCE, FACIL, and PRECIOUS | Full Description |
| #BOND20YR | Compustat Macro - TO BE DEPRECATED | 20-Year Treasury Yield (monthly) | Full Description |
| #BOND30YR | Compustat Macro - TO BE DEPRECATED | 30-Year Treasury Yield (monthly) | Full Description |
| #CABGDP2 | Compustat Macro - TO BE DEPRECATED | Total Current Account Balance of the United States as a percentage of GDP (*quarterly data, 3 equal monthly values) | Full Description |
| #CPI | Compustat Macro - TO BE DEPRECATED | Consumer Price Index for Urban Consumers, All Items (monthly) | Full Description |
| #EMPLOY | Compustat Macro - TO BE DEPRECATED | Total Non-Farm Employment, Thousands of People (monthly) | Full Description |
| #FEDFUNDS | Compustat Macro - TO BE DEPRECATED | Fed Funds Rate, in percentage points (monthly) | Full Description |
| #GDP | Compustat Macro - TO BE DEPRECATED | Real Gross Domestic Product, Billions of Chained 2009 Dollars (*quarterly data, 3 equal monthly values) | Full Description |
| #HOUSE | Compustat Macro - TO BE DEPRECATED | Total New Housing Starts, Privately Owned Residences, in thousands of units (monthly) | Full Description |
| #M1 | Compustat Macro - TO BE DEPRECATED | M1 Money Stock, in billions of dollars (monthly) | Full Description |
| #M2 | Compustat Macro - TO BE DEPRECATED | M2 Money Stock, in billions of dollars (monthly) | Full Description |
| #NOTE10YR | Compustat Macro - TO BE DEPRECATED | 10-Year Treasury Yield (monthly) | Full Description |
| #NOTE2YR | Compustat Macro - TO BE DEPRECATED | 2-Year Treasury Yield (monthly) | Full Description |
| #NOTE3YR | Compustat Macro - TO BE DEPRECATED | 3-Year Treasury Yield (monthly) | Full Description |
| #NOTE5YR | Compustat Macro - TO BE DEPRECATED | 5-Year Treasury Yield (monthly) | Full Description |
| #NOTE7YR | Compustat Macro - TO BE DEPRECATED | 7-Year Treasury Yield (monthly) | Full Description |
| #POPT | Compustat Macro - TO BE DEPRECATED | Total U.S. Population (*annual data, 12 equal monthly values) | Full Description |
| #PPI | Compustat Macro - TO BE DEPRECATED | Producer Price Index (PPI), Finished Goods (monthly) | Full Description |
| #PRIME | Compustat Macro - TO BE DEPRECATED | Prime Rate, in percentage points (monthly) | Full Description |
| #RTLSALES | Compustat Macro - TO BE DEPRECATED | Retail Sales, excluding Food Services, in millions of dollars (monthly) | Full Description |
| #TBILL12M | Compustat Macro - TO BE DEPRECATED | 12-Month Treasury Yield (monthly) | Full Description |
| #TBILL3M | Compustat Macro - TO BE DEPRECATED | 3-Month Treasury Yield (monthly) | Full Description |
| #TBILL6M | Compustat Macro - TO BE DEPRECATED | 6-Month Treasury Yield (monthly) | Full Description |
| #UNEMP | Compustat Macro - TO BE DEPRECATED | Unemployment Rate, in percentage points (monthly) | Full Description |
| #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 | |
| CYCLICALS | Consumer Cyclicals | 20 - Consumer Cyclicals | Full Description |
| CONSUMERGOODS | Consumer Cyclicals | 2010 - Consumer Goods | Full Description |
| APPARELPRODUCTS | Consumer Cyclicals | 201010 - Apparel and Accessory Products | Full Description |
| ACCESSORIESMFR | Consumer Cyclicals | 20101010 - Accessories Production | Full Description |
| CLOTHINGMFR | Consumer Cyclicals | 20101015 - Apparel and Footwear Production | Full Description |
| APPARELMFR | Consumer Cyclicals | 20101020 - Multi-Type Apparel and Accessories Production | Full Description |
| LEISURE | Consumer Cyclicals | 201015 - Leisure Goods Products | Full Description |
| LEISUREOTHER | Consumer Cyclicals | 20101510 - Other Leisure Goods | Full Description |
| RECREATIONALGOODS | Consumer Cyclicals | 20101515 - Recreational Goods | Full Description |
| SPORTINGGOODS | Consumer Cyclicals | 20101520 - Sporting and Athletic Goods | Full Description |
| APPLIANCESFURN | Consumer Cyclicals | 201020 - Household Appliances and Furnishings Production | Full Description |
| RETAILMISC | Consumer Cyclicals | 2015 - Miscellaneous Retail | Full Description |
| AUTORETAIL | Consumer Cyclicals | 201510 - Auto Retail | Full Description |
| AUTOSVCE | Consumer Cyclicals | 20151010 - Automotive Services | Full Description |
| AUTOSALES | Consumer Cyclicals | 20151015 - Motor Vehicle Sales | Full Description |
| AUTOPARTSSALESRENT | Consumer Cyclicals | 20151020 - Motor Vehicles and Parts Sales and Rental | Full Description |
| RETAILOTHER | Consumer Cyclicals | 201515 - Other Retail | Full Description |
| AUCTION | Consumer Cyclicals | 20151510 - Auction Houses and Authentication Services | Full Description |
| GASSTATION | Consumer Cyclicals | 20151515 - Gasoline Stations | Full Description |
| OFFICESUPPLY | Consumer Cyclicals | 20151520 - Office Supplies and Stationery Retail | Full Description |
| PETS | Consumer Cyclicals | 20151525 - Pet and Pet Supply Retail | Full Description |
| RETAILSOFTW | Consumer Cyclicals | 20151530 - Retail Industry Software | Full Description |
| EVSTATION | Consumer Cyclicals | 20151535 - Electric Vehicle Charging Stations Since 2021-08-21, previously part of GASSTATION | Full Description |
| CANNABISRETAIL | Consumer Cyclicals | 20151540 - Cannabis Dispensary/Retail | Full Description |
| HOMEBUILDMANUF | Consumer Cyclicals | 201520 - Home Builders and Manufactured Buildings Since 2020-07-19, previously HOMEBUILDMANUF.XX1 | Full Description |
| HOMEBUILD | Consumer Cyclicals | 20152015 - Home Builders Since 2020-07-19, previously HOMEBUILD.XX1 | Full Description |
| MFRBUILDING | Consumer Cyclicals | 20152020 - Manufactured Building Makers Since 2020-07-19, previously MFRBUILDING.XX1 | Full Description |
| VEHICLESS | Consumer Cyclicals | 2020 - Consumer Vehicles and Parts | Full Description |
| VEHICLE | Consumer Cyclicals | 202010 - Consumer Vehicles and Parts | Full Description |
| AUTOPARTSMFR | Consumer Cyclicals | 20201010 - Consumer Vehicle Parts Manufacturing | Full Description |
| AUTOMFR | Consumer Cyclicals | 20201015 - Consumer Vehicle Manufacturing | Full Description |
| CONSUMERRETAIL | Consumer Cyclicals | 2025 - Consumer Retail | Full Description |
| APPARELRETAIL | Consumer Cyclicals | 202510 - Apparel and Accessories Retail | Full Description |
| ACCESSORIESRETAIL | Consumer Cyclicals | 20251010 - Accessories Retail | Full Description |
| CLOTHINGACCESSORIESRETAIL | Consumer Cyclicals | 20251015 - Mixed Apparel and Accessories Retail | Full Description |
| CLOTHINGRETAIL | Consumer Cyclicals | 20251020 - Apparel Retail | Full Description |
| SHOES | Consumer Cyclicals | 20251025 - Footwear Retail | Full Description |
| ELECTRONICSENTRETAIL | Consumer Cyclicals | 202515 - Electronics and Entertainment Retail | Full Description |
| ELECTRONICSRETAIL | Consumer Cyclicals | 20251510 - Electronics Retail | Full Description |
| ENTRETAIL | Consumer Cyclicals | 20251515 - Entertainment Retail | Full Description |
| ELECTRONICSENTMIXRETAIL | Consumer Cyclicals | 20251520 - Mixed Electronics and Entertainment Retail | Full Description |
| HOMEIMPROVE | Consumer Cyclicals | 202520 - Home Improvement Retail | Full Description |
| BUILDINGMAT | Consumer Cyclicals | 20252010 - Building Materials and Garden Supply Stores | Full Description |
| STOREFURNITURE | Consumer Cyclicals | 20252015 - Furniture and Home Furnishings Stores | Full Description |
| HOMEIMPROV | Consumer Cyclicals | 20252020 - Mixed Home Improvement and Furnishings Stores | Full Description |
| NONCYCLICAL | Consumer Non-Cyclicals | 50 - Consumer Non-Cyclicals | Full Description |
| STAPLESRETAIL | Consumer Non-Cyclicals | 5010 - Food and Staples Retail | Full Description |
| FOODDRINKRETAIL | Consumer Non-Cyclicals | 501010 - Food and Beverage Retail | Full Description |
| STOREFOOD | Consumer Non-Cyclicals | 50101010 - Beverage and Specialty Foods Stores | Full Description |
| FOODDRINKRETAILGEN | Consumer Non-Cyclicals | 50101015 - General Food and Beverage Retail | Full Description |
| GROCERY | Consumer Non-Cyclicals | 50101020 - Grocery Stores | Full Description |
| RETAILDISTRIB | Consumer Non-Cyclicals | 50101025 - Retail Distributors | Full Description |
| GENMERCH | Consumer Non-Cyclicals | 501015 - General Merchandise Retail | Full Description |
| STOREDEPT | Consumer Non-Cyclicals | 50101510 - Department Stores | Full Description |
| STOREDISC | Consumer Non-Cyclicals | 50101515 - Discount Stores | Full Description |
| MERCHRETAIL | Consumer Non-Cyclicals | 50101520 - General Merchandise Retailers | Full Description |
| OFFPRICERETAIL | Consumer Non-Cyclicals | 50101525 - Off-Price Retailers | Full Description |
| WAREHOUSECLUB | Consumer Non-Cyclicals | 50101530 - Warehouse Clubs and Superstores | Full Description |
| PERSONALCARERETAIL | Consumer Non-Cyclicals | 501020 - Health and Personal Care Retail | Full Description |
| PERSONALCARERETAILOTHER | Consumer Non-Cyclicals | 50102010 - Other Health and Personal Care Retail | Full Description |
| PHARMACY | Consumer Non-Cyclicals | 50102015 - Pharmacies and Drug Retailers | Full Description |
| FOODPRODUCTION | Consumer Non-Cyclicals | 5015 - Food and Tobacco Production | Full Description |
| AGRICULTURE | Consumer Non-Cyclicals | 501510 - Agriculture | Full Description |
| ANIMAL | Consumer Non-Cyclicals | 50151010 - Animal Production | Full Description |
| CROP | Consumer Non-Cyclicals | 50151015 - Crop Production | Full Description |
| AGRICDIV | Consumer Non-Cyclicals | 50151020 - Diversified Agriculture Production | Full Description |
| AGRICSUPPORT | Consumer Non-Cyclicals | 50151025 - Agricultural Support Activity Providers | Full Description |
| FOODDRINKMFR | Consumer Non-Cyclicals | 501515 - Food and Beverage Production | Full Description |
| BEVERAGE | Consumer Non-Cyclicals | 50151510 - Beverages Production | Full Description |
| FOOD | Consumer Non-Cyclicals | 50151515 - Food Production | Full Description |
| FOODDRINKMFRGEN | Consumer Non-Cyclicals | 50151520 - General Food and Beverage Production | Full Description |
| TOBACCO | Consumer Non-Cyclicals | 501520 - Tobacco Production | Full Description |
| CIGARETTE | Consumer Non-Cyclicals | 50152010 - Cigarette Manufacturing | Full Description |
| TOBACCOMFRGEN | Consumer Non-Cyclicals | 50152015 - General Tobacco Manufacturing | Full Description |
| TOBACCOPRODUCT | Consumer Non-Cyclicals | 50152020 - Other Tobacco Product Makers | Full Description |
| ECIGARETTE | Consumer Non-Cyclicals | 50152025 - Electronic Cigarette Manufacturing Since 2018-02-02, previously part of TOBACCOMFRGEN and TOBACCOPRODUCT | Full Description |
| CANNABIS | Consumer Non-Cyclicals | 501525 - Cannabis Production Since 2022-07-30, previously part of CROP | Full Description |
| PRODHOUSESUBSECT | Consumer Non-Cyclicals | 5020 - Household Products | Full Description |
| APPLIANCESTOOLS | Consumer Non-Cyclicals | 502010 - Household Appliances and Tools | Full Description |
| APPLIANCESTOOLSDIV | Consumer Non-Cyclicals | 50201010 - Diversified Household Appliances and Tools | Full Description |
| APPLIANCESSMALL | Consumer Non-Cyclicals | 50201015 - Small Appliances and Accessories Manufacturing | Full Description |
| PRODHOUSEIND | Consumer Non-Cyclicals | 502015 - Household Products | Full Description |
| BABYMFR | Consumer Non-Cyclicals | 50201510 - Baby Accessories Manufacturing | Full Description |
| PRODHOUSEDIV | Consumer Non-Cyclicals | 50201515 - Diversified Household Products Makers | Full Description |
| HOMEOFFICEFURNMFR | Consumer Non-Cyclicals | 50201520 - Home and Office Furnishings Manufacturing | Full Description |
| PERSONALCAREPRODUCT | Consumer Non-Cyclicals | 502020 - Personal Care and Cleaning Products | Full Description |
| ABSORBENT | Consumer Non-Cyclicals | 50202010 - Absorbent Products Manufacturing | Full Description |
| COSMETICS | Consumer Non-Cyclicals | 50202015 - Cosmetics Products | Full Description |
| FRAGRANCE | Consumer Non-Cyclicals | 50202020 - Personal Care Fragrance Products | Full Description |
| PERSONALCAREGEN | Consumer Non-Cyclicals | 50202025 - General Personal Care and Cleaning Products Makers | Full Description |
| HAIRCARE | Consumer Non-Cyclicals | 50202030 - Hair Care Products | Full Description |
| CLEANING | Consumer Non-Cyclicals | 50202035 - Household Cleaning Products | Full Description |
| SANITARY | Consumer Non-Cyclicals | 50202040 - Sanitary and Personal Care Paper Products | Full Description |
| SKINCARE | Consumer Non-Cyclicals | 50202045 - Skin Care Products | Full Description |
| HOUSESVCESS | Consumer Non-Cyclicals | 5025 - Household Services | Full Description |
| HOUSESVCE | Consumer Non-Cyclicals | 502510 - Personal Professional Services | Full Description |
| EDUCATION | Consumer Non-Cyclicals | 50251010 - Educational Services | Full Description |
| PERSONALSVCE | Consumer Non-Cyclicals | 50251015 - Personal Services | Full Description |
| CONSUMERSVCE | Consumer Services | 15 - Consumer Services | Full Description |
| HOSPITALITYSS | Consumer Services | 1510 - Hospitality Services | Full Description |
| HOSPITALITY | Consumer Services | 151010 - Hospitality Services | Full Description |
| HOTEL | Consumer Services | 15101010 - Accommodation Providers | Full Description |
| ARTSENT | Consumer Services | 15101015 - Arts, Entertainment and Recreation Providers | Full Description |
| FOODDRINKSVCE | Consumer Services | 15101020 - Other Food and Beverage Services | Full Description |
| RESTAURANT | Consumer Services | 15101025 - Restaurants and Bars | Full Description |
| TRAVEL | Consumer Services | 15101030 - Travel Arrangement and Reservation Services | Full Description |
| MEDIAPUBSS | Consumer Services | 1515 - Media and Publishing Services | Full Description |
| MEDIAPUB | Consumer Services | 151510 - Media and Publishing Services | Full Description |
| BROADCAST | Consumer Services | 15151010 - Broadcast Media Services | Full Description |
| ENTERTAINMENT | Consumer Services | 15151015 - Entertainment and Programming Providers | Full Description |
| BOOKS | Consumer Services | 15151020 - Print Media and Publishing Services | Full Description |
| #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 | |
| ALB | Country IDs | Albania | |
| DZA | Country IDs | Algeria | |
| AND | Country IDs | Andorra | |
| ATG | Country IDs | Antigua And Barbuda | |
| ARG | Country IDs | Argentina | |
| ARM | Country IDs | Armenia | |
| AUS | Country IDs | Australia | |
| AUT | Country IDs | Austria | |
| BHS | Country IDs | Bahamas | |
| BHR | Country IDs | Bahrain | |
| BGD | Country IDs | Bangladesh | |
| BRB | Country IDs | Barbados | |
| BLR | Country IDs | Belarus | |
| BEL | Country IDs | Belgium | |
| BLZ | Country IDs | Belize | |
| BMU | Country IDs | Bermuda | |
| BOL | Country IDs | Bolivia | |
| BIH | Country IDs | Bosnia and Herzegovina | |
| BWA | Country IDs | Botswana | |
| BRA | Country IDs | Brazil | |
| BGR | Country IDs | Bulgaria | |
| KHM | Country IDs | Cambodia | |
| CAN | Country IDs | Canada | |
| CYM | Country IDs | Cayman Islands | |
| CHL | Country IDs | Chile | |
| CHN | Country IDs | China | |
| COL | Country IDs | Colombia | |
| CRI | Country IDs | Costa Rica | |
| CIV | Country IDs | Cote d'Ivoire | |
| HRV | Country IDs | Croatia (hrvatska) | |
| CUW | Country IDs | Curacao | |
| CYP | Country IDs | Cyprus | |
| CZE | Country IDs | Czech Republic | |
| DNK | Country IDs | Denmark | |
| DOM | Country IDs | Dominican Republic | |
| ECU | Country IDs | Ecuador | |
| EGY | Country IDs | Egypt | |
| EST | Country IDs | Estonia | |
| FRO | Country IDs | Faroe Islands | |
| FIN | Country IDs | Finland | |
| FRA | Country IDs | France | |
| DEU | Country IDs | Germany | |
| GHA | Country IDs | Ghana | |
| GIB | Country IDs | Gibraltar | |
| GRC | Country IDs | Greece | |
| GLP | Country IDs | Guadeloupe | |
| GGY | Country IDs | Guernsey | |
| VAT | Country IDs | Holy See | |
| HKG | Country IDs | Hong Kong | |
| HUN | Country IDs | Hungary | |
| ISL | Country IDs | Iceland | |
| IND | Country IDs | India | |
| IDN | Country IDs | Indonesia | |
| IRN | Country IDs | Iran | |
| IRQ | Country IDs | Iraq | |
| IRL | Country IDs | Ireland | |
| IMN | Country IDs | Isle of Man | |
| ISR | Country IDs | Israel | |
| ITA | Country IDs | Italy | |
| JAM | Country IDs | Jamaica | |
| JPN | Country IDs | Japan | |
| JEY | Country IDs | Jersey | |
| JOR | Country IDs | Jordan | |
| KAZ | Country IDs | Kazakhstan | |
| KEN | Country IDs | Kenya | |
| KWT | Country IDs | Kuwait | |
| LAO | Country IDs | Laos | |
| LVA | Country IDs | Latvia | |
| LBN | Country IDs | Lebanon | |
| LIE | Country IDs | Liechtenstein | |
| LTU | Country IDs | Lithuania | |
| LUX | Country IDs | Luxembourg | |
| MKD | Country IDs | Macedonia | |
| MWI | Country IDs | Malawi | |
| MYS | Country IDs | Malaysia | |
| MLT | Country IDs | Malta | |
| MUS | Country IDs | Mauritius | |
| MYT | Country IDs | Mayotte | |
| MEX | Country IDs | Mexico | |
| MDA | Country IDs | Moldova | |
| MCO | Country IDs | Monaco | |
| MNG | Country IDs | Mongolia | |
| MNE | Country IDs | Montenegro | |
| MSR | Country IDs | Montserrat | |
| MAR | Country IDs | Morocco | |
| NAM | Country IDs | Namibia | |
| NPL | Country IDs | Nepal | |
| NLD | Country IDs | Netherlands | |
| NZL | Country IDs | New Zealand | |
| NGA | Country IDs | Nigeria | |
| NOR | Country IDs | Norway | |
| OMN | Country IDs | Oman | |
| PAK | Country IDs | Pakistan | |
| PAN | Country IDs | Panama | |
| PNG | Country IDs | Papua New Guinea | |
| PER | Country IDs | Peru | |
| PHL | Country IDs | Philippines | |
| POL | Country IDs | Poland | |
| PRT | Country IDs | Portugal | |
| QAT | Country IDs | Qatar | |
| ROU | Country IDs | Romania | |
| RUS | Country IDs | Russia | |
| RWA | Country IDs | Rwanda | |
| VCT | Country IDs | Saint Vincent and Grenadines | |
| SMR | Country IDs | San Marino | |
| SAU | Country IDs | Saudi Arabia | |
| SRB | Country IDs | Serbia | |
| SGP | Country IDs | Singapore | |
| SVK | Country IDs | Slovakia | |
| SVN | Country IDs | Slovenia | |
| ZAF | Country IDs | South Africa | |
| KOR | Country IDs | South Korea | |
| ESP | Country IDs | Spain | |
| LKA | Country IDs | Sri Lanka | |
| SPM | Country IDs | St. Pierre and Miquelon | |
| SJM | Country IDs | Svalbard and Jan Mayen | |
| SWZ | Country IDs | Swaziland | |
| SWE | Country IDs | Sweden | |
| CHE | Country IDs | Switzerland | |
| SYR | Country IDs | Syria | |
| TWN | Country IDs | Taiwan | |
| TZA | Country IDs | Tanzania United Republic Of | |
| THA | Country IDs | Thailand | |
| TTO | Country IDs | Trinidad and Tobago | |
| TUN | Country IDs | Tunisia | |
| TUR | Country IDs | Turkey | |
| TCA | Country IDs | Turks and Caicos Islands | |
| UGA | Country IDs | Uganda | |
| UKR | Country IDs | Ukraine | |
| ARE | Country IDs | United Arab Emirates | |
| GBR | Country IDs | United Kingdom | |
| USA | Country IDs | United States | |
| URY | Country IDs | Uruguay | |
| VEN | Country IDs | Venezuela | |
| VNM | Country IDs | Viet Nam | |
| VGB | Country IDs | Virgin Islands (British) | |
| VIR | Country IDs | Virgin Islands (u.s.) | |
| ZMB | Country IDs | Zambia | |
| ZWE | Country IDs | Zimbabwe | |
| #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) | |
| ENERGY | Energy | 25 - Energy | Full Description |
| UPSTREAMENERGY | Energy | 2510 - Upstream Energy | Full Description |
| COAL | Energy | 251010 - Coal and Uranium Mining | Full Description |
| COALAMER | Energy | 25101010 - Americas Coal Mining | Full Description |
| COALASIA | Energy | 25101015 - Asia/Pacific International Coal Mining | Full Description |
| COALINTL | Energy | 25101020 - Other International Coal Mining | Full Description |
| URANIUMRADIUMVANADIUM.XX1 | Energy | 25101025 - Uranium, Radium and Vanadium Mining Discontinued 2020-07-19, replaced by RADIUMVANADIUM, URANIUM, and OREBASE | Full Description |
| RADIUMVANADIUM | Energy | 25101030 - Radium and Vanadium Mining Since 2020-07-19, previously part of URANIUMRADIUMVANADIUM.XX1 | Full Description |
| URANIUM | Energy | 25101035 - Uranium Mining Since 2020-07-19, previously part of URANIUMRADIUMVANADIUM.XX1 | Full Description |
| COALSTREAMING | Energy | 25101040 - Coal Streaming and Royalties | Full Description |
| FOSSILFUEL | Energy | 251015 - Fossil Fuel Exploration and Production | Full Description |
| FOSSILFUELAMER | Energy | 25101510 - Americas Fossil Fuel Exploration and Production | Full Description |
| FOSSILFUELINT.XX1 | Energy | 25101515 - Integrated Oil and Gas Exploration and Production Discontinued 2018-02-02, replaced by OILGASINTEG | Full Description |
| FOSSILFUELOTHER | Energy | 25101520 - Other Fossil Fuel Exploration and Production | Full Description |
| OILGASSUPPORT | Energy | 251020 - Support Activities for Oil and Gas Operations | Full Description |
| OILGASTRANSPORT | Energy | 25102010 - Oil and Gas Transportation and Infrastructure | Full Description |
| OILGASFIELD | Energy | 25102015 - Oil and Gas Field Support Activities | Full Description |
| OILGASOPER | Energy | 25102020 - Oil and Gas Operations Support Activities | Full Description |
| DOWNMIDSTREAMENERGY | Energy | 2515 - Downstream and Midstream Energy | Full Description |
| DOWNSTREAMENERGY | Energy | 251510 - Downstream Energy | Full Description |
| LPGPROPANE | Energy | 25151010 - LPG, Propane and Other Distributors | Full Description |
| REFINERIES | Energy | 25151015 - Petroleum Refineries | Full Description |
| MIDSTREAMENERGY | Energy | 251515 - Midstream Energy | Full Description |
| NATGASPIPELINE | Energy | 25151510 - Natural Gas Pipeline and Storage Services | Full Description |
| PIPELINEOTHER | Energy | 25151515 - Other Pipeline and Energy Storage Services | Full Description |
| PETROLPIPELINE | Energy | 25151520 - Petroleum Liquid Pipeline and Storage | Full Description |
| OILGASINTEGSS | Energy | 2520 - Integrated Oil and Gas Exploration and Production Since 2018-02-02, previously FOSSILFUELINT.XX1 | Full Description |
| OILGASINTEG | Energy | 252010 - Integrated Oil and Gas Exploration and Production Since 2018-02-02, previously FOSSILFUELINT.XX1 | Full Description |
| ANN | Filing Period | Annual | |
| QTR | Filing Period | Interim | |
| TTM | Filing Period | Trailing Twelve Months | |
| FINANCIAL | Finance | 30 - Finance | Full Description |
| BANKS | Finance | 3010 - Banking | Full Description |
| BANKSINTL | Finance | 301010 - International Banks | Full Description |
| BANKSAMEREXUS | Finance | 30101010 - Americas Banks | Full Description |
| BANKSASIA | Finance | 30101015 - Asia/Pacific Banks | Full Description |
| BANKSEUROPE | Finance | 30101020 - Europe, Middle East and Africa Banks | Full Description |
| BANKSMULTINAT | Finance | 30101025 - Multinational Banks | Full Description |
| BANKSMORTG | Finance | 301015 - Mortgage Banking | Full Description |
| BANKSUSA | Finance | 301020 - United States Banks | Full Description |
| BANKSCOMMERCIAL | Finance | 30102010 - United States Commercial Banks | Full Description |
| SAVINGSLOAN | Finance | 30102015 - United States Savings Institutions | Full Description |
| CREDITUNIONS | Finance | 30102020 - United States Credit Unions Since 2020-07-18 | Full Description |
| BANKSINTERNET | Finance | 30102025 - United States Internet Banks Since 2020-07-18, previously part of BANKSCOMMERCIAL | Full Description |
| INSURANCESS | Finance | 3015 - Insurance | Full Description |
| INSURANCE | Finance | 301510 - Insurance | Full Description |
| INSBROKER | Finance | 30151010 - Insurance Brokerage | Full Description |
| INSLIFEHEALTH | Finance | 30151015 - Life and Health Insurance | Full Description |
| INSPROPCAS | Finance | 30151020 - Property and Casualty Insurance | Full Description |
| INSRE | Finance | 30151025 - Reinsurance | Full Description |
| INSDIV | Finance | 30151030 - Diversified Insurance | Full Description |
| INVESTSVCESS | Finance | 3020 - Investment Services | Full Description |
| INVESTSVCE | Finance | 302010 - Investment Services | Full Description |
| ASSETMGMT | Finance | 30201010 - Asset Management and Financial Advisory Services | Full Description |
| INVESTBANK | Finance | 30201015 - Investment Banking and Corporate Finance | Full Description |
| INVESTHOLDING | Finance | 30201020 - Investment Holding Companies | Full Description |
| SECURITIES | Finance | 30201025 - Securities Sales and Trading Services | Full Description |
| INVESTDIV | Finance | 30201030 - Diversified Investment | Full Description |
| REALESTATE | Finance | 3025 - Real Estate | Full Description |
| HOMEBUILDMANUF.XX1 | Finance | 302510 - Home Builders and Manufactured Buildings Discontinued 2020-07-19, replaced by HOMEBUILDMANUF | Full Description |
| HOMEBUILD.XX1 | Finance | 30251010 - Home Builders Discontinued 2020-07-19, replaced by HOMEBUILD | Full Description |
| MFRBUILDING.XX1 | Finance | 30251015 - Manufactured Building Makers Discontinued 2020-07-19, replaced by MFRBUILDING | Full Description |
| REALESTATESVCE | Finance | 302515 - Real Estate Investment and Services | Full Description |
| REALESTATESVCEOTHER | Finance | 30251510 - Other Real Estate Investment and Services | Full Description |
| PROPERTY | Finance | 30251515 - Property Owners | Full Description |
| REIT | Finance | 302520 - Real Estate Investment Trusts (REITs) | Full Description |
| REITDIV | Finance | 30252010 - Diversified REITs | Full Description |
| REITEQUITY | Finance | 30252015 - Equity REITs | Full Description |
| REITMORTG | Finance | 30252020 - Mortgage REITs | Full Description |
| FINSVCE | Finance | 3030 - Specialty Finance and Services | Full Description |
| FINSPECIAL | Finance | 303010 - Specialty Finance | Full Description |
| FINCOMMSVCE | Finance | 30301010 - Commercial Finance Services | Full Description |
| FINCONSUMERSVCE | Finance | 30301015 - Consumer Finance Services | Full Description |
| FINSOFTW | Finance | 303015 - Finance Software and Services | Full Description |
| #ExclNA | Formula Functions Include NA Parameter | Exclude NA values | |
| #InclNA | Formula Functions Include NA Parameter | Include NA values | |
| #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 | |
| HEALTHCARE | Healthcare | 35 - Healthcare | Full Description |
| BIOPHARMA | Healthcare | 3510 - Biopharmaceuticals | Full Description |
| BIOPHARMANONSYS | Healthcare | 351010 - Non-System-Specific Biopharmaceuticals | Full Description |
| INFECTIOUS | Healthcare | 35101010 - Infectious Disease Biopharmaceuticals | Full Description |
| ONCOLOGY | Healthcare | 35101015 - Oncology Biopharmaceuticals | Full Description |
| BIOPHARMAOTHER | Healthcare | 351015 - Other Biopharmaceuticals | Full Description |
| ALLERGIES | Healthcare | 35101510 - Allergies Biopharmaceuticals | Full Description |
| PAINMGMT | Healthcare | 35101515 - Pain Management Biopharmaceuticals | Full Description |
| SURGICAL | Healthcare | 35101520 - Surgical Biopharmaceuticals | Full Description |
| TOXICOLOGY | Healthcare | 35101525 - Toxicology Biopharmaceuticals | Full Description |
| TRANSPLANTATION | Healthcare | 35101530 - Transplantation Biopharmaceuticals | Full Description |
| WEIGHTMGMT | Healthcare | 35101535 - Weight Management Biopharmaceuticals | Full Description |
| BIOPHARMADIV | Healthcare | 35101540 - Diversified Biopharmaceuticals | Full Description |
| BIOPHARMASYS | Healthcare | 351020 - System-Specific Biopharmaceuticals | Full Description |
| CARDIOVASCULAR | Healthcare | 35102010 - Cardiovascular System Biopharmaceuticals | Full Description |
| DERMATOLOGY | Healthcare | 35102015 - Dermatology Biopharmaceuticals | Full Description |
| DIGESTIVE | Healthcare | 35102020 - Digestive System Biopharmaceuticals | Full Description |
| ENDOCRINOLOGY | Healthcare | 35102025 - Endocrinology and Metabolism Biopharmaceuticals | Full Description |
| HEMATOLOGY | Healthcare | 35102030 - Hematology Biopharmaceuticals | Full Description |
| IMMUNOLOGY | Healthcare | 35102035 - Immunology Biopharmaceuticals | Full Description |
| MUSCULOSKELETAL | Healthcare | 35102040 - Musculoskeletal System Biopharmaceuticals | Full Description |
| NEUROLOGY | Healthcare | 35102045 - Neurology Biopharmaceuticals | Full Description |
| OBSTETRICS | Healthcare | 35102050 - Obstetrics and Gynecology Biopharmaceuticals | Full Description |
| OPHTHALMOLOGY | Healthcare | 35102055 - Ophthalmology Biopharmaceuticals | Full Description |
| RESPIRATORY | Healthcare | 35102060 - Respiratory System Biopharmaceuticals | Full Description |
| UROLOGY | Healthcare | 35102065 - Urology Biopharmaceuticals | Full Description |
| HCARESVCE | Healthcare | 3515 - Healthcare Services | Full Description |
| HCARESUPPORT | Healthcare | 351510 - Healthcare Support Services | Full Description |
| HPLAN | Healthcare | 35151010 - Health Plan Providers | Full Description |
| HCAREADMIN | Healthcare | 35151015 - Healthcare Administrative Support Services | Full Description |
| HCAREDISTRIB | Healthcare | 35151020 - Healthcare Distributors | Full Description |
| HCARESUPPORTOTHER | Healthcare | 35151025 - Other Healthcare Support Services | Full Description |
| PATIENTCARE | Healthcare | 351515 - Patient Care | Full Description |
| ACUTECARE | Healthcare | 35151510 - Acute Care and Institutional Patient Care | Full Description |
| AMBULANCE | Healthcare | 35151515 - Ambulatory and Outpatient Diagnostic Patient Care | Full Description |
| LTCARE | Healthcare | 35151520 - Long-Term Care Facilities | Full Description |
| MULTIDELIVCARE | Healthcare | 35151525 - Multi-Delivery-Type Patient Care | Full Description |
| AMBULANCEOTHER | Healthcare | 35151530 - Other Ambulatory and Outpatient Patient Care | Full Description |
| HCAREMISC | Healthcare | 351520 - Miscellaneous Healthcare | Full Description |
| NUTRITION | Healthcare | 35152010 - Nutritional Health Pharmaceuticals | Full Description |
| OUTSOURCEDBIOMED | Healthcare | 35152015 - Other Outsourced Biomedical Services | Full Description |
| OUTSOURCEDDRUG | Healthcare | 35152020 - Outsourced Drug Services | Full Description |
| HCARESCIPRODUCTS | Healthcare | 35152025 - Scientific Products | Full Description |
| VETERINARY | Healthcare | 35152030 - Veterinary Products and Services | Full Description |
| HCARESVCEDIV | Healthcare | 35152035 - Diversified Healthcare Services | Full Description |
| HCAREOUTSOURCE | Healthcare | 351525 - Outsourced Development and Manufacturing Services | Full Description |
| HCARECONTRACTMFR | Healthcare | 35152510 - Contract Manufacturing Organizations | Full Description |
| HCARECONTRACTRESEARCH | Healthcare | 35152515 - Contract Research Organizations | Full Description |
| HCAREDEV | Healthcare | 35152520 - Development and Manufacturing Services | Full Description |
| HCAREEQUIP | Healthcare | 3520 - Healthcare Equipment | Full Description |
| HCAREDIAGNOSTICS | Healthcare | 352010 - Diagnostics and Drug Delivery Devices | Full Description |
| DIAGNOSTIC | Healthcare | 35201010 - Clinical Diagnostics Devices | Full Description |
| DRUGDELIV | Healthcare | 35201015 - Drug Delivery Devices | Full Description |
| MEDDEVICESGEN | Healthcare | 352015 - General Medical Devices | Full Description |
| SYSTEMSPECIFIC | Healthcare | 35201510 - System-Specific General Medical Devices | Full Description |
| MEDDEVICESDIV | Healthcare | 35201515 - Diversified Medical Devices and Instruments | Full Description |
| MEDDEVICESOTHER | Healthcare | 352020 - Other Medical Devices | Full Description |
| MEDSUPPLIES | Healthcare | 35202010 - Medical Supplies | Full Description |
| MEDDEVICESSPECIAL | Healthcare | 35202015 - Specialized Medical Devices | Full Description |
| $MID | Index Tickers - Major | S&P 400 Mid | Full Description |
| $RUA | Index Tickers - Major | Russell3000 | Full Description |
| $RUI | Index Tickers - Major | Russell1000 | Full Description |
| $RUT | Index Tickers - Major | Russell2000 | Full Description |
| $SML | Index Tickers - Major | S&P 600 Small | Full Description |
| $SP500 | Index Tickers - Major | S&P 500 | Full Description |
| $SP500EQ | Index Tickers - Major | S&P 500 EQUAL WEIGHT | Full Description |
| $SPALL | Index Tickers - Major | S&P 1500 Super Composite | Full Description |
| $DJIA | Index Tickers - Specialty | Dow Jones | Full Description |
| $MIDPG | Index Tickers - Specialty | S&P 400 Pure Growth | Full Description |
| $MIDPV | Index Tickers - Specialty | S&P 400 Pure Value | Full Description |
| $NASDAQ | Index Tickers - Specialty | Nasdaq | Full Description |
| $NASDAQ100 | Index Tickers - Specialty | Nasdaq 100 | Full Description |
| $SMLPG | Index Tickers - Specialty | S&P 600 Pure Growth | Full Description |
| $SMLPV | Index Tickers - Specialty | S&P 600 Pure Value | Full Description |
| $SP500PG | Index Tickers - Specialty | S&P 500 Pure Growth | Full Description |
| $SP500PV | Index Tickers - Specialty | S&P 500 Pure Value | Full Description |
| $SPALLCND | Index Tickers - Specialty | SP1500 Consumer Discretion | Full Description |
| $SPALLCNS | Index Tickers - Specialty | SP1500 Consumer Staples | Full Description |
| $SPALLENG | Index Tickers - Specialty | SP1500 Energy | Full Description |
| $SPALLEUT | Index Tickers - Specialty | SP1500 Elec Utilities | Full Description |
| $SPALLFIN | Index Tickers - Specialty | SP1500 Financials | Full Description |
| $SPALLGLD | Index Tickers - Specialty | SP1500 Gold | Full Description |
| $SPALLHEA | Index Tickers - Specialty | SP1500 Health Care | Full Description |
| $SPALLHEQ | Index Tickers - Specialty | SP1500 Hlth Care Eq&Srvc | Full Description |
| $SPALLIND | Index Tickers - Specialty | SP1500 Industrials | Full Description |
| $SPALLINT | Index Tickers - Specialty | SP1500 Information Tech | Full Description |
| $SPALLMAT | Index Tickers - Specialty | SP1500 Materials | Full Description |
| $SPALLPBL | Index Tickers - Specialty | SP1500 Pharma Biotech Life | Full Description |
| $SPALLPG | Index Tickers - Specialty | S&P 1500 Pure Growth | Full Description |
| $SPALLPV | Index Tickers - Specialty | S&P 1500 Pure Value | Full Description |
| $SPALLTCM | Index Tickers - Specialty | SP1500 Telecom Services | Full Description |
| $SPALLUTL | Index Tickers - Specialty | SP1500 Utilities | Full Description |
| $VIX | Index Tickers - Specialty | CBOE Volatility Index | Full Description |
| INDUSTRIAL | Industrials | 40 - Industrials | Full Description |
| INDMFR | Industrials | 4010 - Industrial Manufacturing | Full Description |
| AERODEF | Industrials | 401010 - Aerospace and Defense Manufacturing | Full Description |
| AEROSPACEEQUIP | Industrials | 40101010 - Aerospace Equipment | Full Description |
| DEF | Industrials | 40101015 - Defense Manufacturing | Full Description |
| AERODEFDIV | Industrials | 40101020 - Diversified Aerospace and Defense Manufacturing | Full Description |
| ELECTREQUIP | Industrials | 401015 - Electrical Equipment and Power Systems | Full Description |
| COMMELECTRIC | Industrials | 40101510 - Commercial and Industrial Electric Products | Full Description |
| ELECTREQUIPOTHER | Industrials | 40101515 - Other Electrical Equipment/Power Systems Makers | Full Description |
| POWERGEN | Industrials | 40101520 - Power Generation and Support Products | Full Description |
| MACHINE | Industrials | 401020 - Machinery Manufacturing | Full Description |
| CONTROLEQUIP | Industrials | 40102010 - Air, Liquid and Gas Control Equipment | Full Description |
| AUTOMATIONEQUIP | Industrials | 40102015 - Factory Automation Equipment | Full Description |
| MACHINEPARTS | Industrials | 40102020 - Industrial Machine Parts and Support Equipment | Full Description |
| CONSTRUCTIONMACHINE | Industrials | 40102025 - Natural Resource and Construction Machinery Makers | Full Description |
| MACHINEOTHER | Industrials | 40102030 - Other Machinery Manufacturing | Full Description |
| TOOLS | Industrials | 40102035 - Tools and Outdoor Care Equipment | Full Description |
| TRANSPORTEQUIP | Industrials | 401025 - Transportation Equipment Manufacturing | Full Description |
| TRANSPORTEQUIPCML | Industrials | 40102510 - Commercial Transportation Equipment Manufacturing | Full Description |
| TRANSPORTEQUIPGEN | Industrials | 40102515 - General Transportation Equipment Manufacturing | Full Description |
| INDSVCE | Industrials | 4015 - Industrial Services | Full Description |
| TRAINTRUCK | Industrials | 401510 - Cargo Transportation and Infrastructure Services | Full Description |
| AIRWATER | Industrials | 40151010 - Air and Water Transportation Operators | Full Description |
| TRAINTRUCKGEN | Industrials | 40151015 - General Transportation and Related Services | Full Description |
| TRAINTRUCKOP | Industrials | 40151020 - Road and Rail Transportation Operators | Full Description |
| INTERMODAL | Industrials | 40151025 - Intermodal/Multimodal Services Since 2022-07-30, previously part of TRAINTRUCKOP | Full Description |
| DELIVERY | Industrials | 401515 - Delivery and Logistics Services | Full Description |
| EXPRESS | Industrials | 40151510 - Express Couriers | Full Description |
| DELIVERYGEN | Industrials | 40151515 - General Delivery and Logistics Providers | Full Description |
| LOGISTICS | Industrials | 40151520 - Logistics and Supply Chain Service Providers | Full Description |
| INDLDIST | Industrials | 401520 - Diversified Industrials Distribution | Full Description |
| EQUIPDISTRIB | Industrials | 40152010 - Equipment and Supplies Distributors | Full Description |
| MATDISTRIB | Industrials | 40152015 - Materials Distributors | Full Description |
| INDLDIVDISTRIB | Industrials | 40152020 - Diversified Industrial Distribution | Full Description |
| BUILDINGMATDIST | Industrials | 40152025 - Building Materials Distribution Since 2019-02-01; see BUILDINGMAT | Full Description |
| FACIL | Industrials | 401525 - Facilities and Construction Services | Full Description |
| PASSENGERTRANS | Industrials | 401530 - Passenger Transportation | Full Description |
| AIRPASSENGER | Industrials | 40153010 - Air Passenger Transportation | Full Description |
| PASSENGEROTHER | Industrials | 40153015 - Other Passenger Transportation | Full Description |
| = != ! < > >= <= | Logical operators | Logical Operators: = Equals != Not Equals ! Negate > Greater < Less >= Greater or equal <= Less or equal | |
| ##DELINQCC | Macro - Banking (FRED) | Delinquency Rate On Credit Card Loans, All Commercial Banks (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=DRCCLACBS | Full Description |
| ##DELINQMORT | Macro - Banking (FRED) | Delinquency Rate On Single-Family Residential Mortgages (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=DRSFRMACBS | Full Description |
| ##CAPUTIL | Macro - Business Activity (FRED) | Capacity Utilization: Total Industry (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=TCU | Full Description |
| ##CONSTR | Macro - Business Activity (FRED) | Total Construction Spending (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=TTLCONS | Full Description |
| ##HDEBTSERV | Macro - Business Activity (FRED) | Household Debt Service Payments as a Percent of Disposable Personal Income (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=TDSP | Full Description |
| ##HSTARTS | Macro - Business Activity (FRED) | Housing Starts (Total) (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=HOUST | Full Description |
| ##HVACANCY | Macro - Business Activity (FRED) | Home Vacancy Rate for the United States (annual) Corresponding FRED id=USHVAC | Full Description |
| ##INDPRO | Macro - Business Activity (FRED) | Industrial Production Index (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=INDPRO | Full Description |
| ##INV2SHIP | Macro - Business Activity (FRED) | Ratio of Total Inventories to Shipments for All Manufacturing Industries (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=AMTMUS | Full Description |
| ##INV2SLS | Macro - Business Activity (FRED) | Total Business: Inventories to Sales Ratio (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=ISRATIO | Full Description |
| ##INV2SLSAUTO | Macro - Business Activity (FRED) | Auto Inventory/Sales Ratio (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=AISRSA | Full Description |
| ##INVTOT | Macro - Business Activity (FRED) | Total Business Inventories (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=BUSINV | Full Description |
| ##ORDERSCAP | Macro - Business Activity (FRED) | Manufacturers' New Orders: Nondefense Capital Goods ex.Aircraft (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=NEWORDER | Full Description |
| ##ORDERSDUR | Macro - Business Activity (FRED) | Manufacturers' New Orders: Durable Goods (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=DGORDER | Full Description |
| ##ORDERSUNFILL | Macro - Business Activity (FRED) | Value of Unfilled Orders for All Manufacturing ex. Transportation (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=AMXTUO | Full Description |
| ##PRODAUTO | Macro - Business Activity (FRED) | Domestic Auto Production (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=DAUPSA | Full Description |
| ##RVACANCY | Macro - Business Activity (FRED) | Rental Vacancy Rate for the United States (annual) Corresponding FRED id=USRVAC | Full Description |
| ##SALESALLVEH | Macro - Business Activity (FRED) | Total Vehicle Sales (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=TOTALSA | Full Description |
| ##SALESAUTO | Macro - Business Activity (FRED) | Light Weight Vehicle Sales: Autos & Light Trucks (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=ALTSALES | Full Description |
| ##SALESRET | Macro - Business Activity (FRED) | Retail Sales: Total (Excluding Food Services) (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=RSXFS | Full Description |
| ##SALESRETFD | Macro - Business Activity (FRED) | Real Retail and Food Services Sales (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=RRSFS | Full Description |
| ##WAGES | Macro - Business Activity (FRED) | Wages in manufacturing (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=AHETPI | Full Description |
| ##DOMINV | Macro - Economic Activity (FRED) | Gross Private Domestic Investment (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=GPDI | Full Description |
| ##GNP | Macro - Economic Activity (FRED) | Gross National Product (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=GNP | Full Description |
| ##INFLEXP | Macro - Economic Activity (FRED) | University of Michigan Inflation Expectation© (monthly) Corresponding FRED id=MICH | Full Description |
| ##PCE | Macro - Economic Activity (FRED) | Personal Consumption Expenditures (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=PCE | Full Description |
| ##RDISPINC | Macro - Economic Activity (FRED) | Real Disposable Personal Income (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=DSPIC96 | Full Description |
| ##RECPROB | Macro - Economic Activity (FRED) | Smoothed U.S. Recession Probabilities (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=RECPROUSM156N | Full Description |
| ##RGDP | Macro - Economic Activity (FRED) | Real Gross Domestic Product (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=GDPC1 | Full Description |
| ##RINCPERCAP | Macro - Economic Activity (FRED) | Real Disposable Personal Income: Per capita (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=A229RX0 | Full Description |
| ##RMINCOME | Macro - Economic Activity (FRED) | Real Median Income (annual) Can be used in conjunction with PITSeries function Corresponding FRED id=MEHOINUSA672N | Full Description |
| ##RPCE | Macro - Economic Activity (FRED) | Real Personal Consumption Expenditures (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=PCEC96 | Full Description |
| ##SAVING | Macro - Economic Activity (FRED) | Personal Saving Rate (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=PSAVERT | Full Description |
| ##SURPLUS | Macro - Economic Activity (FRED) | Federal Surplus or Deficit [-] (annual) Can be used in conjunction with PITSeries function Corresponding FRED id=FYFSD | Full Description |
| ##UMCSENT | Macro - Economic Activity (FRED) | University of Michigan: Consumer Sentiment© (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=UMCSENT | Full Description |
| ##USSLIND | Macro - Economic Activity (FRED) | Leading Index for the United States (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=USALOLITONOSTSAM | Full Description |
| ##CORPAAA | Macro - Interest (FRED) | BofA Merrill Lynch US Corporate AAA Effective Yield© (daily) Corresponding FRED id=BAMLC0A1CAAAEY | Full Description |
| ##CORPB | Macro - Interest (FRED) | BofA Merrill Lynch US High Yield B Effective Yield© (daily) Corresponding FRED id=BAMLH0A2HYBEY | Full Description |
| ##CORPBB | Macro - Interest (FRED) | BofA Merrill Lynch US High Yield BB Effective Yield© (daily) Corresponding FRED id=BAMLH0A1HYBBEY | Full Description |
| ##CORPBBB | Macro - Interest (FRED) | BofA Merrill Lynch US Corporate BBB Effective Yield© (daily) Corresponding FRED id=BAMLC0A4CBBBEY | Full Description |
| ##CORPBBBOAS | Macro - Interest (FRED) | BofA Merrill Lynch US Corporate BBB Option-Adjusted Spread (daily) Corresponding FRED id=BAMLC0A4CBBB | Full Description |
| ##CORPBBOAS | Macro - Interest (FRED) | BofA Merrill Lynch US High Yield Master II Opt-Adj Spread (daily) Corresponding FRED id=BAMLH0A0HYM2 | Full Description |
| ##CORPJNK | Macro - Interest (FRED) | BofA Merrill Lynch US High Yield CCC or Below Effective Yield© (daily) Corresponding FRED id=BAMLH0A3HYCEY | Full Description |
| ##FEDFUNDS | Macro - Interest (FRED) | Effective Federal Funds Rate (daily) Corresponding FRED id=DFF | Full Description |
| ##MORT30Y | Macro - Interest (FRED) | 30-Year Fixed Rate Mortgage Average in the United States (weekly) Corresponding FRED id=MORTGAGE30US | Full Description |
| ##PRIME | Macro - Interest (FRED) | Bank Prime Loan Rate (monthly) Corresponding FRED id=MPRIME | Full Description |
| ##TEDSPREAD | Macro - Interest (FRED) | TED Spread (daily) Corresponding FRED id=TEDRATE | Full Description |
| ##CIVLABOR | Macro - Labor Force (FRED) | Civilian Labor Force (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=CLF16OV | Full Description |
| ##CLAIMSCONTINUE | Macro - Labor Force (FRED) | Continued Claims (Insured Unemployment) (weekly) Can be used in conjunction with PITSeries function Corresponding FRED id=CCSA | Full Description |
| ##CLAIMSNEW | Macro - Labor Force (FRED) | Initial Claims (weekly) Can be used in conjunction with PITSeries function Corresponding FRED id=ICSA | Full Description |
| ##LABORPARTIC | Macro - Labor Force (FRED) | Civilian Labor Force Participation Rate (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=CIVPART | Full Description |
| ##NONFARMEMPL | Macro - Labor Force (FRED) | All Employees: Total nonfarm (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=PAYEMS | Full Description |
| ##POPUL | Macro - Labor Force (FRED) | Total Population: All Ages including Armed Forces Overseas (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=POP | Full Description |
| ##UNDURATION | Macro - Labor Force (FRED) | Median Duration of Unemployment (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=UEMPMED | Full Description |
| ##UNRATE | Macro - Labor Force (FRED) | Civilian Unemployment Rate (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=UNRATE | Full Description |
| ##UNTEEN | Macro - Labor Force (FRED) | Unemployment Rate - 16 to 19 years (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=LNS14000012 | Full Description |
| ##UNTOT | Macro - Labor Force (FRED) | Total unemployed, including under-employed (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=U6RATE | Full Description |
| ##UNWANT | Macro - Labor Force (FRED) | Not in Labor Force, Want a Job Now (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=NILFWJN | Full Description |
| ##ADJMBASE | Macro - Money (FRED) | Monetary Base; Total (weekly) Can be used in conjunction with PITSeries function Corresponding FRED id=BOGMBASEW | Full Description |
| ##M1 | Macro - Money (FRED) | M1 Money Stock (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=M1SL | Full Description |
| ##M2 | Macro - Money (FRED) | M2 Money Stock (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=M2SL | Full Description |
| ##MZM | Macro - Money (FRED) | MZM Money Stock (weekly) Can be used in conjunction with PITSeries function Corresponding FRED id=MZM | Full Description |
| ##STRESS | Macro - Money (FRED) | St. Louis Fed Financial Stress Index© (weekly) Corresponding FRED id=STLFSI4 | Full Description |
| ##USCURRACCT | Macro - Money (FRED) | Balance on Current Account (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=IEABC | Full Description |
| ##VELM1 | Macro - Money (FRED) | Velocity of M1 Money Stock (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=M1V | Full Description |
| ##VELM2 | Macro - Money (FRED) | Velocity of M2 Money Stock (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=M2V | Full Description |
| ##VELMZM | Macro - Money (FRED) | Velocity of MZM Money Stock (quarterly) Can be used in conjunction with PITSeries function Corresponding FRED id=MZMV | Full Description |
| ##CPI | Macro - Prices (FRED) | CPI All Urban Consumers: All Items (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=CPIAUCSL | Full Description |
| ##GOLD | Macro - Prices (FRED) | Gold Price in London Bullion Market, USD (daily) Corresponding FRED id=GOLDAMGBD228NLBM | Full Description |
| ##HPRICES | Macro - Prices (FRED) | S&P Case-Shiller 20-City Home Price Index© (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=SPCS20RSA | Full Description |
| ##OIL | Macro - Prices (FRED) | Crude Oil Prices: West Texas Intermediate (WTI) - Cushing, OK (daily) Corresponding FRED id=DCOILWTICO | Full Description |
| ##PPI | Macro - Prices (FRED) | Producer Price Index: Finished Goods (monthly) Can be used in conjunction with PITSeries function Corresponding FRED id=WPSFD49207 | Full Description |
| ##CAB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rate for Canada (monthly) Corresponding FRED id=IR3TIB01CAM156N | Full Description |
| ##CAT10YR | Macro - Treasuries: bills-bonds-notes (FRED) | 10-Year Government Bond Yield for Canada (monthly) Corresponding FRED id=IRLTLT01CAM156N | Full Description |
| ##CHT10YR | Macro - Treasuries: bills-bonds-notes (FRED) | 10-Year Government Bond Yield for Switzerland (monthly) Corresponding FRED id=IRLTLT01CHM156N | Full Description |
| ##EUB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rate for the Euro Area (monthly) Corresponding FRED id=IR3TIB01EZM156N | Full Description |
| ##EUT10YR | Macro - Treasuries: bills-bonds-notes (FRED) | 10-Year Government Bond Yield for the Euro Area (monthly) Corresponding FRED id=IRLTLT01EZM156N | Full Description |
| ##GBB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rate for the United Kingdom (monthly) Corresponding FRED id=IR3TIB01GBM156N | Full Description |
| ##GBT10YR | Macro - Treasuries: bills-bonds-notes (FRED) | 10-Year Government Bond Yield for the United Kingdom (monthly) Corresponding FRED id=IRLTLT01GBM156N | Full Description |
| ##NOB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rates for Norway (monthly) Corresponding FRED id=IR3TIB01NOM156N | Full Description |
| ##PLB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rates for Poland (monthly) Corresponding FRED id=IR3TIB01PLM156N | Full Description |
| ##SEB3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Interbank Rates for Sweden (monthly) Corresponding FRED id=IR3TIB01SEM156N | Full Description |
| ##UST1MO | Macro - Treasuries: bills-bonds-notes (FRED) | 1-Month Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS1MO | Full Description |
| ##UST3MO | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Month Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS3MO | Full Description |
| ##UST6MO | Macro - Treasuries: bills-bonds-notes (FRED) | 6-Month Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS6MO | Full Description |
| ##UST1YR | Macro - Treasuries: bills-bonds-notes (FRED) | 1-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS1 | Full Description |
| ##UST2YR | Macro - Treasuries: bills-bonds-notes (FRED) | 2-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS2 | Full Description |
| ##UST3YR | Macro - Treasuries: bills-bonds-notes (FRED) | 3-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS3 | Full Description |
| ##UST5YR | Macro - Treasuries: bills-bonds-notes (FRED) | 5-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS5 | Full Description |
| ##UST7YR | Macro - Treasuries: bills-bonds-notes (FRED) | 7-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS7 | Full Description |
| ##UST10YR | Macro - Treasuries: bills-bonds-notes (FRED) | 10-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS10 | Full Description |
| ##UST20YR | Macro - Treasuries: bills-bonds-notes (FRED) | 20-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS20 | Full Description |
| ##UST30YR | Macro - Treasuries: bills-bonds-notes (FRED) | 30-Year Treasury Constant Maturity Rate (USD) (daily) Corresponding FRED id=DGS30 | Full Description |
| + - * / ^ | Math operators | Mathematical Operators: + Sum - Subtract * Multiply / Divide ^ Power (x^y is x raised to the power of y) | |
| #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. | |
| FALLBACK | N/A during preliminaries | Fallback to previous period | |
| KEEPNA | N/A during preliminaries | Keep NA values | |
| ZERONA | N/A during preliminaries | Set NA values to 0 | |
| MATERIALS | Non-Energy Materials | 45 - Non-Energy Materials | Full Description |
| CHEM | Non-Energy Materials | 4510 - Chemical, Plastic and Rubber Materials | Full Description |
| CHEMCOMMOD | Non-Energy Materials | 451010 - Commodity Chemicals | Full Description |
| ORGANICCHEM | Non-Energy Materials | 45101010 - Organic and Petrochemical Products | Full Description |
| COMMODITYCHEM | Non-Energy Materials | 45101015 - Other Commodity Chemical Manufacturing | Full Description |
| CHEMMIX | Non-Energy Materials | 451015 - Mixed Chemicals | Full Description |
| CHEMSPECIAL | Non-Energy Materials | 451020 - Specialty and Performance Chemicals | Full Description |
| ADDITIVES | Non-Energy Materials | 45102010 - Additives Manufacturing | Full Description |
| ADHESIVE | Non-Energy Materials | 45102015 - Adhesive, Sealant, Coating and Paint Products | Full Description |
| AGROCHEM | Non-Energy Materials | 45102020 - Agrochemical Products | Full Description |
| SANITIZE | Non-Energy Materials | 45102025 - Cleaning and Sanitizing Agent Products | Full Description |
| CHEMMFROTHER | Non-Energy Materials | 45102030 - Other Specialty/Performance Chemical Manufacturing | Full Description |
| POLYMER | Non-Energy Materials | 45102035 - Specialty/Performance Fibers and Polymer Products | Full Description |
| PLASTIC | Non-Energy Materials | 451025 - Plastic and Rubber Products | Full Description |
| PLASTICOTHER | Non-Energy Materials | 45102510 - Other Plastic and Rubber Products Manufacturing | Full Description |
| PLASTICMFR | Non-Energy Materials | 45102515 - Plastic Products Manufacturing | Full Description |
| MINING | Non-Energy Materials | 4515 - Mining and Mineral Products | Full Description |
| METAL | Non-Energy Materials | 451510 - Metal Products | Full Description |
| METALPARTS | Non-Energy Materials | 45151010 - Metal Parts and Component Manufacturing | Full Description |
| METALOTHER | Non-Energy Materials | 45151015 - Other Metal Product Manufacturing | Full Description |
| METALPRIMARY | Non-Energy Materials | 45151020 - Primary Metals Products | Full Description |
| MINERAL | Non-Energy Materials | 451515 - Minerals | Full Description |
| MIXMETALMINERAL | Non-Energy Materials | 451520 - Mixed Metal and Mineral Products | Full Description |
| ORE | Non-Energy Materials | 451525 - Metal Ore Mining | Full Description |
| OREBASE | Non-Energy Materials | 45152510 - Base Metal Mining | Full Description |
| OREOTHER | Non-Energy Materials | 45152515 - Other Metal Ore Mining | Full Description |
| PRECIOUS | Non-Energy Materials | 45152520 - Precious Metal Mining | Full Description |
| MININGOTHER | Non-Energy Materials | 451530 - Other Mining | Full Description |
| OREMULTI | Non-Energy Materials | 45153010 - Multi-Product Mining | Full Description |
| ORENONMETAL | Non-Energy Materials | 45153015 - Nonmetallic Mineral Mining | Full Description |
| MININGSTREAMING | Non-Energy Materials | 45153020 - Streaming and Royalties | Full Description |
| MATCONSTR | Non-Energy Materials | 451535 - Construction Materials | Full Description |
| ARCHITECTCOMPONENT | Non-Energy Materials | 45153510 - Architectural and Infrastructure Component Makers | Full Description |
| MATCONSTRGEN | Non-Energy Materials | 45153515 - General Construction Materials Manufacturing | Full Description |
| MATCONSTRHEAVY | Non-Energy Materials | 45153520 - Heavy Building Material and Aggregate Products | Full Description |
| MFRPROD | Non-Energy Materials | 4520 - Manufactured Products | Full Description |
| WOODPAPER | Non-Energy Materials | 452010 - Forestry and Paper Products | Full Description |
| WOOD | Non-Energy Materials | 45201010 - Construction Wood Products | Full Description |
| WOODPAPEROTHER | Non-Energy Materials | 45201015 - Other Forestry and Paper Products Manufacturing | Full Description |
| PAPER | Non-Energy Materials | 45201020 - Paper and Paper Products | Full Description |
| PACKAGING | Non-Energy Materials | 452015 - Containers and Packaging | Full Description |
| PACKAGINGMETAL | Non-Energy Materials | 45201510 - Metal Packaging Products | Full Description |
| PACKAGINGOTHER | Non-Energy Materials | 45201515 - Other Containers and Packaging Products | Full Description |
| PACKAGINGPAPER | Non-Energy Materials | 45201520 - Paper Packaging Products | Full Description |
| PACKAGINGPLASTIC | Non-Energy Materials | 45201525 - Plastic Packaging Products | Full Description |
| MATOTHER | Non-Energy Materials | 452020 - Other Materials | Full Description |
| TEXTILE | Non-Energy Materials | 45202010 - Textile Products | Full Description |
| MATDIV | Non-Energy Materials | 45202015 - Diversified Materials | Full Description |
| COMPMAT | Non-Energy Materials | 45202020 - Composite Materials Manufacturing Since 2021-08-21, previously part of MATDIV | Full Description |
| NA | Numerical Constants | NA value | |
| TRUE | Numerical Constants | TRUE or 1 | |
| FALSE | Numerical Constants | FALSE or 0 | |
| #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 | |
| ( ) | Precedence operators | Precedence Operators: Use parentheses to change the order operations are calculated. For example: ( 10 + 5 ) / 5 = 3 10 + 5 / 5 = 11 When in doubt, always use parentheses. | |
| #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) | |
| // | Rule comments | Allows you to add comments to a rule. Everything after // is ignored. Example: Close(0)>5 // this is a comment | |
| #SPRPBlend | S&P 500 IDs | SP500 Risk Premium (weekly) | Full Description |
| #SPYieldBlend | S&P 500 IDs | SP500 Yield (weekly) based on the time weighted analysts estimates of CurrY and NextY | Full Description |
| #SPEPSCNY | S&P 500 IDs | SP500 EPS Blend Y (weekly) based on the time weighted analysts estimates of CurrY and NextY | Full Description |
| #SPEPSQ | S&P 500 IDs | SP500 EPS Blend Q (weekly) | Full Description |
| #SPEPSTTM | S&P 500 IDs | SP500 EPS Trailing 12 months (weekly) | Full Description |
| : | Show/Set Variable operator | Following rule "@myvar:expression" sets a variable @myvar to expression, returns the expression, and displays @myvar in the screen report | Full Description |
| TECH | Technology | 55 - Technology | Full Description |
| ELECTRONIC | Technology | 5510 - Electronic Components and Manufacturing | Full Description |
| COMPONENTS | Technology | 551010 - Electronic Components | Full Description |
| COMPONENTINTERCONNECT | Technology | 55101010 - Interconnect Electronic Components | Full Description |
| COMPONENTMODULE | Technology | 55101015 - Module and Subassembly Components | Full Description |
| COMPONENTOPTOELECTRONIC | Technology | 55101020 - Optoelectronics Electronic Components | Full Description |
| COMPONENTPASSIVE | Technology | 55101025 - Passive Electronic Components | Full Description |
| COMPONENTDIV | Technology | 55101030 - Diversified Electronic Components | Full Description |
| ELECTRONICEQUIP | Technology | 551015 - Manufacturing Equipment and Services | Full Description |
| CONTRACTELECMFR | Technology | 55101510 - Contract Electronic Manufacturing | Full Description |
| ELECTRONICEQUIPDIV | Technology | 55101515 - Diversified Electronic Manufacturing and Services | Full Description |
| INTERCONNECTMFR | Technology | 55101520 - Interconnect Fabrication | Full Description |
| SEMIMFR | Technology | 551020 - Semiconductor Manufacturing | Full Description |
| SEMIANALOG | Technology | 55102010 - Analog and Mixed Signal Semiconductors | Full Description |
| SEMIDISCRETE | Technology | 55102015 - Discrete Semiconductors | Full Description |
| SEMIGEN | Technology | 55102020 - General Semiconductors | Full Description |
| SEMIMEMORY | Technology | 55102025 - Memory Semiconductors | Full Description |
| SEMIPROCESSOR | Technology | 55102030 - Processor Semiconductors | Full Description |
| SEMIASIC | Technology | 55102035 - Programmable Logic and ASIC Semiconductors | Full Description |
| SEMISPECIAL | Technology | 55102040 - Specialized Semiconductors | Full Description |
| ELECTRONICMFR | Technology | 551025 - Electronic Equipment Manufacturing | Full Description |
| SEMIEQUIPSVCE | Technology | 551030 - Semiconductor Equipment and Services | Full Description |
| SEMIMFREQUIP | Technology | 55103010 - Semiconductor Manufacturing Capital Equipment | Full Description |
| SEMIMFRSVCE | Technology | 55103015 - Semiconductor Manufacturing Services | Full Description |
| HW | Technology | 5515 - Hardware | Full Description |
| COMMERCIALELECTRONICS | Technology | 551510 - Commercial Electronics | Full Description |
| COMMERCEEQUIP | Technology | 55151010 - Commerce Equipment | Full Description |
| SECURITYEQUIP | Technology | 55151015 - Electronic Security Equipment | Full Description |
| FINELECTRONICS | Technology | 55151020 - Finance/Banking Industry Electronics Production | Full Description |
| MEDIAELECTRONICS | Technology | 55151025 - Media Industry Electronics Manufacturing | Full Description |
| OFFICEEQUIP | Technology | 55151030 - Office Equipment Products | Full Description |
| COMMERCIALELECTRONICSMFR | Technology | 55151035 - Other Commercial Electronics Manufacturing | Full Description |
| PRINTINGELECTRONICS | Technology | 55151040 - Printing/Publishing Industry Electronics Makers | Full Description |
| MEASURE | Technology | 55151045 - Test and Measurement Equipment | Full Description |
| COMMEQUIP | Technology | 551515 - Communications Equipment | Full Description |
| BIZCOMM | Technology | 55151510 - Business Communications Equipment | Full Description |
| CABLEEQUIP | Technology | 55151515 - Cable Equipment | Full Description |
| LANEQUIP | Technology | 55151520 - Local Area Networking Equipment | Full Description |
| COMMEQUIPOTHER | Technology | 55151525 - Other Communications Equipment | Full Description |
| SATELLITEEQUIP | Technology | 55151530 - Satellite Equipment | Full Description |
| WANEQUIP | Technology | 55151535 - Wide Area Networking Equipment | Full Description |
| WIRELESSINFEQUIP | Technology | 55151540 - Wireless Core Infrastructure Equipment | Full Description |
| WIRELESSMOBILEEQUIP | Technology | 55151545 - Wireless Mobile Equipment | Full Description |
| COMPUTER | Technology | 551520 - Computer Hardware and Storage | Full Description |
| PERIPHERALS | Technology | 55152010 - Computer Peripherals | Full Description |
| COMPUTERSYSTEMS | Technology | 55152015 - Computer Systems | Full Description |
| DATASTORAGEHW | Technology | 55152020 - Data Storage Hardware | Full Description |
| COMPUTERGEN | Technology | 55152025 - General Computer Hardware | Full Description |
| HWCOMPONENTS | Technology | 55152030 - Hardware Components | Full Description |
| CONSUMERELECTRONICS | Technology | 551525 - Consumer Electronics | Full Description |
| AUDIOMFR | Technology | 55152510 - Audio Electronics Manufacturing | Full Description |
| AUTOELECTRONICSMFR | Technology | 55152515 - Automotive and Marine Electronics Manufacturing | Full Description |
| CONSUMERELECTRONICSACCESS | Technology | 55152520 - Consumer Electronics Accessories Manufacturing | Full Description |
| VIDEOEQUIP | Technology | 55152525 - Consumer Video Electronics Equipment | Full Description |
| GAMING | Technology | 55152530 - Electronic Gaming/Entertainment Electronics Makers | Full Description |
| CONSUMERELECTRONICSGEN | Technology | 55152535 - General Consumer Electronics Manufacturing | Full Description |
| PHOTO | Technology | 55152540 - Photography Equipment | Full Description |
| VIRTUALREALITY | Technology | 55152545 - Virtual Reality Equipment Since 2018-02-02 | Full Description |
| WEARABLETECH | Technology | 55152550 - Wearable Technology Since 2018-02-02 | Full Description |
| TECHDISTRIB | Technology | 551530 - Information Technology Distribution | Full Description |
| HWDISTRIB | Technology | 55153010 - IT Hardware Distributors | Full Description |
| TECHDISTRIBOTHER | Technology | 55153015 - Other IT Distributors | Full Description |
| SOFTWDISTRIB.XX1 | Technology | 55153020 - Software Distributors Discontinued 2022-07-30, replaced by SOFTWDISTRIB | Full Description |
| SOFTWTECH | Technology | 5520 - Software and Consulting | Full Description |
| INTERNET | Technology | 552010 - Internet and Data Services | Full Description |
| CONSUMERDATA | Technology | 55201010 - Consumer Data and Services | Full Description |
| INTERNETMEDIA | Technology | 55201015 - Diversified Electronic Media Services | Full Description |
| INTERNETHOSTING | Technology | 55201020 - Internet Hosting Services | Full Description |
| TECHSUPPORT | Technology | 55201025 - Internet Support Services | Full Description |
| PRODATA | Technology | 55201030 - Professional Data and Services | Full Description |
| WEBDATA | Technology | 55201035 - Web-Based Data and Services | Full Description |
| SOFTW | Technology | 552015 - Software | Full Description |
| SOFTWDESIGN | Technology | 55201510 - Design and Engineering Software | Full Description |
| SOFTWENTERPRISE | Technology | 55201515 - Enterprise Management Software | Full Description |
| SOFTWGAMES | Technology | 55201520 - Games Software | Full Description |
| SOFTWHOMEOFFICE | Technology | 55201525 - Home and Office Software | Full Description |
| SOFTWINDSPECIFIC | Technology | 55201530 - Industry-Specific Software | Full Description |
| SOFTWINF | Technology | 55201535 - IT Infrastructure Software | Full Description |
| SOFTWGEN | Technology | 55201540 - General and Mixed-Type Software | Full Description |
| TECHCONSULTSVCE | Technology | 552020 - Technology Consulting Services | Full Description |
| TECHCONSULTGEN | Technology | 55202010 - General Enterprise and Technology Consulting | Full Description |
| TECHINDSPECIFIC | Technology | 55202015 - Industry-Specific IT Services | Full Description |
| TECHCONSULT | Technology | 55202020 - Information Technology Consulting | Full Description |
| TECHCONSULTNETW | Technology | 55202025 - Infrastructure and Network Consulting Services | Full Description |
| SOFTWDISTRIB | Technology | 552025 - Software Distribution Since 2022-07-30, previously SOFTWDISTRIB.XX1 | Full Description |
| TELECOM | Telecommunications | 60 - Telecommunications | Full Description |
| TELECOMSS | Telecommunications | 6010 - Telecommunications | Full Description |
| TELECOMOTHER | Telecommunications | 601010 - Other Telecommunications Services | Full Description |
| TELECOMINTL | Telecommunications | 60101010 - Mixed International Telecommunications Services | Full Description |
| SATELLITESVCE | Telecommunications | 60101015 - Diversified Satellite Services | Full Description |
| SATELLITEINTL | Telecommunications | 60101020 - International Satellite Services | Full Description |
| TELECOMUSOTHER | Telecommunications | 60101025 - Other United States Telecommunications Services | Full Description |
| TELECOMCARRIER | Telecommunications | 60101030 - Telecommunications Carrier Services | Full Description |
| TELECOMSOFTW | Telecommunications | 60101035 - Telecommunications Industry Software | Full Description |
| TELECOMSOFTWSVCE | Telecommunications | 60101040 - Telecommunications Industry Software and Services | Full Description |
| SATELLITEUS | Telecommunications | 60101045 - United States Satellite Services | Full Description |
| TELECOMAMEREXUS | Telecommunications | 60101050 - Mixed Telecommunications Services, Americas Since 2021-08-21, previously part of TELECOMINTL, WIRELESS, and WIRELINE | Full Description |
| TELECOMASIA | Telecommunications | 60101055 - Mixed Telecommunications Services, Asia/Pacific Since 2021-08-21, previously part of TELECOMINTL, WIRELESS, and WIRELINE | Full Description |
| TELECOMEUROPE | Telecommunications | 60101060 - Mixed Telecommunications Services, Europe Since 2021-08-21, previously part of TELECOMINTL, WIRELESS, and WIRELINE | Full Description |
| TELECOMMIDEAST | Telecommunications | 60101065 - Mixed Telecommunications Services, Middle East/Africa Since 2021-08-21, previously part of TELECOMINTL, WIRELESS, and WIRELINE | Full Description |
| TELECOMWIRE | Telecommunications | 601015 - Wireless and Wireline Telecommunications Services | Full Description |
| WIRELESS | Telecommunications | 60101510 - Wireless Services | Full Description |
| WIRELINE | Telecommunications | 60101515 - Wireline Services | Full Description |
| ALLFUND | Universe IDs | All Fundamentals | |
| ALLSTOCKS | Universe IDs | All Stocks | |
| DJIA | Universe IDs - Major USA | Dow Jones Industrial Average | |
| NOOTC | Universe IDs - Major USA | No OTC Exchange | |
| Prussell1000 | Universe IDs - Major USA | Prussell 1000 | |
| Prussell2000 | Universe IDs - Major USA | Prussell 2000 | |
| Prussell3000 | Universe IDs - Major USA | Prussell 3000 | |
| SP1500 | Universe IDs - Major USA | iShares S&P1500 CompositeCap (IVV+IJH+IJR) | |
| SP500 | Universe IDs - Major USA | iShares S&P500 LargeCap (IVV) | |
| $ADR | Universe IDs - Other USA | American Depositary Receipt | |
| LargeCap | Universe IDs - Other USA | Large Cap | |
| MasterLP | Universe IDs - Other USA | Master Limited Partnerships | |
| MicroCap | Universe IDs - Other USA | MicroCap | |
| MidCap | Universe IDs - Other USA | Mid Cap | |
| NASD | Universe IDs - Other USA | NASDAQ Exchange | |
| NASDAQ100 | Universe IDs - Other USA | Nasdaq 100 | |
| NYSE | Universe IDs - Other USA | NY Stock Exchange | |
| NYSEMKT | Universe IDs - Other USA | NYSE MKT (AMEX) | |
| OTC | Universe IDs - Other USA | Over The Counter | |
| SmallCap | Universe IDs - Other USA | Small Cap | |
| SP400 | Universe IDs - Other USA | iShares S&P400 MidCap (IJH) | |
| SP600 | Universe IDs - Other USA | iShares S&P600 SmallCap (IJR) | |
| UTIL | Utilities | 65 - Utilities | Full Description |
| UTILSS | Utilities | 6510 - Utilities | Full Description |
| ENERGYUTIL | Utilities | 651010 - Energy Utilities | Full Description |
| UTILELEC | Utilities | 65101010 - Electric Utilities | Full Description |
| GAS | Utilities | 65101015 - Natural Gas Utilities | Full Description |
| UTILELECGAS | Utilities | 65101020 - Other Electric and Natural Gas Utilities | Full Description |
| POWER.XX1 | Utilities | 65101025 - Wholesale Power Generation and Marketing Discontinued 2018-02-02, replaced by POWERMULTINAT, POWERUS, POWERAMEREXUS, POWERASIA, and POWERINTLOTHER | Full Description |
| POWERMULTINAT | Utilities | 65101030 - Multinational Wholesale Power Since 2018-02-02, previously part of POWER.XX1 | Full Description |
| POWERUS | Utilities | 65101035 - United States Wholesale Power Since 2018-02-02, previously part of POWER.XX1 | Full Description |
| POWERAMEREXUS | Utilities | 65101040 - Americas Wholesale Power Since 2018-02-02, previously part of POWER.XX1 | Full Description |
| POWERASIA | Utilities | 65101045 - Asia/Pacific Wholesale Power Since 2018-02-02, previously part of POWER.XX1 | Full Description |
| POWERINTLOTHER | Utilities | 65101050 - Other International Wholesale Power Since 2018-02-02, previously part of POWER.XX1 | Full Description |
| XMSNUS | Utilities | 65101055 - United States Transmission, Distribution, and Storage Since 2021-08-21, previously part of FACIL | Full Description |
| XMSNMULTINAT | Utilities | 65101060 - Multinational Transmission, Distribution, and Storage Since 2021-08-21, previously part of FACIL, UTILELEC, POWERAMEREXUS, POWERASIA, and POWERINTLOTHER | Full Description |
| WATER | Utilities | 651015 - Water Utilities | Full Description |
| WATERINTL | Utilities | 65101510 - International Water Utilities | Full Description |
| WATERUS | Utilities | 65101515 - United States Water Utilities | Full Description |
| WATERMULTINAT | Utilities | 65101520 - Multi-National Water Utilities | Full Description |