Industry PE

The industryPE data type returns the average industry price-to-earnings ratio (PE) for the global exchange market on the date specified.

=SF(exchange, "industryPE", industries, date, options)

• exchange is the symbol of the exchange (e.g., "NSE" or "NASDAQ"). You can check our Available Markets to find the correct symbol.

• industries selects what industries to display. Leave blank or use "all" to display all industries. Chain together industries with the | symbol to display more than one (e.g. "Steel|Silver|Other Precious Metals").

• date is the date for which you want to retrieve the data. The date should either be a date formatted Google Sheets object or a text string in the format of YYYY-MM-DD or DD/MM/YYYY.

• options adjusts the formatting of the output. Set this field to "NH" for no header rows or "-" for reversed order. You can combine options with the & operator like so "NH&-".

The industries options are:

• Steel ("Steel")

• Silver ("Silver")

• Other Precious Metals ("Other Precious Metals")

• Gold ("Gold")

• Copper ("Copper")

• Aluminum ("Aluminum")

• Paper, Lumber & Forest Products ("Paper, Lumber & Forest Products")

• Industrial Materials ("Industrial Materials")

• Construction Materials ("Construction Materials")

• Chemicals - Specialty ("Chemicals - Specialty")

• ... Jump to the full list of available industries

Examples

Example 1 - Display all industries, most recent date

=SF("NSE", "industryPE")

Example 2 - Display several selected industries, specific date

=SF("NASDAQ", "industryPE", "Telecommunications Services|Travel Services|Luxury Goods", "2022-01-01")

List of Available Industries

• Steel ("Steel")

• Silver ("Silver")

• Other Precious Metals ("Other Precious Metals")

• Gold ("Gold")

• Copper ("Copper")

• Aluminum ("Aluminum")

• Paper, Lumber & Forest Products ("Paper, Lumber & Forest Products")

• Industrial Materials ("Industrial Materials")

• Construction Materials ("Construction Materials")

• Chemicals - Specialty ("Chemicals - Specialty")

• Chemicals ("Chemicals")

• Agricultural Inputs ("Agricultural Inputs")

• Telecommunications Services ("Telecommunications Services")

• Internet Content & Information ("Internet Content & Information")

• Publishing ("Publishing")

• Broadcasting ("Broadcasting")

• Advertising Agencies ("Advertising Agencies")

• Entertainment ("Entertainment")

• Travel Lodging ("Travel Lodging")

• Travel Services ("Travel Services")

• Specialty Retail ("Specialty Retail")

• Luxury Goods ("Luxury Goods")

• Home Improvement ("Home Improvement")

• Residential Construction ("Residential Construction")

• Department Stores ("Department Stores")

• Personal Products & Services ("Personal Products & Services")

• Leisure ("Leisure")

• Gambling, Resorts & Casinos ("Gambling, Resorts & Casinos")

• Furnishings, Fixtures & Appliances ("Furnishings, Fixtures & Appliances")

• Restaurants ("Restaurants")

• Auto - Parts ("Auto - Parts")

• Auto - Manufacturers ("Auto - Manufacturers")

• Auto - Recreational Vehicles ("Auto - Recreational Vehicles")

• Auto - Dealerships ("Auto - Dealerships")

• Apparel - Retail ("Apparel - Retail")

• Apparel - Manufacturers ("Apparel - Manufacturers")

• Apparel - Footwear & Accessories ("Apparel - Footwear & Accessories")

• Packaging & Containers ("Packaging & Containers")

• Tobacco ("Tobacco")

• Grocery Stores ("Grocery Stores")

• Discount Stores ("Discount Stores")

• Household & Personal Products ("Household & Personal Products")

• Packaged Foods ("Packaged Foods")

• Food Distribution ("Food Distribution")

• Food Confectioners ("Food Confectioners")

• Agricultural Farm Products ("Agricultural Farm Products")

• Education & Training Services ("Education & Training Services")

• Beverages - Wineries & Distilleries ("Beverages - Wineries & Distilleries")

• Beverages - Non-Alcoholic ("Beverages - Non-Alcoholic")

• Beverages - Alcoholic ("Beverages - Alcoholic")

• Uranium ("Uranium")

• Solar ("Solar")

• Oil & Gas Refining & Marketing ("Oil & Gas Refining & Marketing")

• Oil & Gas Midstream ("Oil & Gas Midstream")

• Oil & Gas Integrated ("Oil & Gas Integrated")

• Oil & Gas Exploration & Production ("Oil & Gas Exploration & Production")

• Oil & Gas Equipment & Services ("Oil & Gas Equipment & Services")

• Oil & Gas Energy ("Oil & Gas Energy")

• Oil & Gas Drilling ("Oil & Gas Drilling")

• Coal ("Coal")

• Shell Companies ("Shell Companies")

• Investment - Banking & Investment Services ("Investment - Banking & Investment Services")

• Insurance - Specialty ("Insurance - Specialty")

• Insurance - Reinsurance ("Insurance - Reinsurance")

• Insurance - Property & Casualty ("Insurance - Property & Casualty")

• Insurance - Life ("Insurance - Life")

• Insurance - Diversified ("Insurance - Diversified")

• Insurance - Brokers ("Insurance - Brokers")

• Financial - Mortgages ("Financial - Mortgages")

