Forum Discussion
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. Can i manually change it? Getting spill errors when i ...
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.