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 Excel 2024.
* 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) = $468.35	52 week high
3	=FIELDVALUE(A1, B3) = $366.50	52 week low
4	=FIELDVALUE(A1, B4) = $0.89	Beta
5	=FIELDVALUE(A1, B5) = -$3.33	Change
6	=FIELDVALUE(A1, B6) = -$0.01	Change (%)
7	=FIELDVALUE(A1, B7) = USD	Currency
8	=FIELDVALUE(C1,B7) = [full description]	Description
9	=FIELDVALUE(A1, B9) = 228,000_	Employees
10	=FIELDVALUE(A1, B10) = XNAS	Exchange abbreviation
11	=FIELDVALUE(C1,B10) = 1 Microsoft Way	Headquarters
12	=FIELDVALUE(A1, B12) = $426.73	High
13	=FIELDVALUE(A1, B13) = Software & IT Services	Industry
14	=FIELDVALUE(A1, B14) = Stock	Instrument type
15	=FIELDVALUE(A1, B15) = 12:59:45 AM	Last trade time
16	=FIELDVALUE(A1, B16) = $420.66	Low
17	=FIELDVALUE(A1, B17) = 3,133,802,341,500_	Market cap
18	=FIELDVALUE(A1, B18) = MICROSOFT CORPORATION	Name
19	=FIELDVALUE(A1, B19) = MICROSOFT CORPORATION	Official name
20	=FIELDVALUE(A1, B20) = $426.10	Open
21	=FIELDVALUE(A1, B21) = $34.79	P/E
22	=FIELDVALUE(A1, B22) = $424.83	Previous close
23	=FIELDVALUE(A1, B23) = $421.50	Price
24	=FIELDVALUE(A1, B24) = 7,434,881,000_	Shares outstanding
25	=FIELDVALUE(A1, B25) = MSFT	Ticker symbol
26	=FIELDVALUE(A1, B26) = 13,246,509_	Volume
27	=FIELDVALUE(A1, B27) = 21,489,228_	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.