• Financial - Diversified ("Financial - Diversified")

• Financial - Data & Stock Exchanges ("Financial - Data & Stock Exchanges")

• Financial - Credit Services ("Financial - Credit Services")

• Financial - Conglomerates ("Financial - Conglomerates")

• Financial - Capital Markets ("Financial - Capital Markets")

• Banks - Regional ("Banks - Regional")

• Banks - Diversified ("Banks - Diversified")

• Banks ("Banks")

• Asset Management ("Asset Management")

• Asset Management - Bonds ("Asset Management - Bonds")

• Asset Management - Income ("Asset Management - Income")

• Asset Management - Leveraged ("Asset Management - Leveraged")

• Asset Management - Cryptocurrency ("Asset Management - Cryptocurrency")

• Asset Management - Global ("Asset Management - Global")

• Medical - Specialties ("Medical - Specialties")

• Medical - Pharmaceuticals ("Medical - Pharmaceuticals")

• Medical - Instruments & Supplies ("Medical - Instruments & Supplies")

• Medical - Healthcare Plans ("Medical - Healthcare Plans")

• Medical - Healthcare Information Services ("Medical - Healthcare Information Services")

• Medical - Equipment & Services ("Medical - Equipment & Services")

• Medical - Distribution ("Medical - Distribution")

• Medical - Diagnostics & Research ("Medical - Diagnostics & Research")

• Medical - Devices ("Medical - Devices")

• Medical - Care Facilities ("Medical - Care Facilities")

• Drug Manufacturers - Specialty & Generic ("Drug Manufacturers - Specialty & Generic")

• Drug Manufacturers - General ("Drug Manufacturers - General")

• Biotechnology ("Biotechnology")

• Waste Management ("Waste Management")

• Trucking ("Trucking")

• Railroads ("Railroads")

• Aerospace & Defense ("Aerospace & Defense")

• Marine Shipping ("Marine Shipping")

• Integrated Freight & Logistics ("Integrated Freight & Logistics")

• Airlines, Airports & Air Services ("Airlines, Airports & Air Services")

• General Transportation ("General Transportation")

• Manufacturing - Tools & Accessories ("Manufacturing - Tools & Accessories")

• Manufacturing - Textiles ("Manufacturing - Textiles")

• Manufacturing - Miscellaneous ("Manufacturing - Miscellaneous")

• Manufacturing - Metal Fabrication ("Manufacturing - Metal Fabrication")

• Industrial - Distribution ("Industrial - Distribution")

• Industrial - Specialties ("Industrial - Specialties")

• Industrial - Pollution & Treatment Controls ("Industrial - Pollution & Treatment Controls")

• Environmental Services ("Environmental Services")

• Industrial - Machinery ("Industrial - Machinery")

• Industrial - Infrastructure Operations ("Industrial - Infrastructure Operations")

• Industrial - Capital Goods ("Industrial - Capital Goods")

• Consulting Services ("Consulting Services")

• Business Equipment & Supplies ("Business Equipment & Supplies")

• Staffing & Employment Services ("Staffing & Employment Services")

• Rental & Leasing Services ("Rental & Leasing Services")

• Engineering & Construction ("Engineering & Construction")

• Security & Protection Services ("Security & Protection Services")

• Specialty Business Services ("Specialty Business Services")

• Construction ("Construction")

• Conglomerates ("Conglomerates")

• Electrical Equipment & Parts ("Electrical Equipment & Parts")

• Agricultural - Machinery ("Agricultural - Machinery")

• Agricultural - Commodities/Milling ("Agricultural - Commodities/Milling")

• REIT - Specialty ("REIT - Specialty")

• REIT - Retail ("REIT - Retail")

• REIT - Residential ("REIT - Residential")

• REIT - Office ("REIT - Office")

• REIT - Mortgage ("REIT - Mortgage")

• REIT - Industrial ("REIT - Industrial")

• REIT - Hotel & Motel ("REIT - Hotel & Motel")

• REIT - Healthcare Facilities ("REIT - Healthcare Facilities")

• REIT - Diversified ("REIT - Diversified")

• Real Estate - Services ("Real Estate - Services")

• Real Estate - Diversified ("Real Estate - Diversified")

• Real Estate - Development ("Real Estate - Development")

• Real Estate - General ("Real Estate - General")

• Information Technology Services ("Information Technology Services")

• Hardware, Equipment & Parts ("Hardware, Equipment & Parts")

• Computer Hardware ("Computer Hardware")

• Electronic Gaming & Multimedia ("Electronic Gaming & Multimedia")

• Software - Services ("Software - Services")

• Software - Infrastructure ("Software - Infrastructure")

• Software - Application ("Software - Application")

• Semiconductors ("Semiconductors")

• Media & Entertainment ("Media & Entertainment")

• Communication Equipment ("Communication Equipment")

• Technology Distributors ("Technology Distributors")

• Consumer Electronics ("Consumer Electronics")

• Renewable Utilities ("Renewable Utilities")

• Regulated Water ("Regulated Water")

• Regulated Gas ("Regulated Gas")

• Regulated Electric ("Regulated Electric")

• Independent Power Producers ("Independent Power Producers")

• Diversified Utilities ("Diversified Utilities")

• General Utilities ("General Utilities")