FIELDVALUE

FIELDVALUE(value, field_name)

Returns the value in a particular field from a linked data type.

valueThe company name (for stocks) or region name (for geography).
field_nameThe name (or names) of the fields you want.

REMARKS
* Added in Microsoft 365.
* This function can be used with the Stocks Linked Data Type.
* This function can be used with the Geography Linked Data Type.
* An alternative to using this function is to use the "cell" notation. If the "field_name" contains a space you must enclose it inside square brackets.
* You can use the STOCKHISTORY function to return historical data about a financial instrument.
* Below cell "C1" contains a Stocks linked data type. To create this type "Microsoft Corp" into a cell and select Data Tab, Stocks.
* Below cell "C28" contain a Geography linked data type. To create this type "United Kingdom" into a cell and select Data Tab, Geography.
* This function was released in March 2020.
* For the Microsoft documentation refer to support.microsoft.com

 ABC
1=FIELDVALUE(C1,B1) = $349.6752 week highMICROSOFT CORPORATION (XNAS:MSFT)
2=FIELDVALUE(C1,B2) = $241.5152 week low 
3=FIELDVALUE(C1,B3) = $0.93Beta 
4=FIELDVALUE(C1,B4) = $2.75Change 
5=FIELDVALUE(C1,B5) = $0.01Change (%) 
6=FIELDVALUE(C1,B6) = USDCurrency 
7=FIELDVALUE(C1,B7) = [full description]Description 
8=FIELDVALUE(C1,B8) = 181,000_ Employees 
9=FIELDVALUE(C1,B9) = XNASExchange abbreviation 
10=FIELDVALUE(C1,B10) = 1 Microsoft WayHeadquarters 
11=FIELDVALUE(C1,B11) = $259.77High 
12=FIELDVALUE(C1,B12) = Software & IT ServicesIndustry 
13=FIELDVALUE(C1,B13) = StockInstrument type 
14=FIELDVALUE(C1,B14) = 11:59:42 PMLast trade time 
15=FIELDVALUE(C1,B15) = $254.61Low 
16=FIELDVALUE(C1,B16) = 1,941,407,386,140_ Market cap 
17=FIELDVALUE(C1,B17) = MICROSOFT CORPORATIONName 
18=FIELDVALUE(C1,B18) = MICROSOFT CORPORATIONOfficial name 
19=FIELDVALUE(C1,B19) = $256.39Open 
20=FIELDVALUE(C1,B20) = $26.80P/E 
21=FIELDVALUE(C1,B21) = $256.83Previous close 
22=FIELDVALUE(C1,B22) = $259.58Price 
23=FIELDVALUE(C1,B23) = 7,479,033,000_ Shares outstanding 
24=FIELDVALUE(C1,B24) = MSFTTicker symbol 
25=FIELDVALUE(C1,B25) = 22,837,692_ Volume 
26=FIELDVALUE(C1,B26) = 29,591,601_ Volume average 
27=FIELDVALUE(C1,B27) = 1993_ Year incorporated 
28=FIELDVALUE(C28,B28) = LondonCapital/major cityUnited Kingdom
29=FIELDVALUE(C28,B29) = EnglishOfficial language 
30=FIELDVALUE(C28,B30) = 66,834,405_ Population 
31=FIELDVALUE(C28,B31) = #FIELD!Invalid Field 

1 - What is the 52 week high for this particular Stocks linked data type.
2 - What is the 52 week low for this particular Stocks linked data type.
8 - What is the number of employees for this particular Stock linked data type.
28 - What is the capital city of this particular Geography linked data type.
29 - What is the official language of this particular Geography linked data type.
30 - What is the population of this particular Geography linked data type.
31 - If the fieldname is not valid then, #FIELD! is returned.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top