Forum Discussion

Zeev Dzialoshinsky's avatar
Zeev Dzialoshinsky
Copper Contributor
Aug 02, 2025

US Stock Exchange

StockSECTOR 
AAUS#FIELD! 
 

I need a function in Excel. The first column contains all the stock symbols on the American stock market, and in the second column I want the function to find which sector the symbol belongs to. 

  1. I Selected the stock symbols, I did go to the Data tab, and click Stocks. Excel will convert them into linked records.
  2. I use the function =A2.Sector, but I get on the second cell #FIELD!

Is some one can help me?

excel
Excel on Mac
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 04, 2025

    In stock data card they provide Industry field, not Sector.  You may generate separate table with industries per sector and XLOOKUP sectors from it.