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
* 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

 AB
1MICROSOFT CORPORATION (XNAS:MSFT) 
2=FIELDVALUE(A1, B2) = $468.3552 week high
3=FIELDVALUE(A1, B3) = $309.4552 week low
4=FIELDVALUE(A1, B4) = $0.89Beta
5=FIELDVALUE(A1, B5) = $3.59Change
6=FIELDVALUE(A1, B6) = $0.01Change (%)
7=FIELDVALUE(A1, B7) = USDCurrency
8=FIELDVALUE(C1,B7) = [full description]Description
9=FIELDVALUE(A1, B9) = 228,000_ Employees
10=FIELDVALUE(A1, B10) = XNASExchange abbreviation
11=FIELDVALUE(C1,B10) = 1 Microsoft WayHeadquarters
12=FIELDVALUE(A1, B12) = $431.83High
13=FIELDVALUE(A1, B13) = Software & IT ServicesIndustry
14=FIELDVALUE(A1, B14) = StockInstrument type
15=FIELDVALUE(A1, B15) = 11:59:48 PMLast trade time
16=FIELDVALUE(A1, B16) = $425.46Low
17=FIELDVALUE(A1, B17) = 3,200,592,263,010_ Market cap
18=FIELDVALUE(A1, B18) = MICROSOFT CORPORATIONName
19=FIELDVALUE(A1, B19) = MICROSOFT CORPORATIONOfficial name
20=FIELDVALUE(A1, B20) = $425.83Open
21=FIELDVALUE(A1, B21) = $36.49P/E
22=FIELDVALUE(A1, B22) = $427.00Previous close
23=FIELDVALUE(A1, B23) = $430.59Price
24=FIELDVALUE(A1, B24) = 7,433,039,000_ Shares outstanding
25=FIELDVALUE(A1, B25) = MSFTTicker symbol
26=FIELDVALUE(A1, B26) = 15,874,555_ Volume
27=FIELDVALUE(A1, B27) = 17,868,304_ Volume average
28=FIELDVALUE(A1, B28) = 1993_ Year incorporated
29United Kingdom 
30=FIELDVALUE(A29, B30) = LondonCapital/major city
31=FIELDVALUE(A29, B31) = EnglishOfficial 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.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top