Forum Discussion

CraigJS's avatar
CraigJS
Copper Contributor
Dec 25, 2024

Stock Function - Industry Coming Back as #FIELD!

Populating Industry fields for stocks and getting #Field errors.  Canadia Stock exchange.  REITs not coming back as well as mutual funds. 

 

  1. Can i manually change it?  Getting spill errors when i do
  2. Can i do something else to get the industry to populate

 

Even if i can just get generic ETF/Mutual Fund, REIT/Real Estate would be better than errors

 

Thanks

 

Craig

BI & Data Analysis
excel
Formulas and Functions
office 365

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 28, 2024

    Which exactly function do you use? STOCK returns rich data type, that's not a function.

    Extracting Industry (or any other field) you may use IFERROR, e.g.

    =IFERROR( FIELDVALUE(A1, "Industry"), "not defined" )

    or

    =IFERROR( A1.Industry, "not defined" )

    or use more complex logic.