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 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) = $219.1352 week low 
3=FIELDVALUE(C1,B3) = $0.94Beta 
4=FIELDVALUE(C1,B4) = -$3.74Change 
5=FIELDVALUE(C1,B5) = -$0.02Change (%) 
6=FIELDVALUE(C1,B6) = USDCurrency 
7=FIELDVALUE(C1,B7) = [full description]Description 
8=FIELDVALUE(C1,B8) = 221,000_ Employees 
9=FIELDVALUE(C1,B9) = XNASExchange abbreviation 
10=FIELDVALUE(C1,B10) = 1 Microsoft WayHeadquarters 
11=FIELDVALUE(C1,B11) = $234.92High 
12=FIELDVALUE(C1,B12) = Software & IT ServicesIndustry 
13=FIELDVALUE(C1,B13) = StockInstrument type 
14=FIELDVALUE(C1,B14) = 11:59:40 PMLast trade time 
15=FIELDVALUE(C1,B15) = $231.15Low 
16=FIELDVALUE(C1,B16) = 1,730,406,817,490_ Market cap 
17=FIELDVALUE(C1,B17) = MICROSOFT CORPORATIONName 
18=FIELDVALUE(C1,B18) = MICROSOFT CORPORATIONOfficial name 
19=FIELDVALUE(C1,B19) = $233.76Open 
20=FIELDVALUE(C1,B20) = $25.01P/E 
21=FIELDVALUE(C1,B21) = $235.87Previous close 
22=FIELDVALUE(C1,B22) = $232.13Price 
23=FIELDVALUE(C1,B23) = 7,454,473,000_ Shares outstanding 
24=FIELDVALUE(C1,B24) = MSFTTicker symbol 
25=FIELDVALUE(C1,B25) = 28,357,265_ Volume 
26=FIELDVALUE(C1,B26) = 31,597,248_ 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