FIELDVALUE

FIELDVALUE(value, field_name)

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

value	The company name (for stocks) or region name (for geography).
field_name	The name (or names) of the fields you want.

REMARKS

* This function was 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 "ABB" 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 first released in March 2020.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	MICROSOFT CORPORATION (XNAS:MSFT)
2	=FIELDVALUE(A1, B2) = $430.82	52 week high
3	=FIELDVALUE(A1, B3) = $275.37	52 week low
4	=FIELDVALUE(A1, B4) = $0.89	Beta
5	=FIELDVALUE(A1, B5) = $2.06	Change
6	=FIELDVALUE(A1, B6) = $0.00	Change (%)
7	=FIELDVALUE(A1, B7) = USD	Currency
8	=FIELDVALUE(C1,B7) = [full description]	Description
9	=FIELDVALUE(A1, B9) = 221,000_	Employees
10	=FIELDVALUE(A1, B10) = XNAS	Exchange abbreviation
11	=FIELDVALUE(C1,B10) = 1 Microsoft Way	Headquarters
12	=FIELDVALUE(A1, B12) = $427.89	High
13	=FIELDVALUE(A1, B13) = Software & IT Services	Industry
14	=FIELDVALUE(A1, B14) = Stock	Instrument type
15	=FIELDVALUE(A1, B15) = 6:43:15 PM	Last trade time
16	=FIELDVALUE(A1, B16) = $422.22	Low
17	=FIELDVALUE(A1, B17) = 3,141,439,732,080_	Market cap
18	=FIELDVALUE(A1, B18) = MICROSOFT CORPORATION	Name
19	=FIELDVALUE(A1, B19) = MICROSOFT CORPORATION	Official name
20	=FIELDVALUE(A1, B20) = $423.91	Open
21	=FIELDVALUE(A1, B21) = $38.05	P/E
22	=FIELDVALUE(A1, B22) = $420.72	Previous close
23	=FIELDVALUE(A1, B23) = $422.78	Price
24	=FIELDVALUE(A1, B24) = 7,430,436,000_	Shares outstanding
25	=FIELDVALUE(A1, B25) = MSFT	Ticker symbol
26	=FIELDVALUE(A1, B26) = 9,541,339_	Volume
27	=FIELDVALUE(A1, B27) = 20,756,031_	Volume average
28	=FIELDVALUE(A1, B28) = 1993_	Year incorporated
29	United Kingdom
30	=FIELDVALUE(A29, B30) = London	Capital/major city
31	=FIELDVALUE(A29, B31) = English	Official language
32	=FIELDVALUE(A29, B32) = 66,834,405_	Population
33	=FIELDVALUE(A29, B33) = #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.