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

* Only available 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.
* This function was released in March 2020.
* You can use the STOCKHISTORY function to return historical data about a financial instrument.
* For the Microsoft documentation refer to support.microsoft.com

 ABC
1=FIELDVALUE(C1,B1) = $190.7052 week highMicrosoft Corp (XNAS:MSFT)
2=FIELDVALUE(C1,B2) = $110.9852 week low 
3=FIELDVALUE(C1,B3) = $1.09Beta 
4=FIELDVALUE(C1,B4) = $10.30Change 
5=FIELDVALUE(C1,B5) = 6.84%Change (%) 
6=FIELDVALUE(C1,B6) = Currency 
7=FIELDVALUE(C1,B7) = [see below for full description]Description 
8=FIELDVALUE(C1,B8) = Employees 
9=FIELDVALUE(C1,B9) = Exchange abbreviation 
10=FIELDVALUE(C1,B10) = Headquarters 
11=FIELDVALUE(C1,B11) = High 
12=FIELDVALUE(C1,B12) = Industry 
13=FIELDVALUE(C1,B13) = Instrument type 
14=FIELDVALUE(C1,B14) = Last trade time 
15=FIELDVALUE(C1,B15) = Low 
16=FIELDVALUE(C1,B16) = Market cap 
17=FIELDVALUE(C1,B17) = Name 
18=FIELDVALUE(C1,B18) = Official name 
19=FIELDVALUE(C1,B19) = Open 
20=FIELDVALUE(C1,B20) = P/E 
21=FIELDVALUE(C1,B21) = Previous close 
22=FIELDVALUE(C1,B22) = Price 
23=FIELDVALUE(C1,B23) = Shares outstanding 
24=FIELDVALUE(C1,B24) = Ticker symbol 
25=FIELDVALUE(C1,B25) = Volume 
26=FIELDVALUE(C1,B26) = Volume average 
27=FIELDVALUE(C1,B27) = Year incorporated 
28=FIELDVALUE(C1,B28) = Capital 
29=FIELDVALUE(C1,B29) = Population 

Cell "C1" contains a Stocks linked data type. To create this type "Microsoft Corp" into a cell and select Data Tab, Stocks.
Cell "C28" contain a Geography linked data type. To create this type "United Kingdom" into a cell and select Data Tab, Geography.
7 - What is the "description" of this company. "Microsoft Corporation is a technology company. The Company develops, licenses, and supports a range of software products, services and devices. The Company's segments include Productivity and Business Processes, Intelligent Cloud and More Personal Computing. The Company's products include operating systems; cross-device productivity applications; server applications; business solution applications; desktop and server management tools; software development tools; video games, and training and certification of computer system integrators and developers. It also designs, manufactures, and sells devices, including personal computers (PCs), tablets, gaming and entertainment consoles, phones, other intelligent devices, and related accessories, that integrate with its cloud-based offerings. It offers an array of services, including cloud-based solutions that provide customers with software, services, platforms, and content, and it provides solution support and consulting services."

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