SheetsFinance Docs
Market Data

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&-".

Tips:

  • Note that industries use the "|" separator for chaining multiple industries together, not "&". For example, "Steel|Silver|Other Precious Metals".

  • Use the Function Generator to easily create this function and select the correct industries, as there a many to select from!

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")
Industry PE Example 1

Example 2 - Display several selected industries, specific date

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

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")

Was this helpful?